...\CountyCovid.yxdb
False
True
CountyCovid.yxdb
...\MapPrep.yxdb
False
True
MapPrep.yxdb
COUNTY COVID
https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_daily_reports/05-16-2020.csv
URL
String
65001
GET
Compose
2
600
DownloadData
DownloadData
Last
!IsEmpty([Admin2]) && [Admin2]!='Unassigned' && !IsEmpty([Province_State]) && [Country_Region]='US'
Custom
!IsEmpty([Admin2]) && [Admin2]!='Unassigned' && !IsEmpty([Province_State]) && [C...
FirstRow
Warn
Error
...\AllocateCounty.yxdb
AllocateCounty.yxdb
...\AllocateState.yxdb
AllocateState.yxdb
Double
IsEmpty([Lat]) || IsEmpty([Lon])
Custom
IsEmpty([Lat]) || IsEmpty([Lon])
Centroid Where Target Within Universe CountySpObj
Warning
All
ByName
IsEmpty([MetroKey])
Custom
IsEmpty([MetroKey])
Warning
All
ByName
StateKey - Ascending
MetroKey - Ascending
CountyKey - Ascending
StateKey - Ascending
MetroKey - Ascending
CountyKey - Ascending
URL = Replace([URL],'05-16-2020',DateTimeFormat(DateTimeAdd(DateTimeNow(),-1,'da...
AK
Alaska
AL
Alabama
AR
Arkansas
AZ
Arizona
CA
California
CO
Colorado
CT
Connecticut
DC
District of Columbia
DE
Delaware
FL
Florida
GA
Georgia
HI
Hawaii
IA
Iowa
ID
Idaho
IL
Illinois
IN
Indiana
KS
Kansas
KY
Kentucky
LA
Louisiana
MA
Massachusetts
MD
Maryland
ME
Maine
MI
Michigan
MN
Minnesota
MO
Missouri
MS
Mississippi
MT
Montana
NC
North Carolina
ND
North Dakota
NE
Nebraska
NH
New Hampshire
NJ
New Jersey
NM
New Mexico
NV
Nevada
NY
New York
OH
Ohio
OK
Oklahoma
OR
Oregon
PA
Pennsylvania
PR
Puerto Rico
RI
Rhode Island
SC
South Carolina
SD
South Dakota
TN
Tennessee
TX
Texas
UT
Utah
VA
Virginia
VT
Vermont
WA
Washington
WI
Wisconsin
WV
West Virginia
WY
Wyoming
MAP PREP
...\AllocateMetro.yxdb
AllocateMetro.yxdb
Warning
All
ByName
Warning
All
ByName
IsEmpty([MetroKey])
Custom
IsEmpty([MetroKey])
Warning
All
ByName
StateKey - Ascending
MetroKey - Ascending
...\AllocateState.yxdb
AllocateState.yxdb
...\AllocateCounty.yxdb
AllocateCounty.yxdb
Error
Vertical
DPC_AND_MAP_PREP