ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
255 rows where date = "2020-03-12" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
state >30
- California 25
- Florida 20
- Washington 17
- New York 13
- Georgia 12
- New Jersey 11
- Oregon 11
- Colorado 10
- Virginia 9
- Indiana 8
- Pennsylvania 8
- Texas 8
- Michigan 7
- Minnesota 7
- North Carolina 7
- Massachusetts 6
- South Dakota 5
- Tennessee 5
- Illinois 4
- Kentucky 4
- Maryland 4
- South Carolina 4
- Utah 4
- Wisconsin 4
- Arizona 3
- Iowa 3
- Louisiana 3
- Nevada 3
- New Mexico 3
- Ohio 3
- …
fips >30
county >30
- Jefferson 5
- Montgomery 4
- Douglas 3
- Johnson 3
- Adams 2
- Clark 2
- Delaware 2
- Essex 2
- Fayette 2
- Lee 2
- Marion 2
- Middlesex 2
- Monroe 2
- Nassau 2
- Orange 2
- Pierce 2
- Polk 2
- Suffolk 2
- Unknown 2
- Washington 2
- Wayne 2
- Alachua 1
- Alameda 1
- Albany 1
- Alexandria city 1
- Anchorage 1
- Androscoggin 1
- Anoka 1
- Arapahoe 1
- Arlington 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1365 | 1365 | 2020-03-12 | Anchorage | Alaska | 2020 | 1 | 0 |
1366 | 1366 | 2020-03-12 | Maricopa | Arizona | 4013 | 3 | 0 |
1367 | 1367 | 2020-03-12 | Pima | Arizona | 4019 | 1 | 0 |
1368 | 1368 | 2020-03-12 | Pinal | Arizona | 4021 | 5 | 0 |
1369 | 1369 | 2020-03-12 | Jefferson | Arkansas | 5069 | 1 | 0 |
1370 | 1370 | 2020-03-12 | Pulaski | Arkansas | 5119 | 5 | 0 |
1371 | 1371 | 2020-03-12 | Alameda | California | 6001 | 29 | 0 |
1372 | 1372 | 2020-03-12 | Contra Costa | California | 6013 | 9 | 0 |
1373 | 1373 | 2020-03-12 | Fresno | California | 6019 | 1 | 0 |
1374 | 1374 | 2020-03-12 | Humboldt | California | 6023 | 1 | 0 |
1375 | 1375 | 2020-03-12 | Los Angeles | California | 6037 | 32 | 1 |
1376 | 1376 | 2020-03-12 | Madera | California | 6039 | 1 | 0 |
1377 | 1377 | 2020-03-12 | Marin | California | 6041 | 4 | 0 |
1378 | 1378 | 2020-03-12 | Napa | California | 6055 | 1 | 0 |
1379 | 1379 | 2020-03-12 | Orange | California | 6059 | 6 | 0 |
1380 | 1380 | 2020-03-12 | Placer | California | 6061 | 7 | 1 |
1381 | 1381 | 2020-03-12 | Riverside | California | 6065 | 6 | 0 |
1382 | 1382 | 2020-03-12 | Sacramento | California | 6067 | 16 | 1 |
1383 | 1383 | 2020-03-12 | San Diego | California | 6073 | 5 | 0 |
1384 | 1384 | 2020-03-12 | San Francisco | California | 6075 | 21 | 0 |
1385 | 1385 | 2020-03-12 | San Joaquin | California | 6077 | 3 | 0 |
1386 | 1386 | 2020-03-12 | San Mateo | California | 6081 | 20 | 0 |
1387 | 1387 | 2020-03-12 | Santa Clara | California | 6085 | 66 | 1 |
1388 | 1388 | 2020-03-12 | Santa Cruz | California | 6087 | 2 | 0 |
1389 | 1389 | 2020-03-12 | Shasta | California | 6089 | 1 | 0 |
1390 | 1390 | 2020-03-12 | Solano | California | 6095 | 12 | 0 |
1391 | 1391 | 2020-03-12 | Sonoma | California | 6097 | 3 | 0 |
1392 | 1392 | 2020-03-12 | Stanislaus | California | 6099 | 2 | 0 |
1393 | 1393 | 2020-03-12 | Tulare | California | 6107 | 1 | 0 |
1394 | 1394 | 2020-03-12 | Ventura | California | 6111 | 2 | 0 |
1395 | 1395 | 2020-03-12 | Yolo | California | 6113 | 1 | 0 |
1396 | 1396 | 2020-03-12 | Adams | Colorado | 8001 | 2 | 0 |
1397 | 1397 | 2020-03-12 | Arapahoe | Colorado | 8005 | 3 | 0 |
1398 | 1398 | 2020-03-12 | Denver | Colorado | 8031 | 9 | 0 |
1399 | 1399 | 2020-03-12 | Douglas | Colorado | 8035 | 3 | 0 |
1400 | 1400 | 2020-03-12 | Eagle | Colorado | 8037 | 11 | 0 |
1401 | 1401 | 2020-03-12 | El Paso | Colorado | 8041 | 1 | 1 |
1402 | 1402 | 2020-03-12 | Gunnison | Colorado | 8051 | 4 | 0 |
1403 | 1403 | 2020-03-12 | Jefferson | Colorado | 8059 | 5 | 0 |
1404 | 1404 | 2020-03-12 | Larimer | Colorado | 8069 | 1 | 0 |
1405 | 1405 | 2020-03-12 | Pitkin | Colorado | 8097 | 10 | 0 |
1406 | 1406 | 2020-03-12 | Fairfield | Connecticut | 9001 | 5 | 0 |
1407 | 1407 | 2020-03-12 | Litchfield | Connecticut | 9005 | 1 | 0 |
1408 | 1408 | 2020-03-12 | New Castle | Delaware | 10003 | 4 | 0 |
1409 | 1409 | 2020-03-12 | District of Columbia | District of Columbia | 11001 | 10 | 0 |
1410 | 1410 | 2020-03-12 | Alachua | Florida | 12001 | 2 | 0 |
1411 | 1411 | 2020-03-12 | Broward | Florida | 12011 | 12 | 0 |
1412 | 1412 | 2020-03-12 | Charlotte | Florida | 12015 | 1 | 0 |
1413 | 1413 | 2020-03-12 | Clay | Florida | 12019 | 1 | 0 |
1414 | 1414 | 2020-03-12 | Collier | Florida | 12021 | 3 | 0 |
1415 | 1415 | 2020-03-12 | Duval | Florida | 12031 | 1 | 0 |
1416 | 1416 | 2020-03-12 | Hillsborough | Florida | 12057 | 3 | 0 |
1417 | 1417 | 2020-03-12 | Lee | Florida | 12071 | 4 | 1 |
1418 | 1418 | 2020-03-12 | Manatee | Florida | 12081 | 2 | 0 |
1419 | 1419 | 2020-03-12 | Miami-Dade | Florida | 12086 | 2 | 0 |
1420 | 1420 | 2020-03-12 | Nassau | Florida | 12089 | 1 | 0 |
1421 | 1421 | 2020-03-12 | Okaloosa | Florida | 12091 | 1 | 0 |
1422 | 1422 | 2020-03-12 | Palm Beach | Florida | 12099 | 2 | 0 |
1423 | 1423 | 2020-03-12 | Pasco | Florida | 12101 | 1 | 0 |
1424 | 1424 | 2020-03-12 | Pinellas | Florida | 12103 | 2 | 0 |
1425 | 1425 | 2020-03-12 | Santa Rosa | Florida | 12113 | 1 | 1 |
1426 | 1426 | 2020-03-12 | Sarasota | Florida | 12115 | 2 | 0 |
1427 | 1427 | 2020-03-12 | Seminole | Florida | 12117 | 1 | 0 |
1428 | 1428 | 2020-03-12 | St. Johns | Florida | 12109 | 1 | 0 |
1429 | 1429 | 2020-03-12 | Volusia | Florida | 12127 | 3 | 0 |
1430 | 1430 | 2020-03-12 | Bartow | Georgia | 13015 | 3 | 0 |
1431 | 1431 | 2020-03-12 | Charlton | Georgia | 13049 | 1 | 0 |
1432 | 1432 | 2020-03-12 | Cherokee | Georgia | 13057 | 1 | 0 |
1433 | 1433 | 2020-03-12 | Cobb | Georgia | 13067 | 8 | 1 |
1434 | 1434 | 2020-03-12 | DeKalb | Georgia | 13089 | 4 | 0 |
1435 | 1435 | 2020-03-12 | Fayette | Georgia | 13113 | 1 | 0 |
1436 | 1436 | 2020-03-12 | Floyd | Georgia | 13115 | 2 | 0 |
1437 | 1437 | 2020-03-12 | Fulton | Georgia | 13121 | 6 | 0 |
1438 | 1438 | 2020-03-12 | Gwinnett | Georgia | 13135 | 2 | 0 |
1439 | 1439 | 2020-03-12 | Lee | Georgia | 13177 | 1 | 0 |
1440 | 1440 | 2020-03-12 | Lowndes | Georgia | 13185 | 1 | 0 |
1441 | 1441 | 2020-03-12 | Polk | Georgia | 13233 | 1 | 0 |
1442 | 1442 | 2020-03-12 | Honolulu | Hawaii | 15003 | 2 | 0 |
1443 | 1443 | 2020-03-12 | Cook | Illinois | 17031 | 27 | 0 |
1444 | 1444 | 2020-03-12 | Kane | Illinois | 17089 | 2 | 0 |
1445 | 1445 | 2020-03-12 | Lake | Illinois | 17097 | 1 | 0 |
1446 | 1446 | 2020-03-12 | McHenry | Illinois | 17111 | 2 | 0 |
1447 | 1447 | 2020-03-12 | Adams | Indiana | 18001 | 1 | 0 |
1448 | 1448 | 2020-03-12 | Boone | Indiana | 18011 | 1 | 0 |
1449 | 1449 | 2020-03-12 | Hendricks | Indiana | 18063 | 2 | 0 |
1450 | 1450 | 2020-03-12 | Howard | Indiana | 18067 | 1 | 0 |
1451 | 1451 | 2020-03-12 | Johnson | Indiana | 18081 | 3 | 0 |
1452 | 1452 | 2020-03-12 | Marion | Indiana | 18097 | 2 | 0 |
1453 | 1453 | 2020-03-12 | Noble | Indiana | 18113 | 1 | 0 |
1454 | 1454 | 2020-03-12 | St. Joseph | Indiana | 18141 | 1 | 0 |
1455 | 1455 | 2020-03-12 | Carroll | Iowa | 19027 | 1 | 0 |
1456 | 1456 | 2020-03-12 | Johnson | Iowa | 19103 | 14 | 0 |
1457 | 1457 | 2020-03-12 | Pottawattamie | Iowa | 19155 | 1 | 0 |
1458 | 1458 | 2020-03-12 | Johnson | Kansas | 20091 | 4 | 0 |
1459 | 1459 | 2020-03-12 | Wyandotte | Kansas | 20209 | 1 | 1 |
1460 | 1460 | 2020-03-12 | Fayette | Kentucky | 21067 | 4 | 0 |
1461 | 1461 | 2020-03-12 | Harrison | Kentucky | 21097 | 4 | 0 |
1462 | 1462 | 2020-03-12 | Jefferson | Kentucky | 21111 | 2 | 0 |
1463 | 1463 | 2020-03-12 | Montgomery | Kentucky | 21173 | 1 | 0 |
1464 | 1464 | 2020-03-12 | Caddo | Louisiana | 22017 | 1 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);