ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where county = "Madison", deaths = 4 and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
352328 | 352328 | 2020-07-20 | Madison | Nebraska | 31119 | 403 | 4 |
349127 | 349127 | 2020-07-19 | Madison | Nebraska | 31119 | 400 | 4 |
345926 | 345926 | 2020-07-18 | Madison | Nebraska | 31119 | 400 | 4 |
342726 | 342726 | 2020-07-17 | Madison | Nebraska | 31119 | 400 | 4 |
339529 | 339529 | 2020-07-16 | Madison | Nebraska | 31119 | 399 | 4 |
336332 | 336332 | 2020-07-15 | Madison | Nebraska | 31119 | 399 | 4 |
333138 | 333138 | 2020-07-14 | Madison | Nebraska | 31119 | 395 | 4 |
329948 | 329948 | 2020-07-13 | Madison | Nebraska | 31119 | 395 | 4 |
326761 | 326761 | 2020-07-12 | Madison | Nebraska | 31119 | 390 | 4 |
323577 | 323577 | 2020-07-11 | Madison | Nebraska | 31119 | 390 | 4 |
320398 | 320398 | 2020-07-10 | Madison | Nebraska | 31119 | 390 | 4 |
317223 | 317223 | 2020-07-09 | Madison | Nebraska | 31119 | 390 | 4 |
314049 | 314049 | 2020-07-08 | Madison | Nebraska | 31119 | 379 | 4 |
310878 | 310878 | 2020-07-07 | Madison | Nebraska | 31119 | 378 | 4 |
307710 | 307710 | 2020-07-06 | Madison | Nebraska | 31119 | 377 | 4 |
304543 | 304543 | 2020-07-05 | Madison | Nebraska | 31119 | 373 | 4 |
301379 | 301379 | 2020-07-04 | Madison | Nebraska | 31119 | 373 | 4 |
298216 | 298216 | 2020-07-03 | Madison | Nebraska | 31119 | 373 | 4 |
295057 | 295057 | 2020-07-02 | Madison | Nebraska | 31119 | 373 | 4 |
291902 | 291902 | 2020-07-01 | Madison | Nebraska | 31119 | 373 | 4 |
288750 | 288750 | 2020-06-30 | Madison | Nebraska | 31119 | 365 | 4 |
285600 | 285600 | 2020-06-29 | Madison | Nebraska | 31119 | 365 | 4 |
282455 | 282455 | 2020-06-28 | Madison | Nebraska | 31119 | 365 | 4 |
279307 | 279307 | 2020-06-27 | Madison | Nebraska | 31119 | 365 | 4 |
276159 | 276159 | 2020-06-26 | Madison | Nebraska | 31119 | 365 | 4 |
273016 | 273016 | 2020-06-25 | Madison | Nebraska | 31119 | 365 | 4 |
269877 | 269877 | 2020-06-24 | Madison | Nebraska | 31119 | 355 | 4 |
266743 | 266743 | 2020-06-23 | Madison | Nebraska | 31119 | 350 | 4 |
263616 | 263616 | 2020-06-22 | Madison | Nebraska | 31119 | 350 | 4 |
260487 | 260487 | 2020-06-21 | Madison | Nebraska | 31119 | 350 | 4 |
257361 | 257361 | 2020-06-20 | Madison | Nebraska | 31119 | 350 | 4 |
254238 | 254238 | 2020-06-19 | Madison | Nebraska | 31119 | 350 | 4 |
251123 | 251123 | 2020-06-18 | Madison | Nebraska | 31119 | 350 | 4 |
248008 | 248008 | 2020-06-17 | Madison | Nebraska | 31119 | 347 | 4 |
244895 | 244895 | 2020-06-16 | Madison | Nebraska | 31119 | 347 | 4 |
241784 | 241784 | 2020-06-15 | Madison | Nebraska | 31119 | 339 | 4 |
238674 | 238674 | 2020-06-14 | Madison | Nebraska | 31119 | 339 | 4 |
235567 | 235567 | 2020-06-13 | Madison | Nebraska | 31119 | 339 | 4 |
232461 | 232461 | 2020-06-12 | Madison | Nebraska | 31119 | 339 | 4 |
229356 | 229356 | 2020-06-11 | Madison | Nebraska | 31119 | 339 | 4 |
226253 | 226253 | 2020-06-10 | Madison | Nebraska | 31119 | 334 | 4 |
223154 | 223154 | 2020-06-09 | Madison | Nebraska | 31119 | 334 | 4 |
220058 | 220058 | 2020-06-08 | Madison | Nebraska | 31119 | 334 | 4 |
216966 | 216966 | 2020-06-07 | Madison | Nebraska | 31119 | 332 | 4 |
213877 | 213877 | 2020-06-06 | Madison | Nebraska | 31119 | 332 | 4 |
210793 | 210793 | 2020-06-05 | Madison | Nebraska | 31119 | 332 | 4 |
207711 | 207711 | 2020-06-04 | Madison | Nebraska | 31119 | 329 | 4 |
204630 | 204630 | 2020-06-03 | Madison | Nebraska | 31119 | 329 | 4 |
201553 | 201553 | 2020-06-02 | Madison | Nebraska | 31119 | 326 | 4 |
198479 | 198479 | 2020-06-01 | Madison | Nebraska | 31119 | 326 | 4 |
195406 | 195406 | 2020-05-31 | Madison | Nebraska | 31119 | 316 | 4 |
192336 | 192336 | 2020-05-30 | Madison | Nebraska | 31119 | 316 | 4 |
189272 | 189272 | 2020-05-29 | Madison | Nebraska | 31119 | 316 | 4 |
186213 | 186213 | 2020-05-28 | Madison | Nebraska | 31119 | 316 | 4 |
183157 | 183157 | 2020-05-27 | Madison | Nebraska | 31119 | 316 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
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);