ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where date = "2020-03-04" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
fips >30
county >30
- Alameda 1
- Bergen 1
- Bexar 1
- Chelan 1
- Contra Costa 1
- Cook 1
- Dane 1
- Douglas 1
- Fort Bend 1
- Fulton 1
- Grafton 1
- Hillsborough 1
- Humboldt 1
- King 1
- Los Angeles 1
- Manatee 1
- Maricopa 1
- Marin 1
- Napa 1
- New York City 1
- Norfolk 1
- Orange 1
- Placer 1
- Sacramento 1
- Salt Lake 1
- San Diego 1
- San Francisco 1
- San Mateo 1
- Santa Clara 1
- Snohomish 1
- …
state 17
- California 15
- Washington 5
- Florida 2
- Massachusetts 2
- New York 2
- Texas 2
- Arizona 1
- Georgia 1
- Illinois 1
- Nebraska 1
- New Hampshire 1
- New Jersey 1
- North Carolina 1
- Oregon 1
- Rhode Island 1
- Utah 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
494 | 494 | 2020-03-04 | Maricopa | Arizona | 4013 | 2 | 0 |
495 | 495 | 2020-03-04 | Alameda | California | 6001 | 2 | 0 |
496 | 496 | 2020-03-04 | Contra Costa | California | 6013 | 1 | 0 |
497 | 497 | 2020-03-04 | Humboldt | California | 6023 | 1 | 0 |
498 | 498 | 2020-03-04 | Los Angeles | California | 6037 | 7 | 0 |
499 | 499 | 2020-03-04 | Marin | California | 6041 | 1 | 0 |
500 | 500 | 2020-03-04 | Napa | California | 6055 | 1 | 0 |
501 | 501 | 2020-03-04 | Orange | California | 6059 | 3 | 0 |
502 | 502 | 2020-03-04 | Placer | California | 6061 | 2 | 1 |
503 | 503 | 2020-03-04 | Sacramento | California | 6067 | 3 | 0 |
504 | 504 | 2020-03-04 | San Diego | California | 6073 | 1 | 0 |
505 | 505 | 2020-03-04 | San Francisco | California | 6075 | 3 | 0 |
506 | 506 | 2020-03-04 | San Mateo | California | 6081 | 1 | 0 |
507 | 507 | 2020-03-04 | Santa Clara | California | 6085 | 14 | 0 |
508 | 508 | 2020-03-04 | Solano | California | 6095 | 12 | 0 |
509 | 509 | 2020-03-04 | Sonoma | California | 6097 | 3 | 0 |
510 | 510 | 2020-03-04 | Hillsborough | Florida | 12057 | 2 | 0 |
511 | 511 | 2020-03-04 | Manatee | Florida | 12081 | 1 | 0 |
512 | 512 | 2020-03-04 | Fulton | Georgia | 13121 | 2 | 0 |
513 | 513 | 2020-03-04 | Cook | Illinois | 17031 | 4 | 0 |
514 | 514 | 2020-03-04 | Norfolk | Massachusetts | 25021 | 1 | 0 |
515 | 515 | 2020-03-04 | Suffolk | Massachusetts | 25025 | 1 | 0 |
516 | 516 | 2020-03-04 | Douglas | Nebraska | 31055 | 13 | 0 |
517 | 517 | 2020-03-04 | Grafton | New Hampshire | 33009 | 2 | 0 |
518 | 518 | 2020-03-04 | Bergen | New Jersey | 34003 | 1 | 0 |
519 | 519 | 2020-03-04 | New York City | New York | 2 | 0 | |
520 | 520 | 2020-03-04 | Westchester | New York | 36119 | 9 | 0 |
521 | 521 | 2020-03-04 | Wake | North Carolina | 37183 | 1 | 0 |
522 | 522 | 2020-03-04 | Washington | Oregon | 41067 | 2 | 0 |
523 | 523 | 2020-03-04 | Unknown | Rhode Island | 2 | 0 | |
524 | 524 | 2020-03-04 | Bexar | Texas | 48029 | 11 | 0 |
525 | 525 | 2020-03-04 | Fort Bend | Texas | 48157 | 1 | 0 |
526 | 526 | 2020-03-04 | Salt Lake | Utah | 49035 | 1 | 0 |
527 | 527 | 2020-03-04 | Chelan | Washington | 53007 | 1 | 0 |
528 | 528 | 2020-03-04 | King | Washington | 53033 | 33 | 11 |
529 | 529 | 2020-03-04 | Snohomish | Washington | 53061 | 8 | 0 |
530 | 530 | 2020-03-04 | Spokane | Washington | 53063 | 4 | 0 |
531 | 531 | 2020-03-04 | Walla Walla | Washington | 53071 | 1 | 0 |
532 | 532 | 2020-03-04 | Dane | Wisconsin | 55025 | 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);