ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
242 rows where deaths = 3 and state = "Maryland" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 20
county 20
- Caroline 87
- Somerset 85
- Washington 12
- Dorchester 9
- Worcester 8
- Allegany 5
- Howard 5
- Cecil 4
- Queen Anne's 4
- Wicomico 4
- Garrett 3
- St. Mary's 3
- Talbot 3
- Calvert 2
- Kent 2
- Prince George's 2
- Baltimore 1
- Charles 1
- Frederick 1
- Harford 1
state 1
- Maryland · 242 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
756138 | 756138 | 2020-11-22 | Garrett | Maryland | 24023 | 496 | 3 |
752892 | 752892 | 2020-11-21 | Garrett | Maryland | 24023 | 470 | 3 |
749646 | 749646 | 2020-11-20 | Garrett | Maryland | 24023 | 447 | 3 |
542100 | 542100 | 2020-09-17 | Caroline | Maryland | 24011 | 620 | 3 |
538864 | 538864 | 2020-09-16 | Caroline | Maryland | 24011 | 620 | 3 |
535627 | 535627 | 2020-09-15 | Caroline | Maryland | 24011 | 612 | 3 |
532392 | 532392 | 2020-09-14 | Caroline | Maryland | 24011 | 609 | 3 |
529156 | 529156 | 2020-09-13 | Caroline | Maryland | 24011 | 609 | 3 |
525920 | 525920 | 2020-09-12 | Caroline | Maryland | 24011 | 606 | 3 |
522684 | 522684 | 2020-09-11 | Caroline | Maryland | 24011 | 584 | 3 |
519447 | 519447 | 2020-09-10 | Caroline | Maryland | 24011 | 582 | 3 |
516212 | 516212 | 2020-09-09 | Caroline | Maryland | 24011 | 572 | 3 |
512978 | 512978 | 2020-09-08 | Caroline | Maryland | 24011 | 572 | 3 |
509746 | 509746 | 2020-09-07 | Caroline | Maryland | 24011 | 570 | 3 |
506513 | 506513 | 2020-09-06 | Caroline | Maryland | 24011 | 565 | 3 |
503280 | 503280 | 2020-09-05 | Caroline | Maryland | 24011 | 563 | 3 |
500046 | 500046 | 2020-09-04 | Caroline | Maryland | 24011 | 535 | 3 |
496812 | 496812 | 2020-09-03 | Caroline | Maryland | 24011 | 522 | 3 |
493579 | 493579 | 2020-09-02 | Caroline | Maryland | 24011 | 520 | 3 |
490345 | 490345 | 2020-09-01 | Caroline | Maryland | 24011 | 513 | 3 |
487112 | 487112 | 2020-08-31 | Caroline | Maryland | 24011 | 510 | 3 |
483878 | 483878 | 2020-08-30 | Caroline | Maryland | 24011 | 504 | 3 |
480643 | 480643 | 2020-08-29 | Caroline | Maryland | 24011 | 496 | 3 |
480656 | 480656 | 2020-08-29 | Somerset | Maryland | 24039 | 192 | 3 |
477411 | 477411 | 2020-08-28 | Caroline | Maryland | 24011 | 489 | 3 |
477424 | 477424 | 2020-08-28 | Somerset | Maryland | 24039 | 191 | 3 |
474178 | 474178 | 2020-08-27 | Caroline | Maryland | 24011 | 485 | 3 |
474191 | 474191 | 2020-08-27 | Somerset | Maryland | 24039 | 187 | 3 |
470946 | 470946 | 2020-08-26 | Caroline | Maryland | 24011 | 481 | 3 |
470959 | 470959 | 2020-08-26 | Somerset | Maryland | 24039 | 183 | 3 |
467716 | 467716 | 2020-08-25 | Caroline | Maryland | 24011 | 480 | 3 |
467729 | 467729 | 2020-08-25 | Somerset | Maryland | 24039 | 181 | 3 |
464487 | 464487 | 2020-08-24 | Caroline | Maryland | 24011 | 479 | 3 |
464500 | 464500 | 2020-08-24 | Somerset | Maryland | 24039 | 176 | 3 |
461256 | 461256 | 2020-08-23 | Caroline | Maryland | 24011 | 478 | 3 |
461269 | 461269 | 2020-08-23 | Somerset | Maryland | 24039 | 176 | 3 |
458029 | 458029 | 2020-08-22 | Caroline | Maryland | 24011 | 477 | 3 |
458042 | 458042 | 2020-08-22 | Somerset | Maryland | 24039 | 176 | 3 |
454801 | 454801 | 2020-08-21 | Caroline | Maryland | 24011 | 472 | 3 |
454814 | 454814 | 2020-08-21 | Somerset | Maryland | 24039 | 169 | 3 |
451573 | 451573 | 2020-08-20 | Caroline | Maryland | 24011 | 472 | 3 |
451586 | 451586 | 2020-08-20 | Somerset | Maryland | 24039 | 164 | 3 |
448345 | 448345 | 2020-08-19 | Caroline | Maryland | 24011 | 471 | 3 |
448358 | 448358 | 2020-08-19 | Somerset | Maryland | 24039 | 159 | 3 |
445119 | 445119 | 2020-08-18 | Caroline | Maryland | 24011 | 468 | 3 |
445132 | 445132 | 2020-08-18 | Somerset | Maryland | 24039 | 155 | 3 |
441893 | 441893 | 2020-08-17 | Caroline | Maryland | 24011 | 465 | 3 |
441906 | 441906 | 2020-08-17 | Somerset | Maryland | 24039 | 154 | 3 |
438666 | 438666 | 2020-08-16 | Caroline | Maryland | 24011 | 461 | 3 |
438679 | 438679 | 2020-08-16 | Somerset | Maryland | 24039 | 151 | 3 |
435441 | 435441 | 2020-08-15 | Caroline | Maryland | 24011 | 460 | 3 |
435454 | 435454 | 2020-08-15 | Somerset | Maryland | 24039 | 147 | 3 |
432215 | 432215 | 2020-08-14 | Caroline | Maryland | 24011 | 457 | 3 |
432228 | 432228 | 2020-08-14 | Somerset | Maryland | 24039 | 142 | 3 |
428988 | 428988 | 2020-08-13 | Caroline | Maryland | 24011 | 455 | 3 |
429001 | 429001 | 2020-08-13 | Somerset | Maryland | 24039 | 141 | 3 |
425764 | 425764 | 2020-08-12 | Caroline | Maryland | 24011 | 454 | 3 |
425777 | 425777 | 2020-08-12 | Somerset | Maryland | 24039 | 141 | 3 |
422542 | 422542 | 2020-08-11 | Caroline | Maryland | 24011 | 453 | 3 |
422555 | 422555 | 2020-08-11 | Somerset | Maryland | 24039 | 141 | 3 |
419320 | 419320 | 2020-08-10 | Caroline | Maryland | 24011 | 453 | 3 |
419333 | 419333 | 2020-08-10 | Somerset | Maryland | 24039 | 139 | 3 |
416099 | 416099 | 2020-08-09 | Caroline | Maryland | 24011 | 451 | 3 |
416112 | 416112 | 2020-08-09 | Somerset | Maryland | 24039 | 136 | 3 |
412879 | 412879 | 2020-08-08 | Caroline | Maryland | 24011 | 445 | 3 |
412892 | 412892 | 2020-08-08 | Somerset | Maryland | 24039 | 134 | 3 |
409659 | 409659 | 2020-08-07 | Caroline | Maryland | 24011 | 445 | 3 |
409672 | 409672 | 2020-08-07 | Somerset | Maryland | 24039 | 133 | 3 |
406439 | 406439 | 2020-08-06 | Caroline | Maryland | 24011 | 444 | 3 |
406452 | 406452 | 2020-08-06 | Somerset | Maryland | 24039 | 130 | 3 |
403221 | 403221 | 2020-08-05 | Caroline | Maryland | 24011 | 441 | 3 |
403234 | 403234 | 2020-08-05 | Somerset | Maryland | 24039 | 129 | 3 |
400004 | 400004 | 2020-08-04 | Caroline | Maryland | 24011 | 439 | 3 |
400017 | 400017 | 2020-08-04 | Somerset | Maryland | 24039 | 129 | 3 |
396790 | 396790 | 2020-08-03 | Caroline | Maryland | 24011 | 438 | 3 |
396803 | 396803 | 2020-08-03 | Somerset | Maryland | 24039 | 123 | 3 |
393574 | 393574 | 2020-08-02 | Caroline | Maryland | 24011 | 432 | 3 |
393587 | 393587 | 2020-08-02 | Somerset | Maryland | 24039 | 123 | 3 |
390357 | 390357 | 2020-08-01 | Caroline | Maryland | 24011 | 430 | 3 |
390370 | 390370 | 2020-08-01 | Somerset | Maryland | 24039 | 121 | 3 |
387140 | 387140 | 2020-07-31 | Caroline | Maryland | 24011 | 423 | 3 |
387153 | 387153 | 2020-07-31 | Somerset | Maryland | 24039 | 119 | 3 |
383922 | 383922 | 2020-07-30 | Caroline | Maryland | 24011 | 418 | 3 |
383935 | 383935 | 2020-07-30 | Somerset | Maryland | 24039 | 117 | 3 |
380705 | 380705 | 2020-07-29 | Caroline | Maryland | 24011 | 418 | 3 |
380718 | 380718 | 2020-07-29 | Somerset | Maryland | 24039 | 116 | 3 |
377488 | 377488 | 2020-07-28 | Caroline | Maryland | 24011 | 416 | 3 |
377501 | 377501 | 2020-07-28 | Somerset | Maryland | 24039 | 116 | 3 |
374273 | 374273 | 2020-07-27 | Caroline | Maryland | 24011 | 412 | 3 |
374286 | 374286 | 2020-07-27 | Somerset | Maryland | 24039 | 115 | 3 |
371061 | 371061 | 2020-07-26 | Caroline | Maryland | 24011 | 403 | 3 |
371074 | 371074 | 2020-07-26 | Somerset | Maryland | 24039 | 114 | 3 |
367851 | 367851 | 2020-07-25 | Caroline | Maryland | 24011 | 393 | 3 |
367864 | 367864 | 2020-07-25 | Somerset | Maryland | 24039 | 114 | 3 |
364644 | 364644 | 2020-07-24 | Caroline | Maryland | 24011 | 374 | 3 |
364657 | 364657 | 2020-07-24 | Somerset | Maryland | 24039 | 114 | 3 |
361437 | 361437 | 2020-07-23 | Caroline | Maryland | 24011 | 371 | 3 |
361450 | 361450 | 2020-07-23 | Somerset | Maryland | 24039 | 111 | 3 |
358232 | 358232 | 2020-07-22 | Caroline | Maryland | 24011 | 368 | 3 |
358245 | 358245 | 2020-07-22 | Somerset | Maryland | 24039 | 110 | 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);