ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "St. Mary's" and state = "Maryland" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535641 | 535641 | 2020-09-15 | St. Mary's | Maryland | 24037 | 1202 | 57 |
532406 | 532406 | 2020-09-14 | St. Mary's | Maryland | 24037 | 1197 | 57 |
529170 | 529170 | 2020-09-13 | St. Mary's | Maryland | 24037 | 1193 | 57 |
525934 | 525934 | 2020-09-12 | St. Mary's | Maryland | 24037 | 1186 | 57 |
522698 | 522698 | 2020-09-11 | St. Mary's | Maryland | 24037 | 1170 | 57 |
519461 | 519461 | 2020-09-10 | St. Mary's | Maryland | 24037 | 1165 | 57 |
516226 | 516226 | 2020-09-09 | St. Mary's | Maryland | 24037 | 1164 | 56 |
512992 | 512992 | 2020-09-08 | St. Mary's | Maryland | 24037 | 1164 | 56 |
509760 | 509760 | 2020-09-07 | St. Mary's | Maryland | 24037 | 1162 | 56 |
506527 | 506527 | 2020-09-06 | St. Mary's | Maryland | 24037 | 1150 | 56 |
503294 | 503294 | 2020-09-05 | St. Mary's | Maryland | 24037 | 1144 | 56 |
500060 | 500060 | 2020-09-04 | St. Mary's | Maryland | 24037 | 1139 | 56 |
496826 | 496826 | 2020-09-03 | St. Mary's | Maryland | 24037 | 1130 | 56 |
493593 | 493593 | 2020-09-02 | St. Mary's | Maryland | 24037 | 1122 | 55 |
490359 | 490359 | 2020-09-01 | St. Mary's | Maryland | 24037 | 1121 | 55 |
487126 | 487126 | 2020-08-31 | St. Mary's | Maryland | 24037 | 1112 | 55 |
483892 | 483892 | 2020-08-30 | St. Mary's | Maryland | 24037 | 1108 | 55 |
480657 | 480657 | 2020-08-29 | St. Mary's | Maryland | 24037 | 1103 | 55 |
477425 | 477425 | 2020-08-28 | St. Mary's | Maryland | 24037 | 1096 | 55 |
474192 | 474192 | 2020-08-27 | St. Mary's | Maryland | 24037 | 1091 | 55 |
470960 | 470960 | 2020-08-26 | St. Mary's | Maryland | 24037 | 1089 | 54 |
467730 | 467730 | 2020-08-25 | St. Mary's | Maryland | 24037 | 1086 | 54 |
464501 | 464501 | 2020-08-24 | St. Mary's | Maryland | 24037 | 1084 | 53 |
461270 | 461270 | 2020-08-23 | St. Mary's | Maryland | 24037 | 1080 | 53 |
458043 | 458043 | 2020-08-22 | St. Mary's | Maryland | 24037 | 1077 | 52 |
454815 | 454815 | 2020-08-21 | St. Mary's | Maryland | 24037 | 1075 | 52 |
451587 | 451587 | 2020-08-20 | St. Mary's | Maryland | 24037 | 1069 | 52 |
448359 | 448359 | 2020-08-19 | St. Mary's | Maryland | 24037 | 1064 | 52 |
445133 | 445133 | 2020-08-18 | St. Mary's | Maryland | 24037 | 1064 | 52 |
441907 | 441907 | 2020-08-17 | St. Mary's | Maryland | 24037 | 1061 | 52 |
438680 | 438680 | 2020-08-16 | St. Mary's | Maryland | 24037 | 1048 | 52 |
435455 | 435455 | 2020-08-15 | St. Mary's | Maryland | 24037 | 1040 | 52 |
432229 | 432229 | 2020-08-14 | St. Mary's | Maryland | 24037 | 1039 | 52 |
429002 | 429002 | 2020-08-13 | St. Mary's | Maryland | 24037 | 1022 | 52 |
425778 | 425778 | 2020-08-12 | St. Mary's | Maryland | 24037 | 1012 | 52 |
422556 | 422556 | 2020-08-11 | St. Mary's | Maryland | 24037 | 1003 | 52 |
419334 | 419334 | 2020-08-10 | St. Mary's | Maryland | 24037 | 999 | 52 |
416113 | 416113 | 2020-08-09 | St. Mary's | Maryland | 24037 | 983 | 52 |
412893 | 412893 | 2020-08-08 | St. Mary's | Maryland | 24037 | 965 | 52 |
409673 | 409673 | 2020-08-07 | St. Mary's | Maryland | 24037 | 962 | 52 |
406453 | 406453 | 2020-08-06 | St. Mary's | Maryland | 24037 | 951 | 52 |
403235 | 403235 | 2020-08-05 | St. Mary's | Maryland | 24037 | 945 | 52 |
400018 | 400018 | 2020-08-04 | St. Mary's | Maryland | 24037 | 931 | 52 |
396804 | 396804 | 2020-08-03 | St. Mary's | Maryland | 24037 | 931 | 52 |
393588 | 393588 | 2020-08-02 | St. Mary's | Maryland | 24037 | 922 | 52 |
390371 | 390371 | 2020-08-01 | St. Mary's | Maryland | 24037 | 904 | 52 |
387154 | 387154 | 2020-07-31 | St. Mary's | Maryland | 24037 | 896 | 52 |
383936 | 383936 | 2020-07-30 | St. Mary's | Maryland | 24037 | 874 | 53 |
380719 | 380719 | 2020-07-29 | St. Mary's | Maryland | 24037 | 863 | 53 |
377502 | 377502 | 2020-07-28 | St. Mary's | Maryland | 24037 | 855 | 53 |
374287 | 374287 | 2020-07-27 | St. Mary's | Maryland | 24037 | 849 | 52 |
371075 | 371075 | 2020-07-26 | St. Mary's | Maryland | 24037 | 834 | 52 |
367865 | 367865 | 2020-07-25 | St. Mary's | Maryland | 24037 | 822 | 52 |
364658 | 364658 | 2020-07-24 | St. Mary's | Maryland | 24037 | 805 | 52 |
361451 | 361451 | 2020-07-23 | St. Mary's | Maryland | 24037 | 790 | 52 |
358246 | 358246 | 2020-07-22 | St. Mary's | Maryland | 24037 | 789 | 53 |
355043 | 355043 | 2020-07-21 | St. Mary's | Maryland | 24037 | 785 | 52 |
351841 | 351841 | 2020-07-20 | St. Mary's | Maryland | 24037 | 779 | 52 |
348641 | 348641 | 2020-07-19 | St. Mary's | Maryland | 24037 | 773 | 51 |
345440 | 345440 | 2020-07-18 | St. Mary's | Maryland | 24037 | 764 | 51 |
342240 | 342240 | 2020-07-17 | St. Mary's | Maryland | 24037 | 753 | 51 |
339044 | 339044 | 2020-07-16 | St. Mary's | Maryland | 24037 | 739 | 51 |
335848 | 335848 | 2020-07-15 | St. Mary's | Maryland | 24037 | 730 | 51 |
332655 | 332655 | 2020-07-14 | St. Mary's | Maryland | 24037 | 721 | 51 |
329468 | 329468 | 2020-07-13 | St. Mary's | Maryland | 24037 | 708 | 51 |
326282 | 326282 | 2020-07-12 | St. Mary's | Maryland | 24037 | 700 | 51 |
323099 | 323099 | 2020-07-11 | St. Mary's | Maryland | 24037 | 689 | 51 |
319920 | 319920 | 2020-07-10 | St. Mary's | Maryland | 24037 | 679 | 51 |
316745 | 316745 | 2020-07-09 | St. Mary's | Maryland | 24037 | 673 | 51 |
313571 | 313571 | 2020-07-08 | St. Mary's | Maryland | 24037 | 666 | 51 |
310401 | 310401 | 2020-07-07 | St. Mary's | Maryland | 24037 | 662 | 51 |
307233 | 307233 | 2020-07-06 | St. Mary's | Maryland | 24037 | 659 | 51 |
304066 | 304066 | 2020-07-05 | St. Mary's | Maryland | 24037 | 654 | 51 |
300902 | 300902 | 2020-07-04 | St. Mary's | Maryland | 24037 | 652 | 51 |
297740 | 297740 | 2020-07-03 | St. Mary's | Maryland | 24037 | 651 | 51 |
294582 | 294582 | 2020-07-02 | St. Mary's | Maryland | 24037 | 646 | 51 |
291428 | 291428 | 2020-07-01 | St. Mary's | Maryland | 24037 | 639 | 51 |
288277 | 288277 | 2020-06-30 | St. Mary's | Maryland | 24037 | 637 | 51 |
285127 | 285127 | 2020-06-29 | St. Mary's | Maryland | 24037 | 633 | 51 |
281982 | 281982 | 2020-06-28 | St. Mary's | Maryland | 24037 | 620 | 51 |
278834 | 278834 | 2020-06-27 | St. Mary's | Maryland | 24037 | 619 | 51 |
275686 | 275686 | 2020-06-26 | St. Mary's | Maryland | 24037 | 611 | 50 |
272543 | 272543 | 2020-06-25 | St. Mary's | Maryland | 24037 | 610 | 48 |
269406 | 269406 | 2020-06-24 | St. Mary's | Maryland | 24037 | 606 | 48 |
266273 | 266273 | 2020-06-23 | St. Mary's | Maryland | 24037 | 605 | 48 |
263147 | 263147 | 2020-06-22 | St. Mary's | Maryland | 24037 | 599 | 46 |
260018 | 260018 | 2020-06-21 | St. Mary's | Maryland | 24037 | 602 | 45 |
256892 | 256892 | 2020-06-20 | St. Mary's | Maryland | 24037 | 597 | 44 |
253772 | 253772 | 2020-06-19 | St. Mary's | Maryland | 24037 | 599 | 44 |
250657 | 250657 | 2020-06-18 | St. Mary's | Maryland | 24037 | 595 | 44 |
247545 | 247545 | 2020-06-17 | St. Mary's | Maryland | 24037 | 587 | 41 |
244432 | 244432 | 2020-06-16 | St. Mary's | Maryland | 24037 | 585 | 40 |
241321 | 241321 | 2020-06-15 | St. Mary's | Maryland | 24037 | 582 | 40 |
238212 | 238212 | 2020-06-14 | St. Mary's | Maryland | 24037 | 580 | 39 |
235105 | 235105 | 2020-06-13 | St. Mary's | Maryland | 24037 | 578 | 40 |
232000 | 232000 | 2020-06-12 | St. Mary's | Maryland | 24037 | 575 | 40 |
228896 | 228896 | 2020-06-11 | St. Mary's | Maryland | 24037 | 573 | 36 |
225794 | 225794 | 2020-06-10 | St. Mary's | Maryland | 24037 | 565 | 35 |
222698 | 222698 | 2020-06-09 | St. Mary's | Maryland | 24037 | 561 | 34 |
219603 | 219603 | 2020-06-08 | St. Mary's | Maryland | 24037 | 553 | 34 |
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);