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

This data as json, CSV (advanced)

Suggested facets: deaths, date (date)

fips

county

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