ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 24043 and state = "Maryland" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535644 | 535644 | 2020-09-15 | Washington | Maryland | 24043 | 1525 | 35 |
532409 | 532409 | 2020-09-14 | Washington | Maryland | 24043 | 1506 | 35 |
529173 | 529173 | 2020-09-13 | Washington | Maryland | 24043 | 1493 | 35 |
525937 | 525937 | 2020-09-12 | Washington | Maryland | 24043 | 1474 | 35 |
522701 | 522701 | 2020-09-11 | Washington | Maryland | 24043 | 1453 | 35 |
519464 | 519464 | 2020-09-10 | Washington | Maryland | 24043 | 1440 | 35 |
516229 | 516229 | 2020-09-09 | Washington | Maryland | 24043 | 1416 | 35 |
512995 | 512995 | 2020-09-08 | Washington | Maryland | 24043 | 1411 | 35 |
509763 | 509763 | 2020-09-07 | Washington | Maryland | 24043 | 1392 | 35 |
506530 | 506530 | 2020-09-06 | Washington | Maryland | 24043 | 1386 | 35 |
503297 | 503297 | 2020-09-05 | Washington | Maryland | 24043 | 1378 | 35 |
500063 | 500063 | 2020-09-04 | Washington | Maryland | 24043 | 1369 | 34 |
496829 | 496829 | 2020-09-03 | Washington | Maryland | 24043 | 1349 | 34 |
493596 | 493596 | 2020-09-02 | Washington | Maryland | 24043 | 1337 | 33 |
490362 | 490362 | 2020-09-01 | Washington | Maryland | 24043 | 1321 | 33 |
487129 | 487129 | 2020-08-31 | Washington | Maryland | 24043 | 1312 | 33 |
483895 | 483895 | 2020-08-30 | Washington | Maryland | 24043 | 1308 | 33 |
480660 | 480660 | 2020-08-29 | Washington | Maryland | 24043 | 1288 | 32 |
477428 | 477428 | 2020-08-28 | Washington | Maryland | 24043 | 1273 | 32 |
474195 | 474195 | 2020-08-27 | Washington | Maryland | 24043 | 1267 | 32 |
470963 | 470963 | 2020-08-26 | Washington | Maryland | 24043 | 1258 | 32 |
467733 | 467733 | 2020-08-25 | Washington | Maryland | 24043 | 1241 | 32 |
464504 | 464504 | 2020-08-24 | Washington | Maryland | 24043 | 1237 | 32 |
461273 | 461273 | 2020-08-23 | Washington | Maryland | 24043 | 1234 | 32 |
458046 | 458046 | 2020-08-22 | Washington | Maryland | 24043 | 1207 | 32 |
454818 | 454818 | 2020-08-21 | Washington | Maryland | 24043 | 1192 | 32 |
451590 | 451590 | 2020-08-20 | Washington | Maryland | 24043 | 1170 | 31 |
448362 | 448362 | 2020-08-19 | Washington | Maryland | 24043 | 1160 | 31 |
445136 | 445136 | 2020-08-18 | Washington | Maryland | 24043 | 1148 | 31 |
441910 | 441910 | 2020-08-17 | Washington | Maryland | 24043 | 1138 | 31 |
438683 | 438683 | 2020-08-16 | Washington | Maryland | 24043 | 1125 | 31 |
435458 | 435458 | 2020-08-15 | Washington | Maryland | 24043 | 1117 | 31 |
432232 | 432232 | 2020-08-14 | Washington | Maryland | 24043 | 1090 | 31 |
429005 | 429005 | 2020-08-13 | Washington | Maryland | 24043 | 1066 | 31 |
425781 | 425781 | 2020-08-12 | Washington | Maryland | 24043 | 1041 | 31 |
422559 | 422559 | 2020-08-11 | Washington | Maryland | 24043 | 1029 | 31 |
419337 | 419337 | 2020-08-10 | Washington | Maryland | 24043 | 1018 | 31 |
416116 | 416116 | 2020-08-09 | Washington | Maryland | 24043 | 1012 | 31 |
412896 | 412896 | 2020-08-08 | Washington | Maryland | 24043 | 1007 | 31 |
409676 | 409676 | 2020-08-07 | Washington | Maryland | 24043 | 1003 | 31 |
406456 | 406456 | 2020-08-06 | Washington | Maryland | 24043 | 996 | 31 |
403238 | 403238 | 2020-08-05 | Washington | Maryland | 24043 | 989 | 31 |
400021 | 400021 | 2020-08-04 | Washington | Maryland | 24043 | 986 | 30 |
396807 | 396807 | 2020-08-03 | Washington | Maryland | 24043 | 982 | 30 |
393591 | 393591 | 2020-08-02 | Washington | Maryland | 24043 | 978 | 30 |
390374 | 390374 | 2020-08-01 | Washington | Maryland | 24043 | 967 | 30 |
387157 | 387157 | 2020-07-31 | Washington | Maryland | 24043 | 952 | 30 |
383939 | 383939 | 2020-07-30 | Washington | Maryland | 24043 | 936 | 30 |
380722 | 380722 | 2020-07-29 | Washington | Maryland | 24043 | 931 | 30 |
377505 | 377505 | 2020-07-28 | Washington | Maryland | 24043 | 914 | 30 |
374290 | 374290 | 2020-07-27 | Washington | Maryland | 24043 | 897 | 30 |
371078 | 371078 | 2020-07-26 | Washington | Maryland | 24043 | 871 | 30 |
367868 | 367868 | 2020-07-25 | Washington | Maryland | 24043 | 864 | 30 |
364661 | 364661 | 2020-07-24 | Washington | Maryland | 24043 | 833 | 29 |
361454 | 361454 | 2020-07-23 | Washington | Maryland | 24043 | 826 | 29 |
358249 | 358249 | 2020-07-22 | Washington | Maryland | 24043 | 818 | 29 |
355046 | 355046 | 2020-07-21 | Washington | Maryland | 24043 | 816 | 29 |
351844 | 351844 | 2020-07-20 | Washington | Maryland | 24043 | 796 | 29 |
348644 | 348644 | 2020-07-19 | Washington | Maryland | 24043 | 784 | 29 |
345443 | 345443 | 2020-07-18 | Washington | Maryland | 24043 | 773 | 29 |
342243 | 342243 | 2020-07-17 | Washington | Maryland | 24043 | 751 | 29 |
339047 | 339047 | 2020-07-16 | Washington | Maryland | 24043 | 743 | 29 |
335851 | 335851 | 2020-07-15 | Washington | Maryland | 24043 | 739 | 29 |
332658 | 332658 | 2020-07-14 | Washington | Maryland | 24043 | 737 | 29 |
329471 | 329471 | 2020-07-13 | Washington | Maryland | 24043 | 728 | 29 |
326285 | 326285 | 2020-07-12 | Washington | Maryland | 24043 | 727 | 29 |
323102 | 323102 | 2020-07-11 | Washington | Maryland | 24043 | 720 | 29 |
319923 | 319923 | 2020-07-10 | Washington | Maryland | 24043 | 710 | 29 |
316748 | 316748 | 2020-07-09 | Washington | Maryland | 24043 | 702 | 29 |
313574 | 313574 | 2020-07-08 | Washington | Maryland | 24043 | 694 | 29 |
310404 | 310404 | 2020-07-07 | Washington | Maryland | 24043 | 691 | 29 |
307236 | 307236 | 2020-07-06 | Washington | Maryland | 24043 | 696 | 29 |
304069 | 304069 | 2020-07-05 | Washington | Maryland | 24043 | 696 | 29 |
300905 | 300905 | 2020-07-04 | Washington | Maryland | 24043 | 695 | 29 |
297743 | 297743 | 2020-07-03 | Washington | Maryland | 24043 | 691 | 28 |
294585 | 294585 | 2020-07-02 | Washington | Maryland | 24043 | 687 | 28 |
291431 | 291431 | 2020-07-01 | Washington | Maryland | 24043 | 697 | 28 |
288280 | 288280 | 2020-06-30 | Washington | Maryland | 24043 | 698 | 27 |
285130 | 285130 | 2020-06-29 | Washington | Maryland | 24043 | 695 | 26 |
281985 | 281985 | 2020-06-28 | Washington | Maryland | 24043 | 694 | 26 |
278837 | 278837 | 2020-06-27 | Washington | Maryland | 24043 | 684 | 26 |
275689 | 275689 | 2020-06-26 | Washington | Maryland | 24043 | 663 | 26 |
272546 | 272546 | 2020-06-25 | Washington | Maryland | 24043 | 653 | 26 |
269409 | 269409 | 2020-06-24 | Washington | Maryland | 24043 | 634 | 26 |
266276 | 266276 | 2020-06-23 | Washington | Maryland | 24043 | 616 | 25 |
263150 | 263150 | 2020-06-22 | Washington | Maryland | 24043 | 611 | 25 |
260021 | 260021 | 2020-06-21 | Washington | Maryland | 24043 | 603 | 25 |
256895 | 256895 | 2020-06-20 | Washington | Maryland | 24043 | 602 | 25 |
253775 | 253775 | 2020-06-19 | Washington | Maryland | 24043 | 601 | 25 |
250660 | 250660 | 2020-06-18 | Washington | Maryland | 24043 | 595 | 24 |
247548 | 247548 | 2020-06-17 | Washington | Maryland | 24043 | 593 | 22 |
244435 | 244435 | 2020-06-16 | Washington | Maryland | 24043 | 579 | 22 |
241324 | 241324 | 2020-06-15 | Washington | Maryland | 24043 | 579 | 22 |
238215 | 238215 | 2020-06-14 | Washington | Maryland | 24043 | 571 | 22 |
235108 | 235108 | 2020-06-13 | Washington | Maryland | 24043 | 570 | 22 |
232003 | 232003 | 2020-06-12 | Washington | Maryland | 24043 | 568 | 21 |
228899 | 228899 | 2020-06-11 | Washington | Maryland | 24043 | 560 | 20 |
225797 | 225797 | 2020-06-10 | Washington | Maryland | 24043 | 551 | 17 |
222701 | 222701 | 2020-06-09 | Washington | Maryland | 24043 | 545 | 17 |
219606 | 219606 | 2020-06-08 | Washington | Maryland | 24043 | 551 | 16 |
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);