ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Miami-Dade" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
252941 | 252941 | 2020-06-19 | Miami-Dade | Florida | 12086 | 24375 | 864 |
256060 | 256060 | 2020-06-20 | Miami-Dade | Florida | 12086 | 25079 | 874 |
259187 | 259187 | 2020-06-21 | Miami-Dade | Florida | 12086 | 25789 | 884 |
262314 | 262314 | 2020-06-22 | Miami-Dade | Florida | 12086 | 26238 | 884 |
265442 | 265442 | 2020-06-23 | Miami-Dade | Florida | 12086 | 26821 | 902 |
268572 | 268572 | 2020-06-24 | Miami-Dade | Florida | 12086 | 27778 | 926 |
271708 | 271708 | 2020-06-25 | Miami-Dade | Florida | 12086 | 28663 | 935 |
274848 | 274848 | 2020-06-26 | Miami-Dade | Florida | 12086 | 30195 | 946 |
277996 | 277996 | 2020-06-27 | Miami-Dade | Florida | 12086 | 31561 | 947 |
281143 | 281143 | 2020-06-28 | Miami-Dade | Florida | 12086 | 33713 | 953 |
284289 | 284289 | 2020-06-29 | Miami-Dade | Florida | 12086 | 35221 | 975 |
287435 | 287435 | 2020-06-30 | Miami-Dade | Florida | 12086 | 36819 | 991 |
290586 | 290586 | 2020-07-01 | Miami-Dade | Florida | 12086 | 37960 | 1000 |
293740 | 293740 | 2020-07-02 | Miami-Dade | Florida | 12086 | 40264 | 1018 |
296896 | 296896 | 2020-07-03 | Miami-Dade | Florida | 12086 | 42310 | 1034 |
300058 | 300058 | 2020-07-04 | Miami-Dade | Florida | 12086 | 44728 | 1038 |
303222 | 303222 | 2020-07-05 | Miami-Dade | Florida | 12086 | 47010 | 1043 |
306386 | 306386 | 2020-07-06 | Miami-Dade | Florida | 12086 | 48991 | 1051 |
309554 | 309554 | 2020-07-07 | Miami-Dade | Florida | 12086 | 51057 | 1057 |
312724 | 312724 | 2020-07-08 | Miami-Dade | Florida | 12086 | 53973 | 1068 |
315899 | 315899 | 2020-07-09 | Miami-Dade | Florida | 12086 | 55960 | 1092 |
319072 | 319072 | 2020-07-10 | Miami-Dade | Florida | 12086 | 58340 | 1118 |
322251 | 322251 | 2020-07-11 | Miami-Dade | Florida | 12086 | 60867 | 1132 |
325432 | 325432 | 2020-07-12 | Miami-Dade | Florida | 12086 | 64443 | 1139 |
328618 | 328618 | 2020-07-13 | Miami-Dade | Florida | 12086 | 67712 | 1143 |
331805 | 331805 | 2020-07-14 | Miami-Dade | Florida | 12086 | 69802 | 1175 |
334998 | 334998 | 2020-07-15 | Miami-Dade | Florida | 12086 | 72316 | 1202 |
338193 | 338193 | 2020-07-16 | Miami-Dade | Florida | 12086 | 75424 | 1246 |
341390 | 341390 | 2020-07-17 | Miami-Dade | Florida | 12086 | 77866 | 1270 |
344589 | 344589 | 2020-07-18 | Miami-Dade | Florida | 12086 | 81025 | 1274 |
347789 | 347789 | 2020-07-19 | Miami-Dade | Florida | 12086 | 84237 | 1302 |
350990 | 350990 | 2020-07-20 | Miami-Dade | Florida | 12086 | 87034 | 1309 |
354192 | 354192 | 2020-07-21 | Miami-Dade | Florida | 12086 | 89556 | 1325 |
357395 | 357395 | 2020-07-22 | Miami-Dade | Florida | 12086 | 92344 | 1342 |
360600 | 360600 | 2020-07-23 | Miami-Dade | Florida | 12086 | 95067 | 1354 |
363807 | 363807 | 2020-07-24 | Miami-Dade | Florida | 12086 | 98429 | 1370 |
367014 | 367014 | 2020-07-25 | Miami-Dade | Florida | 12086 | 101853 | 1379 |
370224 | 370224 | 2020-07-26 | Miami-Dade | Florida | 12086 | 104754 | 1388 |
373436 | 373436 | 2020-07-27 | Miami-Dade | Florida | 12086 | 107314 | 1404 |
376650 | 376650 | 2020-07-28 | Miami-Dade | Florida | 12086 | 110351 | 1425 |
379867 | 379867 | 2020-07-29 | Miami-Dade | Florida | 12086 | 113142 | 1455 |
383084 | 383084 | 2020-07-30 | Miami-Dade | Florida | 12086 | 115915 | 1515 |
386302 | 386302 | 2020-07-31 | Miami-Dade | Florida | 12086 | 118461 | 1611 |
389519 | 389519 | 2020-08-01 | Miami-Dade | Florida | 12086 | 121206 | 1647 |
392736 | 392736 | 2020-08-02 | Miami-Dade | Florida | 12086 | 122689 | 1669 |
395952 | 395952 | 2020-08-03 | Miami-Dade | Florida | 12086 | 123643 | 1694 |
399168 | 399168 | 2020-08-04 | Miami-Dade | Florida | 12086 | 124758 | 1724 |
402384 | 402384 | 2020-08-05 | Miami-Dade | Florida | 12086 | 125948 | 1775 |
405602 | 405602 | 2020-08-06 | Miami-Dade | Florida | 12086 | 127676 | 1784 |
408822 | 408822 | 2020-08-07 | Miami-Dade | Florida | 12086 | 129408 | 1809 |
412041 | 412041 | 2020-08-08 | Miami-Dade | Florida | 12086 | 131216 | 1838 |
415261 | 415261 | 2020-08-09 | Miami-Dade | Florida | 12086 | 132460 | 1865 |
418482 | 418482 | 2020-08-10 | Miami-Dade | Florida | 12086 | 133622 | 1874 |
421703 | 421703 | 2020-08-11 | Miami-Dade | Florida | 12086 | 135129 | 1909 |
424924 | 424924 | 2020-08-12 | Miami-Dade | Florida | 12086 | 139270 | 1939 |
428148 | 428148 | 2020-08-13 | Miami-Dade | Florida | 12086 | 140983 | 1954 |
431376 | 431376 | 2020-08-14 | Miami-Dade | Florida | 12086 | 142661 | 1999 |
434601 | 434601 | 2020-08-15 | Miami-Dade | Florida | 12086 | 144406 | 2047 |
437827 | 437827 | 2020-08-16 | Miami-Dade | Florida | 12086 | 145306 | 2057 |
441053 | 441053 | 2020-08-17 | Miami-Dade | Florida | 12086 | 146025 | 2081 |
444279 | 444279 | 2020-08-18 | Miami-Dade | Florida | 12086 | 146989 | 2126 |
447506 | 447506 | 2020-08-19 | Miami-Dade | Florida | 12086 | 148092 | 2166 |
450734 | 450734 | 2020-08-20 | Miami-Dade | Florida | 12086 | 149161 | 2185 |
453962 | 453962 | 2020-08-21 | Miami-Dade | Florida | 12086 | 150304 | 2219 |
457190 | 457190 | 2020-08-22 | Miami-Dade | Florida | 12086 | 151213 | 2238 |
460417 | 460417 | 2020-08-23 | Miami-Dade | Florida | 12086 | 151985 | 2243 |
463646 | 463646 | 2020-08-24 | Miami-Dade | Florida | 12086 | 152611 | 2253 |
466875 | 466875 | 2020-08-25 | Miami-Dade | Florida | 12086 | 153384 | 2277 |
470104 | 470104 | 2020-08-26 | Miami-Dade | Florida | 12086 | 154134 | 2317 |
473336 | 473336 | 2020-08-27 | Miami-Dade | Florida | 12086 | 154756 | 2346 |
476569 | 476569 | 2020-08-28 | Miami-Dade | Florida | 12086 | 155417 | 2372 |
479802 | 479802 | 2020-08-29 | Miami-Dade | Florida | 12086 | 156037 | 2399 |
483036 | 483036 | 2020-08-30 | Miami-Dade | Florida | 12086 | 156558 | 2403 |
486271 | 486271 | 2020-08-31 | Miami-Dade | Florida | 12086 | 156909 | 2437 |
489504 | 489504 | 2020-09-01 | Miami-Dade | Florida | 12086 | 159058 | 2537 |
492737 | 492737 | 2020-09-02 | Miami-Dade | Florida | 12086 | 159399 | 2554 |
495971 | 495971 | 2020-09-03 | Miami-Dade | Florida | 12086 | 159977 | 2600 |
499204 | 499204 | 2020-09-04 | Miami-Dade | Florida | 12086 | 160468 | 2632 |
502438 | 502438 | 2020-09-05 | Miami-Dade | Florida | 12086 | 161017 | 2650 |
505672 | 505672 | 2020-09-06 | Miami-Dade | Florida | 12086 | 161362 | 2655 |
508904 | 508904 | 2020-09-07 | Miami-Dade | Florida | 12086 | 161636 | 2658 |
512137 | 512137 | 2020-09-08 | Miami-Dade | Florida | 12086 | 162025 | 2666 |
515370 | 515370 | 2020-09-09 | Miami-Dade | Florida | 12086 | 162432 | 2740 |
518605 | 518605 | 2020-09-10 | Miami-Dade | Florida | 12086 | 162893 | 2789 |
521842 | 521842 | 2020-09-11 | Miami-Dade | Florida | 12086 | 163374 | 2836 |
525078 | 525078 | 2020-09-12 | Miami-Dade | Florida | 12086 | 163789 | 2882 |
528314 | 528314 | 2020-09-13 | Miami-Dade | Florida | 12086 | 164085 | 2880 |
531551 | 531551 | 2020-09-14 | Miami-Dade | Florida | 12086 | 164298 | 2894 |
534786 | 534786 | 2020-09-15 | Miami-Dade | Florida | 12086 | 164687 | 2923 |
538022 | 538022 | 2020-09-16 | Miami-Dade | Florida | 12086 | 165146 | 2955 |
541259 | 541259 | 2020-09-17 | Miami-Dade | Florida | 12086 | 165594 | 2977 |
544495 | 544495 | 2020-09-18 | Miami-Dade | Florida | 12086 | 165979 | 3027 |
547733 | 547733 | 2020-09-19 | Miami-Dade | Florida | 12086 | 166515 | 3055 |
550972 | 550972 | 2020-09-20 | Miami-Dade | Florida | 12086 | 166880 | 3055 |
554211 | 554211 | 2020-09-21 | Miami-Dade | Florida | 12086 | 167152 | 3055 |
557448 | 557448 | 2020-09-22 | Miami-Dade | Florida | 12086 | 167514 | 3085 |
560684 | 560684 | 2020-09-23 | Miami-Dade | Florida | 12086 | 167879 | 3127 |
563924 | 563924 | 2020-09-24 | Miami-Dade | Florida | 12086 | 168271 | 3163 |
567164 | 567164 | 2020-09-25 | Miami-Dade | Florida | 12086 | 168774 | 3202 |
570406 | 570406 | 2020-09-26 | Miami-Dade | Florida | 12086 | 169143 | 3231 |
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);