ny_times_us_counties

Table actions
⚠️ 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 = "Johnson", fips = 47091 and state = "Tennessee" 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

  • 47091 · 777 ✖

county 1

  • Johnson · 777 ✖
Link rowid date ▲ county state fips cases deaths
2502156 2502156 2022-05-13 Johnson Tennessee 47091 5181 95
2498898 2498898 2022-05-12 Johnson Tennessee 47091 5181 95
2495640 2495640 2022-05-11 Johnson Tennessee 47091 5181 95
2492382 2492382 2022-05-10 Johnson Tennessee 47091 5174 95
2489124 2489124 2022-05-09 Johnson Tennessee 47091 5174 95
2485867 2485867 2022-05-08 Johnson Tennessee 47091 5174 95
2482609 2482609 2022-05-07 Johnson Tennessee 47091 5174 95
2479351 2479351 2022-05-06 Johnson Tennessee 47091 5174 95
2476093 2476093 2022-05-05 Johnson Tennessee 47091 5174 95
2472836 2472836 2022-05-04 Johnson Tennessee 47091 5174 95
2469580 2469580 2022-05-03 Johnson Tennessee 47091 5170 93
2466324 2466324 2022-05-02 Johnson Tennessee 47091 5170 93
2463069 2463069 2022-05-01 Johnson Tennessee 47091 5170 93
2459813 2459813 2022-04-30 Johnson Tennessee 47091 5170 93
2456557 2456557 2022-04-29 Johnson Tennessee 47091 5170 93
2453301 2453301 2022-04-28 Johnson Tennessee 47091 5170 93
2450045 2450045 2022-04-27 Johnson Tennessee 47091 5170 93
2446788 2446788 2022-04-26 Johnson Tennessee 47091 5167 93
2443533 2443533 2022-04-25 Johnson Tennessee 47091 5167 93
2440277 2440277 2022-04-24 Johnson Tennessee 47091 5167 93
2437021 2437021 2022-04-23 Johnson Tennessee 47091 5167 93
2433765 2433765 2022-04-22 Johnson Tennessee 47091 5167 93
2430509 2430509 2022-04-21 Johnson Tennessee 47091 5167 93
2427253 2427253 2022-04-20 Johnson Tennessee 47091 5167 93
2423997 2423997 2022-04-19 Johnson Tennessee 47091 5166 93
2420741 2420741 2022-04-18 Johnson Tennessee 47091 5166 93
2417485 2417485 2022-04-17 Johnson Tennessee 47091 5166 93
2414229 2414229 2022-04-16 Johnson Tennessee 47091 5166 93
2410973 2410973 2022-04-15 Johnson Tennessee 47091 5166 93
2407717 2407717 2022-04-14 Johnson Tennessee 47091 5166 93
2404461 2404461 2022-04-13 Johnson Tennessee 47091 5166 93
2401206 2401206 2022-04-12 Johnson Tennessee 47091 5164 89
2397951 2397951 2022-04-11 Johnson Tennessee 47091 5164 89
2394696 2394696 2022-04-10 Johnson Tennessee 47091 5164 89
2391440 2391440 2022-04-09 Johnson Tennessee 47091 5164 89
2388184 2388184 2022-04-08 Johnson Tennessee 47091 5164 89
2384929 2384929 2022-04-07 Johnson Tennessee 47091 5164 89
2381674 2381674 2022-04-06 Johnson Tennessee 47091 5164 89
2378419 2378419 2022-04-05 Johnson Tennessee 47091 5154 89
2375165 2375165 2022-04-04 Johnson Tennessee 47091 5154 89
2371913 2371913 2022-04-03 Johnson Tennessee 47091 5154 89
2368660 2368660 2022-04-02 Johnson Tennessee 47091 5154 89
2365407 2365407 2022-04-01 Johnson Tennessee 47091 5154 89
2362154 2362154 2022-03-31 Johnson Tennessee 47091 5154 89
2358900 2358900 2022-03-30 Johnson Tennessee 47091 5154 89
2355646 2355646 2022-03-29 Johnson Tennessee 47091 5139 88
2352393 2352393 2022-03-28 Johnson Tennessee 47091 5139 88
2349141 2349141 2022-03-27 Johnson Tennessee 47091 5139 88
2345888 2345888 2022-03-26 Johnson Tennessee 47091 5139 88
2342635 2342635 2022-03-25 Johnson Tennessee 47091 5139 88
2339382 2339382 2022-03-24 Johnson Tennessee 47091 5139 88
2336128 2336128 2022-03-23 Johnson Tennessee 47091 5139 88
2332874 2332874 2022-03-22 Johnson Tennessee 47091 5132 88
2329621 2329621 2022-03-21 Johnson Tennessee 47091 5132 88
2326369 2326369 2022-03-20 Johnson Tennessee 47091 5132 88
2323116 2323116 2022-03-19 Johnson Tennessee 47091 5132 88
2319862 2319862 2022-03-18 Johnson Tennessee 47091 5132 88
2316608 2316608 2022-03-17 Johnson Tennessee 47091 5132 88
2313355 2313355 2022-03-16 Johnson Tennessee 47091 5132 88
2310102 2310102 2022-03-15 Johnson Tennessee 47091 5131 87
2306849 2306849 2022-03-14 Johnson Tennessee 47091 5131 87
2303598 2303598 2022-03-13 Johnson Tennessee 47091 5131 87
2300346 2300346 2022-03-12 Johnson Tennessee 47091 5131 87
2297094 2297094 2022-03-11 Johnson Tennessee 47091 5131 87
2293842 2293842 2022-03-10 Johnson Tennessee 47091 5131 87
2290590 2290590 2022-03-09 Johnson Tennessee 47091 5131 87
2287338 2287338 2022-03-08 Johnson Tennessee 47091 5096 85
2284086 2284086 2022-03-07 Johnson Tennessee 47091 5096 85
2280834 2280834 2022-03-06 Johnson Tennessee 47091 5096 85
2277581 2277581 2022-03-05 Johnson Tennessee 47091 5096 85
2274328 2274328 2022-03-04 Johnson Tennessee 47091 5096 85
2271075 2271075 2022-03-03 Johnson Tennessee 47091 5096 85
2267823 2267823 2022-03-02 Johnson Tennessee 47091 5096 85
2264570 2264570 2022-03-01 Johnson Tennessee 47091 5047 77
2261320 2261320 2022-02-28 Johnson Tennessee 47091 5047 77
2258069 2258069 2022-02-27 Johnson Tennessee 47091 5047 77
2254818 2254818 2022-02-26 Johnson Tennessee 47091 5047 77
2251567 2251567 2022-02-25 Johnson Tennessee 47091 5047 77
2248316 2248316 2022-02-24 Johnson Tennessee 47091 5047 77
2245065 2245065 2022-02-23 Johnson Tennessee 47091 5047 77
2241814 2241814 2022-02-22 Johnson Tennessee 47091 4970 75
2238563 2238563 2022-02-21 Johnson Tennessee 47091 4970 75
2235312 2235312 2022-02-20 Johnson Tennessee 47091 4970 75
2232061 2232061 2022-02-19 Johnson Tennessee 47091 4970 75
2228810 2228810 2022-02-18 Johnson Tennessee 47091 4970 75
2225559 2225559 2022-02-17 Johnson Tennessee 47091 4970 75
2222308 2222308 2022-02-16 Johnson Tennessee 47091 4970 75
2219057 2219057 2022-02-15 Johnson Tennessee 47091 4878 75
2215806 2215806 2022-02-14 Johnson Tennessee 47091 4878 75
2212555 2212555 2022-02-13 Johnson Tennessee 47091 4878 75
2209302 2209302 2022-02-12 Johnson Tennessee 47091 4878 75
2206049 2206049 2022-02-11 Johnson Tennessee 47091 4878 75
2202796 2202796 2022-02-10 Johnson Tennessee 47091 4878 75
2199542 2199542 2022-02-09 Johnson Tennessee 47091 4878 75
2196288 2196288 2022-02-08 Johnson Tennessee 47091 4742 73
2193034 2193034 2022-02-07 Johnson Tennessee 47091 4742 73
2189780 2189780 2022-02-06 Johnson Tennessee 47091 4742 73
2186527 2186527 2022-02-05 Johnson Tennessee 47091 4742 73
2183275 2183275 2022-02-04 Johnson Tennessee 47091 4742 73
2180023 2180023 2022-02-03 Johnson Tennessee 47091 4742 73

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);