home / covid

Menu
  • GraphQL API

ny_times_us_counties

Table actions
  • GraphQL API for ny_times_us_counties
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

8,549 rows where county = "Morgan" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 11

  • Colorado 786
  • Indiana 783
  • Georgia 782
  • Alabama 781
  • Illinois 780
  • Utah 779
  • Tennessee 777
  • West Virginia 776
  • Missouri 775
  • Ohio 768
  • Kentucky 762

fips 11

  • 8087 786
  • 18109 783
  • 13211 782
  • 1103 781
  • 17137 780
  • 49029 779
  • 47129 777
  • 54065 776
  • 29141 775
  • 39115 768
  • 21175 762

county 1

  • Morgan · 8,549 ✖
Link rowid date ▲ county state fips cases deaths
2499626 2499626 2022-05-13 Morgan Alabama 1103 36167 518
2499864 2499864 2022-05-13 Morgan Colorado 8087 5735 138
2500069 2500069 2022-05-13 Morgan Georgia 13211 4709 70
2500245 2500245 2022-05-13 Morgan Illinois 17137 9661 144
2500334 2500334 2022-05-13 Morgan Indiana 18109 16603 287
2500666 2500666 2022-05-13 Morgan Kentucky 21175 5272 28
2501148 2501148 2022-05-13 Morgan Missouri 29141 4053 115
2501701 2501701 2022-05-13 Morgan Ohio 39115 3278 60
2502175 2502175 2022-05-13 Morgan Tennessee 47129 6209 87
2502476 2502476 2022-05-13 Morgan Utah 49029 2903 15
2502715 2502715 2022-05-13 Morgan West Virginia 54065 4307 69
2496368 2496368 2022-05-12 Morgan Alabama 1103 36154 517
2496606 2496606 2022-05-12 Morgan Colorado 8087 5734 138
2496811 2496811 2022-05-12 Morgan Georgia 13211 4709 70
2496987 2496987 2022-05-12 Morgan Illinois 17137 9652 144
2497076 2497076 2022-05-12 Morgan Indiana 18109 16575 287
2497408 2497408 2022-05-12 Morgan Kentucky 21175 5272 28
2497890 2497890 2022-05-12 Morgan Missouri 29141 4048 115
2498443 2498443 2022-05-12 Morgan Ohio 39115 3278 60
2498917 2498917 2022-05-12 Morgan Tennessee 47129 6209 87
2499218 2499218 2022-05-12 Morgan Utah 49029 2903 15
2499457 2499457 2022-05-12 Morgan West Virginia 54065 4303 69
2493110 2493110 2022-05-11 Morgan Alabama 1103 36150 516
2493348 2493348 2022-05-11 Morgan Colorado 8087 5707 138
2493553 2493553 2022-05-11 Morgan Georgia 13211 4709 70
2493729 2493729 2022-05-11 Morgan Illinois 17137 9642 144
2493818 2493818 2022-05-11 Morgan Indiana 18109 16575 287
2494150 2494150 2022-05-11 Morgan Kentucky 21175 5272 28
2494632 2494632 2022-05-11 Morgan Missouri 29141 4048 115
2495185 2495185 2022-05-11 Morgan Ohio 39115 3277 60
2495659 2495659 2022-05-11 Morgan Tennessee 47129 6209 87
2495960 2495960 2022-05-11 Morgan Utah 49029 2903 15
2496199 2496199 2022-05-11 Morgan West Virginia 54065 4301 69
2489852 2489852 2022-05-10 Morgan Alabama 1103 36138 516
2490090 2490090 2022-05-10 Morgan Colorado 8087 5706 138
2490295 2490295 2022-05-10 Morgan Georgia 13211 4699 69
2490471 2490471 2022-05-10 Morgan Illinois 17137 9635 144
2490560 2490560 2022-05-10 Morgan Indiana 18109 16553 287
2490892 2490892 2022-05-10 Morgan Kentucky 21175 5272 28
2491374 2491374 2022-05-10 Morgan Missouri 29141 4048 115
2491927 2491927 2022-05-10 Morgan Ohio 39115 3277 60
2492401 2492401 2022-05-10 Morgan Tennessee 47129 6201 86
2492702 2492702 2022-05-10 Morgan Utah 49029 2901 15
2492941 2492941 2022-05-10 Morgan West Virginia 54065 4298 69
2486595 2486595 2022-05-09 Morgan Alabama 1103 36130 516
2486833 2486833 2022-05-09 Morgan Colorado 8087 5704 138
2487038 2487038 2022-05-09 Morgan Georgia 13211 4699 69
2487214 2487214 2022-05-09 Morgan Illinois 17137 9629 144
2487303 2487303 2022-05-09 Morgan Indiana 18109 16553 287
2487635 2487635 2022-05-09 Morgan Kentucky 21175 5272 28
2488116 2488116 2022-05-09 Morgan Missouri 29141 4048 115
2488669 2488669 2022-05-09 Morgan Ohio 39115 3277 60
2489143 2489143 2022-05-09 Morgan Tennessee 47129 6201 86
2489444 2489444 2022-05-09 Morgan Utah 49029 2901 15
2489683 2489683 2022-05-09 Morgan West Virginia 54065 4298 69
2483337 2483337 2022-05-08 Morgan Alabama 1103 36116 516
2483575 2483575 2022-05-08 Morgan Colorado 8087 5700 138
2483780 2483780 2022-05-08 Morgan Georgia 13211 4698 69
2483956 2483956 2022-05-08 Morgan Illinois 17137 9612 144
2484045 2484045 2022-05-08 Morgan Indiana 18109 16529 287
2484377 2484377 2022-05-08 Morgan Kentucky 21175 5247 25
2484859 2484859 2022-05-08 Morgan Missouri 29141 4048 115
2485412 2485412 2022-05-08 Morgan Ohio 39115 3277 60
2485886 2485886 2022-05-08 Morgan Tennessee 47129 6201 86
2486186 2486186 2022-05-08 Morgan Utah 49029 2899 15
2486426 2486426 2022-05-08 Morgan West Virginia 54065 4295 69
2480079 2480079 2022-05-07 Morgan Alabama 1103 36116 516
2480317 2480317 2022-05-07 Morgan Colorado 8087 5700 138
2480522 2480522 2022-05-07 Morgan Georgia 13211 4698 69
2480698 2480698 2022-05-07 Morgan Illinois 17137 9612 144
2480787 2480787 2022-05-07 Morgan Indiana 18109 16529 287
2481119 2481119 2022-05-07 Morgan Kentucky 21175 5247 25
2481601 2481601 2022-05-07 Morgan Missouri 29141 4048 115
2482154 2482154 2022-05-07 Morgan Ohio 39115 3277 60
2482628 2482628 2022-05-07 Morgan Tennessee 47129 6201 86
2482928 2482928 2022-05-07 Morgan Utah 49029 2899 15
2483168 2483168 2022-05-07 Morgan West Virginia 54065 4295 69
2476821 2476821 2022-05-06 Morgan Alabama 1103 36116 516
2477059 2477059 2022-05-06 Morgan Colorado 8087 5700 138
2477264 2477264 2022-05-06 Morgan Georgia 13211 4698 69
2477440 2477440 2022-05-06 Morgan Illinois 17137 9612 144
2477529 2477529 2022-05-06 Morgan Indiana 18109 16529 287
2477861 2477861 2022-05-06 Morgan Kentucky 21175 5247 25
2478343 2478343 2022-05-06 Morgan Missouri 29141 4048 115
2478896 2478896 2022-05-06 Morgan Ohio 39115 3277 60
2479370 2479370 2022-05-06 Morgan Tennessee 47129 6201 86
2479670 2479670 2022-05-06 Morgan Utah 49029 2899 15
2479910 2479910 2022-05-06 Morgan West Virginia 54065 4295 69
2473563 2473563 2022-05-05 Morgan Alabama 1103 36113 516
2473801 2473801 2022-05-05 Morgan Colorado 8087 5697 138
2474006 2474006 2022-05-05 Morgan Georgia 13211 4698 69
2474182 2474182 2022-05-05 Morgan Illinois 17137 9599 144
2474271 2474271 2022-05-05 Morgan Indiana 18109 16529 287
2474603 2474603 2022-05-05 Morgan Kentucky 21175 5247 25
2475085 2475085 2022-05-05 Morgan Missouri 29141 4042 115
2475638 2475638 2022-05-05 Morgan Ohio 39115 3277 60
2476112 2476112 2022-05-05 Morgan Tennessee 47129 6201 86
2476412 2476412 2022-05-05 Morgan Utah 49029 2899 15
2476652 2476652 2022-05-05 Morgan West Virginia 54065 4294 69
2470306 2470306 2022-05-04 Morgan Alabama 1103 36105 516

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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);
Powered by Datasette · Queries took 483.596ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette