ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Madera" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534628 | 534628 | 2020-09-15 | Madera | California | 6039 | 4230 | 58 |
531393 | 531393 | 2020-09-14 | Madera | California | 6039 | 4226 | 58 |
528156 | 528156 | 2020-09-13 | Madera | California | 6039 | 4150 | 58 |
524920 | 524920 | 2020-09-12 | Madera | California | 6039 | 4150 | 58 |
521684 | 521684 | 2020-09-11 | Madera | California | 6039 | 4150 | 58 |
518447 | 518447 | 2020-09-10 | Madera | California | 6039 | 4079 | 58 |
515212 | 515212 | 2020-09-09 | Madera | California | 6039 | 4064 | 58 |
511979 | 511979 | 2020-09-08 | Madera | California | 6039 | 4025 | 58 |
508746 | 508746 | 2020-09-07 | Madera | California | 6039 | 3953 | 58 |
505514 | 505514 | 2020-09-06 | Madera | California | 6039 | 3953 | 58 |
502280 | 502280 | 2020-09-05 | Madera | California | 6039 | 3953 | 58 |
499046 | 499046 | 2020-09-04 | Madera | California | 6039 | 3953 | 58 |
495813 | 495813 | 2020-09-03 | Madera | California | 6039 | 3889 | 57 |
492579 | 492579 | 2020-09-02 | Madera | California | 6039 | 3876 | 55 |
489346 | 489346 | 2020-09-01 | Madera | California | 6039 | 3836 | 55 |
486113 | 486113 | 2020-08-31 | Madera | California | 6039 | 3783 | 54 |
482878 | 482878 | 2020-08-30 | Madera | California | 6039 | 3674 | 54 |
479644 | 479644 | 2020-08-29 | Madera | California | 6039 | 3674 | 54 |
476411 | 476411 | 2020-08-28 | Madera | California | 6039 | 3674 | 54 |
473178 | 473178 | 2020-08-27 | Madera | California | 6039 | 3551 | 53 |
469946 | 469946 | 2020-08-26 | Madera | California | 6039 | 3551 | 53 |
466717 | 466717 | 2020-08-25 | Madera | California | 6039 | 3509 | 51 |
463488 | 463488 | 2020-08-24 | Madera | California | 6039 | 3484 | 50 |
460259 | 460259 | 2020-08-23 | Madera | California | 6039 | 3339 | 49 |
457032 | 457032 | 2020-08-22 | Madera | California | 6039 | 3339 | 49 |
453804 | 453804 | 2020-08-21 | Madera | California | 6039 | 3339 | 49 |
450576 | 450576 | 2020-08-20 | Madera | California | 6039 | 3278 | 49 |
447348 | 447348 | 2020-08-19 | Madera | California | 6039 | 3236 | 47 |
444121 | 444121 | 2020-08-18 | Madera | California | 6039 | 3196 | 47 |
440895 | 440895 | 2020-08-17 | Madera | California | 6039 | 3129 | 47 |
437669 | 437669 | 2020-08-16 | Madera | California | 6039 | 2950 | 47 |
434443 | 434443 | 2020-08-15 | Madera | California | 6039 | 2924 | 47 |
431218 | 431218 | 2020-08-14 | Madera | California | 6039 | 2924 | 47 |
427990 | 427990 | 2020-08-13 | Madera | California | 6039 | 2853 | 46 |
424766 | 424766 | 2020-08-12 | Madera | California | 6039 | 2759 | 44 |
421545 | 421545 | 2020-08-11 | Madera | California | 6039 | 2463 | 39 |
418324 | 418324 | 2020-08-10 | Madera | California | 6039 | 2463 | 39 |
415103 | 415103 | 2020-08-09 | Madera | California | 6039 | 2302 | 39 |
411883 | 411883 | 2020-08-08 | Madera | California | 6039 | 2302 | 39 |
408664 | 408664 | 2020-08-07 | Madera | California | 6039 | 2302 | 39 |
405444 | 405444 | 2020-08-06 | Madera | California | 6039 | 2267 | 36 |
402226 | 402226 | 2020-08-05 | Madera | California | 6039 | 2161 | 32 |
399010 | 399010 | 2020-08-04 | Madera | California | 6039 | 2143 | 32 |
395794 | 395794 | 2020-08-03 | Madera | California | 6039 | 2123 | 32 |
392578 | 392578 | 2020-08-02 | Madera | California | 6039 | 2103 | 30 |
389361 | 389361 | 2020-08-01 | Madera | California | 6039 | 2036 | 30 |
386144 | 386144 | 2020-07-31 | Madera | California | 6039 | 2007 | 30 |
382926 | 382926 | 2020-07-30 | Madera | California | 6039 | 1941 | 28 |
379709 | 379709 | 2020-07-29 | Madera | California | 6039 | 1889 | 28 |
376493 | 376493 | 2020-07-28 | Madera | California | 6039 | 1841 | 23 |
373279 | 373279 | 2020-07-27 | Madera | California | 6039 | 1744 | 21 |
370067 | 370067 | 2020-07-26 | Madera | California | 6039 | 1724 | 19 |
366857 | 366857 | 2020-07-25 | Madera | California | 6039 | 1679 | 19 |
363650 | 363650 | 2020-07-24 | Madera | California | 6039 | 1659 | 19 |
360443 | 360443 | 2020-07-23 | Madera | California | 6039 | 1599 | 18 |
357238 | 357238 | 2020-07-22 | Madera | California | 6039 | 1530 | 16 |
354035 | 354035 | 2020-07-21 | Madera | California | 6039 | 1439 | 13 |
350833 | 350833 | 2020-07-20 | Madera | California | 6039 | 1451 | 13 |
347632 | 347632 | 2020-07-19 | Madera | California | 6039 | 1260 | 11 |
344432 | 344432 | 2020-07-18 | Madera | California | 6039 | 1214 | 11 |
341233 | 341233 | 2020-07-17 | Madera | California | 6039 | 1192 | 11 |
338037 | 338037 | 2020-07-16 | Madera | California | 6039 | 1147 | 11 |
334842 | 334842 | 2020-07-15 | Madera | California | 6039 | 1118 | 10 |
331649 | 331649 | 2020-07-14 | Madera | California | 6039 | 1059 | 9 |
328463 | 328463 | 2020-07-13 | Madera | California | 6039 | 1025 | 8 |
325277 | 325277 | 2020-07-12 | Madera | California | 6039 | 988 | 8 |
322096 | 322096 | 2020-07-11 | Madera | California | 6039 | 914 | 8 |
318917 | 318917 | 2020-07-10 | Madera | California | 6039 | 893 | 8 |
315744 | 315744 | 2020-07-09 | Madera | California | 6039 | 857 | 8 |
312569 | 312569 | 2020-07-08 | Madera | California | 6039 | 857 | 8 |
309399 | 309399 | 2020-07-07 | Madera | California | 6039 | 784 | 7 |
306231 | 306231 | 2020-07-06 | Madera | California | 6039 | 713 | 7 |
303067 | 303067 | 2020-07-05 | Madera | California | 6039 | 578 | 5 |
299903 | 299903 | 2020-07-04 | Madera | California | 6039 | 578 | 5 |
296741 | 296741 | 2020-07-03 | Madera | California | 6039 | 578 | 5 |
293585 | 293585 | 2020-07-02 | Madera | California | 6039 | 566 | 5 |
290431 | 290431 | 2020-07-01 | Madera | California | 6039 | 541 | 5 |
287280 | 287280 | 2020-06-30 | Madera | California | 6039 | 519 | 5 |
284134 | 284134 | 2020-06-29 | Madera | California | 6039 | 488 | 5 |
280988 | 280988 | 2020-06-28 | Madera | California | 6039 | 427 | 5 |
277841 | 277841 | 2020-06-27 | Madera | California | 6039 | 415 | 5 |
274693 | 274693 | 2020-06-26 | Madera | California | 6039 | 415 | 5 |
271553 | 271553 | 2020-06-25 | Madera | California | 6039 | 383 | 5 |
268418 | 268418 | 2020-06-24 | Madera | California | 6039 | 370 | 5 |
265288 | 265288 | 2020-06-23 | Madera | California | 6039 | 359 | 5 |
262160 | 262160 | 2020-06-22 | Madera | California | 6039 | 334 | 5 |
259033 | 259033 | 2020-06-21 | Madera | California | 6039 | 321 | 4 |
255906 | 255906 | 2020-06-20 | Madera | California | 6039 | 314 | 4 |
252787 | 252787 | 2020-06-19 | Madera | California | 6039 | 314 | 4 |
249672 | 249672 | 2020-06-18 | Madera | California | 6039 | 295 | 4 |
246560 | 246560 | 2020-06-17 | Madera | California | 6039 | 275 | 4 |
243447 | 243447 | 2020-06-16 | Madera | California | 6039 | 250 | 4 |
240336 | 240336 | 2020-06-15 | Madera | California | 6039 | 226 | 3 |
237228 | 237228 | 2020-06-14 | Madera | California | 6039 | 203 | 3 |
234121 | 234121 | 2020-06-13 | Madera | California | 6039 | 198 | 3 |
231015 | 231015 | 2020-06-12 | Madera | California | 6039 | 198 | 3 |
227912 | 227912 | 2020-06-11 | Madera | California | 6039 | 188 | 3 |
224810 | 224810 | 2020-06-10 | Madera | California | 6039 | 178 | 3 |
221715 | 221715 | 2020-06-09 | Madera | California | 6039 | 174 | 3 |
218620 | 218620 | 2020-06-08 | Madera | California | 6039 | 172 | 3 |
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);