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

This data as json, CSV (advanced)

Suggested facets: date (date)

fips

  • 2,843

county

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