ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

16,607 rows where fips = "" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

county

fips

  • - · 16,607 ✖
Link rowid date ▲ county state fips cases deaths
1816704 1816704 2021-10-15 Unknown Alaska   509 1
1816709 1816709 2021-10-15 Unknown American Samoa   1 0
1816795 1816795 2021-10-15 Unknown Arkansas   5109 0
1816930 1816930 2021-10-15 Unknown Connecticut   1347 9
1816935 1816935 2021-10-15 Unknown Delaware   374 0
1817000 1817000 2021-10-15 Unknown Florida   1 1182
1817149 1817149 2021-10-15 Unknown Georgia   4630 8
1817165 1817165 2021-10-15 Unknown Guam   17764 223
1817171 1817171 2021-10-15 Unknown Hawaii   0 2
1817307 1817307 2021-10-15 Unknown Illinois   0 763
1817499 1817499 2021-10-15 Unknown Iowa   16 0
1817792 1817792 2021-10-15 Unknown Louisiana   575 0
1817814 1817814 2021-10-15 Unknown Maine   14 0
1817839 1817839 2021-10-15 Unknown Maryland   2 60
1817856 1817856 2021-10-15 Unknown Massachusetts   56800 13
1817937 1817937 2021-10-15 Unknown Michigan   1048 13
1818020 1818020 2021-10-15 Unknown Minnesota   652 124
1818163 1818163 2021-10-15 Joplin Missouri   8634 150
1818164 1818164 2021-10-15 Kansas City Missouri   62491 814
1818372 1818372 2021-10-15 Unknown Nebraska   1701 0
1818406 1818406 2021-10-15 Unknown New Hampshire   889 1
1818427 1818427 2021-10-15 Unknown New Jersey   616 0
1818490 1818490 2021-10-15 New York City New York   1105853 34438
1818669 1818669 2021-10-15 Unknown North Dakota   34 34
1818756 1818756 2021-10-15 Unknown Ohio   0 4
1818837 1818837 2021-10-15 Unknown Oklahoma   4431 0
1819017 1819017 2021-10-15 Unknown Puerto Rico   5389 3205
1819029 1819029 2021-10-15 Unknown Rhode Island   13241 12
1819230 1819230 2021-10-15 Unknown Tennessee   8497 117
1819517 1819517 2021-10-15 Unknown Utah   1763 35
1819534 1819534 2021-10-15 Unknown Vermont   40 0
1813456 1813456 2021-10-14 Unknown Alaska   503 1
1813461 1813461 2021-10-14 Unknown American Samoa   1 0
1813547 1813547 2021-10-14 Unknown Arkansas   5105 0
1813682 1813682 2021-10-14 Unknown Connecticut   1344 11
1813687 1813687 2021-10-14 Unknown Delaware   373 0
1813752 1813752 2021-10-14 Unknown Florida   15895 2411
1813901 1813901 2021-10-14 Unknown Georgia   4602 8
1813917 1813917 2021-10-14 Unknown Guam   17659 223
1813923 1813923 2021-10-14 Unknown Hawaii   0 2
1814059 1814059 2021-10-14 Unknown Illinois   0 747
1814251 1814251 2021-10-14 Unknown Iowa   16 0
1814544 1814544 2021-10-14 Unknown Louisiana   571 0
1814590 1814590 2021-10-14 Unknown Maryland   2 71
1814607 1814607 2021-10-14 Unknown Massachusetts   56664 13
1814688 1814688 2021-10-14 Unknown Michigan   802 12
1814771 1814771 2021-10-14 Unknown Minnesota   656 124
1814914 1814914 2021-10-14 Joplin Missouri   8628 151
1814915 1814915 2021-10-14 Kansas City Missouri   62408 812
1815123 1815123 2021-10-14 Unknown Nebraska   1713 0
1815157 1815157 2021-10-14 Unknown New Hampshire   898 1
1815178 1815178 2021-10-14 Unknown New Jersey   638 0
1815241 1815241 2021-10-14 New York City New York   1103818 34442
1815420 1815420 2021-10-14 Unknown North Dakota   34 34
1815507 1815507 2021-10-14 Unknown Ohio   0 5
1815588 1815588 2021-10-14 Unknown Oklahoma   3252 0
1815768 1815768 2021-10-14 Unknown Puerto Rico   5399 3201
1815780 1815780 2021-10-14 Unknown Rhode Island   12926 12
1815981 1815981 2021-10-14 Unknown Tennessee   8653 117
1816268 1816268 2021-10-14 Unknown Utah   1763 35
1816285 1816285 2021-10-14 Unknown Vermont   27 0
1810207 1810207 2021-10-13 Unknown Alaska   502 1
1810212 1810212 2021-10-13 Unknown American Samoa   1 0
1810298 1810298 2021-10-13 Unknown Arkansas   5107 0
1810433 1810433 2021-10-13 Unknown Connecticut   1339 11
1810438 1810438 2021-10-13 Unknown Delaware   370 0
1810503 1810503 2021-10-13 Unknown Florida   12518 2003
1810652 1810652 2021-10-13 Unknown Georgia   4586 7
1810668 1810668 2021-10-13 Unknown Guam   17564 220
1810674 1810674 2021-10-13 Unknown Hawaii   0 2
1810810 1810810 2021-10-13 Unknown Illinois   0 734
1811002 1811002 2021-10-13 Unknown Iowa   16 0
1811295 1811295 2021-10-13 Unknown Louisiana   571 0
1811317 1811317 2021-10-13 Unknown Maine   8 0
1811342 1811342 2021-10-13 Unknown Maryland   1 79
1811359 1811359 2021-10-13 Unknown Massachusetts   56441 13
1811440 1811440 2021-10-13 Unknown Michigan   1094 15
1811523 1811523 2021-10-13 Unknown Minnesota   650 124
1811666 1811666 2021-10-13 Joplin Missouri   8626 151
1811667 1811667 2021-10-13 Kansas City Missouri   62328 810
1811875 1811875 2021-10-13 Unknown Nebraska   1739 0
1811909 1811909 2021-10-13 Unknown New Hampshire   921 1
1811930 1811930 2021-10-13 Unknown New Jersey   648 0
1811993 1811993 2021-10-13 New York City New York   1102649 34434
1812172 1812172 2021-10-13 Unknown North Dakota   34 34
1812259 1812259 2021-10-13 Unknown Ohio   0 5
1812340 1812340 2021-10-13 Unknown Oklahoma   2071 0
1812520 1812520 2021-10-13 Unknown Puerto Rico   5407 3199
1812532 1812532 2021-10-13 Unknown Rhode Island   12613 9
1812733 1812733 2021-10-13 Unknown Tennessee   8432 117
1813020 1813020 2021-10-13 Unknown Utah   1752 37
1813037 1813037 2021-10-13 Unknown Vermont   108 0
1806958 1806958 2021-10-12 Unknown Alaska   502 1
1806963 1806963 2021-10-12 Unknown American Samoa   1 0
1807049 1807049 2021-10-12 Unknown Arkansas   5104 0
1807184 1807184 2021-10-12 Unknown Connecticut   1341 11
1807189 1807189 2021-10-12 Unknown Delaware   369 0
1807254 1807254 2021-10-12 Unknown Florida   10013 2000
1807403 1807403 2021-10-12 Unknown Georgia   4546 9
1807419 1807419 2021-10-12 Unknown Guam   17430 218

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);