ny_times_us_counties

⚠️ 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

2,843 rows where county = "Unknown" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

  • 2,843

county

  • Unknown · 2,843
Link rowid date ▲ county state fips cases deaths
291850 2020-07-03 Unknown Alaska   7 0
291939 2020-07-03 Unknown Arkansas   783 0
292070 2020-07-03 Unknown Connecticut   213 0
292075 2020-07-03 Unknown Delaware   69 0
292140 2020-07-03 Unknown Florida   187 0
292289 2020-07-03 Unknown Georgia   1992 2
292305 2020-07-03 Unknown Guam   1255 6
292442 2020-07-03 Unknown Illinois   1122 210
292634 2020-07-03 Unknown Iowa   7 0
292918 2020-07-03 Unknown Louisiana   115 108
292940 2020-07-03 Unknown Maine   5 0
292965 2020-07-03 Unknown Maryland   0 23
292982 2020-07-03 Unknown Massachusetts   292 7
293062 2020-07-03 Unknown Michigan   153 2
293144 2020-07-03 Unknown Minnesota   113 37
293465 2020-07-03 Unknown Nebraska   96 0
293497 2020-07-03 Unknown New Hampshire   2 0
293518 2020-07-03 Unknown New Jersey   658 0
293754 2020-07-03 Unknown North Dakota   9 9
293759 2020-07-03 Unknown Northern Mariana Islands   31 2
294025 2020-07-03 Unknown Puerto Rico   7683 154
294030 2020-07-03 Unknown Rhode Island   1488 36
294502 2020-07-03 Unknown Utah   0 12
294518 2020-07-03 Unknown Vermont   5 0
294522 2020-07-03 Unknown Virgin Islands   111 6
294644 2020-07-03 Unknown Virginia   81 1
294809 2020-07-03 Unknown Wisconsin   3009 7
288773 2020-07-02 Unknown Alaska   13 0
288862 2020-07-02 Unknown Arkansas   737 0
288993 2020-07-02 Unknown Connecticut   211 0
288998 2020-07-02 Unknown Delaware   53 0
289063 2020-07-02 Unknown Florida   172 0
289212 2020-07-02 Unknown Georgia   2764 2
289228 2020-07-02 Unknown Guam   1249 6
289363 2020-07-02 Unknown Illinois   1057 201
289555 2020-07-02 Unknown Iowa   7 0
289839 2020-07-02 Unknown Louisiana   113 108
289861 2020-07-02 Unknown Maine   6 0
289886 2020-07-02 Unknown Maryland   0 26
289903 2020-07-02 Unknown Massachusetts   287 7
289983 2020-07-02 Unknown Michigan   172 2
290065 2020-07-02 Unknown Minnesota   119 37
290416 2020-07-02 Unknown New Hampshire   1 0
290437 2020-07-02 Unknown New Jersey   672 0
290673 2020-07-02 Unknown North Dakota   9 9
290678 2020-07-02 Unknown Northern Mariana Islands   30 2
290759 2020-07-02 Unknown Ohio   1301 27
290945 2020-07-02 Unknown Puerto Rico   7608 153
290950 2020-07-02 Unknown Rhode Island   1712 35
291419 2020-07-02 Unknown Utah   0 10
291435 2020-07-02 Unknown Vermont   5 0
291439 2020-07-02 Unknown Virgin Islands   98 6
291561 2020-07-02 Unknown Virginia   80 1
291726 2020-07-02 Unknown Wisconsin   2966 7
285699 2020-07-01 Unknown Alaska   13 0
285787 2020-07-01 Unknown Arkansas   706 0
285918 2020-07-01 Unknown Connecticut   209 0
285923 2020-07-01 Unknown Delaware   42 0
285988 2020-07-01 Unknown Florida   167 0
286137 2020-07-01 Unknown Georgia   2395 2
286153 2020-07-01 Unknown Guam   1240 6
286288 2020-07-01 Unknown Illinois   1053 201
286480 2020-07-01 Unknown Iowa   4 0
286764 2020-07-01 Unknown Louisiana   111 108
286786 2020-07-01 Unknown Maine   2 0
286811 2020-07-01 Unknown Maryland   0 25
286828 2020-07-01 Unknown Massachusetts   346 7
286908 2020-07-01 Unknown Michigan   167 2
286990 2020-07-01 Unknown Minnesota   118 37
287340 2020-07-01 Unknown New Hampshire   1 0
287361 2020-07-01 Unknown New Jersey   643 0
287597 2020-07-01 Unknown North Dakota   9 9
287602 2020-07-01 Unknown Northern Mariana Islands   30 2
287868 2020-07-01 Unknown Puerto Rico   7537 153
287873 2020-07-01 Unknown Rhode Island   1624 32
288067 2020-07-01 Unknown Tennessee   0 1
288343 2020-07-01 Unknown Utah   0 10
288359 2020-07-01 Unknown Vermont   6 0
288363 2020-07-01 Unknown Virgin Islands   90 6
288485 2020-07-01 Unknown Virginia   78 1
288650 2020-07-01 Unknown Wisconsin   2921 7
282626 2020-06-30 Unknown Alaska   11 0
282714 2020-06-30 Unknown Arkansas   721 0
282845 2020-06-30 Unknown Connecticut   204 0
282850 2020-06-30 Unknown Delaware   38 0
282915 2020-06-30 Unknown Florida   145 0
283064 2020-06-30 Unknown Georgia   2699 2
283080 2020-06-30 Unknown Guam   1228 6
283085 2020-06-30 Unknown Hawaii   1 0
283216 2020-06-30 Unknown Illinois   1053 201
283408 2020-06-30 Unknown Iowa   3 0
283692 2020-06-30 Unknown Louisiana   110 108
283714 2020-06-30 Unknown Maine   2 0
283739 2020-06-30 Unknown Maryland   0 29
283756 2020-06-30 Unknown Massachusetts   288 7
283836 2020-06-30 Unknown Michigan   164 2
283918 2020-06-30 Unknown Minnesota   118 35
284267 2020-06-30 Unknown New Hampshire   1 0
284288 2020-06-30 Unknown New Jersey   642 0
284524 2020-06-30 Unknown North Dakota   9 9

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
);
Powered by Datasette · Query took 943.901ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette