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

777 rows where county = "Morgan" and fips = 47129 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Tennessee 777

fips 1

  • 47129 · 777 ✖

county 1

  • Morgan · 777 ✖
Link rowid date ▲ county state fips cases deaths
2502175 2502175 2022-05-13 Morgan Tennessee 47129 6209 87
2498917 2498917 2022-05-12 Morgan Tennessee 47129 6209 87
2495659 2495659 2022-05-11 Morgan Tennessee 47129 6209 87
2492401 2492401 2022-05-10 Morgan Tennessee 47129 6201 86
2489143 2489143 2022-05-09 Morgan Tennessee 47129 6201 86
2485886 2485886 2022-05-08 Morgan Tennessee 47129 6201 86
2482628 2482628 2022-05-07 Morgan Tennessee 47129 6201 86
2479370 2479370 2022-05-06 Morgan Tennessee 47129 6201 86
2476112 2476112 2022-05-05 Morgan Tennessee 47129 6201 86
2472855 2472855 2022-05-04 Morgan Tennessee 47129 6201 86
2469599 2469599 2022-05-03 Morgan Tennessee 47129 6197 86
2466343 2466343 2022-05-02 Morgan Tennessee 47129 6197 86
2463088 2463088 2022-05-01 Morgan Tennessee 47129 6197 86
2459832 2459832 2022-04-30 Morgan Tennessee 47129 6197 86
2456576 2456576 2022-04-29 Morgan Tennessee 47129 6197 86
2453320 2453320 2022-04-28 Morgan Tennessee 47129 6197 86
2450064 2450064 2022-04-27 Morgan Tennessee 47129 6197 86
2446807 2446807 2022-04-26 Morgan Tennessee 47129 6190 86
2443552 2443552 2022-04-25 Morgan Tennessee 47129 6190 86
2440296 2440296 2022-04-24 Morgan Tennessee 47129 6190 86
2437040 2437040 2022-04-23 Morgan Tennessee 47129 6190 86
2433784 2433784 2022-04-22 Morgan Tennessee 47129 6190 86
2430528 2430528 2022-04-21 Morgan Tennessee 47129 6190 86
2427272 2427272 2022-04-20 Morgan Tennessee 47129 6190 86
2424016 2424016 2022-04-19 Morgan Tennessee 47129 6188 86
2420760 2420760 2022-04-18 Morgan Tennessee 47129 6188 86
2417504 2417504 2022-04-17 Morgan Tennessee 47129 6188 86
2414248 2414248 2022-04-16 Morgan Tennessee 47129 6188 86
2410992 2410992 2022-04-15 Morgan Tennessee 47129 6188 86
2407736 2407736 2022-04-14 Morgan Tennessee 47129 6188 86
2404480 2404480 2022-04-13 Morgan Tennessee 47129 6188 86
2401225 2401225 2022-04-12 Morgan Tennessee 47129 6178 82
2397970 2397970 2022-04-11 Morgan Tennessee 47129 6178 82
2394715 2394715 2022-04-10 Morgan Tennessee 47129 6178 82
2391459 2391459 2022-04-09 Morgan Tennessee 47129 6178 82
2388203 2388203 2022-04-08 Morgan Tennessee 47129 6178 82
2384948 2384948 2022-04-07 Morgan Tennessee 47129 6178 82
2381693 2381693 2022-04-06 Morgan Tennessee 47129 6178 82
2378438 2378438 2022-04-05 Morgan Tennessee 47129 6159 80
2375184 2375184 2022-04-04 Morgan Tennessee 47129 6159 80
2371932 2371932 2022-04-03 Morgan Tennessee 47129 6159 80
2368679 2368679 2022-04-02 Morgan Tennessee 47129 6159 80
2365426 2365426 2022-04-01 Morgan Tennessee 47129 6159 80
2362173 2362173 2022-03-31 Morgan Tennessee 47129 6159 80
2358919 2358919 2022-03-30 Morgan Tennessee 47129 6159 80
2355665 2355665 2022-03-29 Morgan Tennessee 47129 6158 80
2352412 2352412 2022-03-28 Morgan Tennessee 47129 6158 80
2349160 2349160 2022-03-27 Morgan Tennessee 47129 6158 80
2345907 2345907 2022-03-26 Morgan Tennessee 47129 6158 80
2342654 2342654 2022-03-25 Morgan Tennessee 47129 6158 80
2339401 2339401 2022-03-24 Morgan Tennessee 47129 6158 80
2336147 2336147 2022-03-23 Morgan Tennessee 47129 6158 80
2332893 2332893 2022-03-22 Morgan Tennessee 47129 6151 80
2329640 2329640 2022-03-21 Morgan Tennessee 47129 6151 80
2326388 2326388 2022-03-20 Morgan Tennessee 47129 6151 80
2323135 2323135 2022-03-19 Morgan Tennessee 47129 6151 80
2319881 2319881 2022-03-18 Morgan Tennessee 47129 6151 80
2316627 2316627 2022-03-17 Morgan Tennessee 47129 6151 80
2313374 2313374 2022-03-16 Morgan Tennessee 47129 6151 80
2310121 2310121 2022-03-15 Morgan Tennessee 47129 6145 78
2306868 2306868 2022-03-14 Morgan Tennessee 47129 6145 78
2303617 2303617 2022-03-13 Morgan Tennessee 47129 6145 78
2300365 2300365 2022-03-12 Morgan Tennessee 47129 6145 78
2297113 2297113 2022-03-11 Morgan Tennessee 47129 6145 78
2293861 2293861 2022-03-10 Morgan Tennessee 47129 6145 78
2290609 2290609 2022-03-09 Morgan Tennessee 47129 6145 78
2287357 2287357 2022-03-08 Morgan Tennessee 47129 6102 77
2284105 2284105 2022-03-07 Morgan Tennessee 47129 6102 77
2280853 2280853 2022-03-06 Morgan Tennessee 47129 6102 77
2277600 2277600 2022-03-05 Morgan Tennessee 47129 6102 77
2274347 2274347 2022-03-04 Morgan Tennessee 47129 6102 77
2271094 2271094 2022-03-03 Morgan Tennessee 47129 6102 77
2267842 2267842 2022-03-02 Morgan Tennessee 47129 6102 77
2264589 2264589 2022-03-01 Morgan Tennessee 47129 5965 75
2261339 2261339 2022-02-28 Morgan Tennessee 47129 5965 75
2258088 2258088 2022-02-27 Morgan Tennessee 47129 5965 75
2254837 2254837 2022-02-26 Morgan Tennessee 47129 5965 75
2251586 2251586 2022-02-25 Morgan Tennessee 47129 5965 75
2248335 2248335 2022-02-24 Morgan Tennessee 47129 5965 75
2245084 2245084 2022-02-23 Morgan Tennessee 47129 5965 75
2241833 2241833 2022-02-22 Morgan Tennessee 47129 5872 73
2238582 2238582 2022-02-21 Morgan Tennessee 47129 5872 73
2235331 2235331 2022-02-20 Morgan Tennessee 47129 5872 73
2232080 2232080 2022-02-19 Morgan Tennessee 47129 5872 73
2228829 2228829 2022-02-18 Morgan Tennessee 47129 5872 73
2225578 2225578 2022-02-17 Morgan Tennessee 47129 5872 73
2222327 2222327 2022-02-16 Morgan Tennessee 47129 5872 73
2219076 2219076 2022-02-15 Morgan Tennessee 47129 5735 72
2215825 2215825 2022-02-14 Morgan Tennessee 47129 5735 72
2212574 2212574 2022-02-13 Morgan Tennessee 47129 5735 72
2209321 2209321 2022-02-12 Morgan Tennessee 47129 5735 72
2206068 2206068 2022-02-11 Morgan Tennessee 47129 5735 72
2202815 2202815 2022-02-10 Morgan Tennessee 47129 5735 72
2199561 2199561 2022-02-09 Morgan Tennessee 47129 5735 72
2196307 2196307 2022-02-08 Morgan Tennessee 47129 5392 66
2193053 2193053 2022-02-07 Morgan Tennessee 47129 5392 66
2189799 2189799 2022-02-06 Morgan Tennessee 47129 5392 66
2186546 2186546 2022-02-05 Morgan Tennessee 47129 5392 66
2183294 2183294 2022-02-04 Morgan Tennessee 47129 5392 66
2180042 2180042 2022-02-03 Morgan Tennessee 47129 5392 66

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 39.914ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette