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

1,141 rows where county = "Lawrence" sorted by date descending

View and edit SQL

Suggested facets: deaths, date (date)

fips

county

  • Lawrence · 1,141
Link rowid date ▲ county state fips cases deaths
316486 2020-07-11 Lawrence Alabama 1079 128 0
316593 2020-07-11 Lawrence Arkansas 5075 115 9
317088 2020-07-11 Lawrence Illinois 17101 12 0
317187 2020-07-11 Lawrence Indiana 18093 253 26
317496 2020-07-11 Lawrence Kentucky 21127 11 0
317884 2020-07-11 Lawrence Mississippi 28077 209 2
317984 2020-07-11 Lawrence Missouri 29109 58 1
318499 2020-07-11 Lawrence Ohio 39087 83 0
318692 2020-07-11 Lawrence Pennsylvania 42073 171 9
318814 2020-07-11 Lawrence South Dakota 46081 20 0
318889 2020-07-11 Lawrence Tennessee 47099 232 6
313388 2020-07-10 Lawrence Alabama 1079 124 0
313495 2020-07-10 Lawrence Arkansas 5075 112 9
313990 2020-07-10 Lawrence Illinois 17101 9 0
314089 2020-07-10 Lawrence Indiana 18093 253 26
314398 2020-07-10 Lawrence Kentucky 21127 11 0
314786 2020-07-10 Lawrence Mississippi 28077 202 2
314886 2020-07-10 Lawrence Missouri 29109 54 1
315399 2020-07-10 Lawrence Ohio 39087 82 0
315592 2020-07-10 Lawrence Pennsylvania 42073 159 9
315714 2020-07-10 Lawrence South Dakota 46081 19 0
315788 2020-07-10 Lawrence Tennessee 47099 227 6
310296 2020-07-09 Lawrence Alabama 1079 120 0
310403 2020-07-09 Lawrence Arkansas 5075 111 9
310898 2020-07-09 Lawrence Illinois 17101 8 0
310997 2020-07-09 Lawrence Indiana 18093 252 26
311304 2020-07-09 Lawrence Kentucky 21127 11 0
311692 2020-07-09 Lawrence Mississippi 28077 199 2
311792 2020-07-09 Lawrence Missouri 29109 53 1
312303 2020-07-09 Lawrence Ohio 39087 79 0
312495 2020-07-09 Lawrence Pennsylvania 42073 146 9
312617 2020-07-09 Lawrence South Dakota 46081 19 0
312691 2020-07-09 Lawrence Tennessee 47099 202 6
307201 2020-07-08 Lawrence Alabama 1079 116 0
307308 2020-07-08 Lawrence Arkansas 5075 107 9
307804 2020-07-08 Lawrence Illinois 17101 8 0
307903 2020-07-08 Lawrence Indiana 18093 249 26
308210 2020-07-08 Lawrence Kentucky 21127 11 0
308598 2020-07-08 Lawrence Mississippi 28077 189 2
308698 2020-07-08 Lawrence Missouri 29109 52 1
309211 2020-07-08 Lawrence Ohio 39087 74 0
309403 2020-07-08 Lawrence Pennsylvania 42073 141 9
309525 2020-07-08 Lawrence South Dakota 46081 19 0
309599 2020-07-08 Lawrence Tennessee 47099 192 6
304112 2020-07-07 Lawrence Alabama 1079 112 0
304218 2020-07-07 Lawrence Arkansas 5075 103 9
304714 2020-07-07 Lawrence Illinois 17101 8 0
304813 2020-07-07 Lawrence Indiana 18093 247 26
305120 2020-07-07 Lawrence Kentucky 21127 11 0
305508 2020-07-07 Lawrence Mississippi 28077 187 2
305607 2020-07-07 Lawrence Missouri 29109 48 1
306119 2020-07-07 Lawrence Ohio 39087 72 0
306311 2020-07-07 Lawrence Pennsylvania 42073 129 9
306431 2020-07-07 Lawrence South Dakota 46081 19 0
306505 2020-07-07 Lawrence Tennessee 47099 172 6
301023 2020-07-06 Lawrence Alabama 1079 113 0
301130 2020-07-06 Lawrence Arkansas 5075 103 9
301626 2020-07-06 Lawrence Illinois 17101 7 0
301725 2020-07-06 Lawrence Indiana 18093 247 26
302032 2020-07-06 Lawrence Kentucky 21127 10 0
302420 2020-07-06 Lawrence Mississippi 28077 178 2
302519 2020-07-06 Lawrence Missouri 29109 46 1
303030 2020-07-06 Lawrence Ohio 39087 71 0
303222 2020-07-06 Lawrence Pennsylvania 42073 124 9
303342 2020-07-06 Lawrence South Dakota 46081 19 0
303416 2020-07-06 Lawrence Tennessee 47099 164 6
297939 2020-07-05 Lawrence Alabama 1079 111 0
298046 2020-07-05 Lawrence Arkansas 5075 103 9
298541 2020-07-05 Lawrence Illinois 17101 7 0
298640 2020-07-05 Lawrence Indiana 18093 245 26
298945 2020-07-05 Lawrence Kentucky 21127 9 0
299333 2020-07-05 Lawrence Mississippi 28077 177 2
299432 2020-07-05 Lawrence Missouri 29109 45 1
299943 2020-07-05 Lawrence Ohio 39087 70 0
300135 2020-07-05 Lawrence Pennsylvania 42073 119 9
300254 2020-07-05 Lawrence South Dakota 46081 19 0
300328 2020-07-05 Lawrence Tennessee 47099 163 6
294855 2020-07-04 Lawrence Alabama 1079 110 0
294962 2020-07-04 Lawrence Arkansas 5075 102 9
295457 2020-07-04 Lawrence Illinois 17101 7 0
295556 2020-07-04 Lawrence Indiana 18093 243 26
295861 2020-07-04 Lawrence Kentucky 21127 9 0
296249 2020-07-04 Lawrence Mississippi 28077 174 1
296348 2020-07-04 Lawrence Missouri 29109 41 1
296860 2020-07-04 Lawrence Ohio 39087 68 0
297052 2020-07-04 Lawrence Pennsylvania 42073 114 9
297171 2020-07-04 Lawrence South Dakota 46081 19 0
297245 2020-07-04 Lawrence Tennessee 47099 157 6
291773 2020-07-03 Lawrence Alabama 1079 108 0
291880 2020-07-03 Lawrence Arkansas 5075 102 9
292375 2020-07-03 Lawrence Illinois 17101 7 0
292474 2020-07-03 Lawrence Indiana 18093 237 25
292779 2020-07-03 Lawrence Kentucky 21127 9 0
293166 2020-07-03 Lawrence Mississippi 28077 170 1
293265 2020-07-03 Lawrence Missouri 29109 41 1
293777 2020-07-03 Lawrence Ohio 39087 67 0
293968 2020-07-03 Lawrence Pennsylvania 42073 110 9
294087 2020-07-03 Lawrence South Dakota 46081 19 0
294161 2020-07-03 Lawrence Tennessee 47099 152 6
288698 2020-07-02 Lawrence Alabama 1079 103 0

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 1021.111ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette