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

788 rows where fips = 53045 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 53045 · 788 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502665 2502665 2022-05-13 Mason Washington 53045 12661 139
2499407 2499407 2022-05-12 Mason Washington 53045 12589 139
2496149 2496149 2022-05-11 Mason Washington 53045 12589 139
2492891 2492891 2022-05-10 Mason Washington 53045 12575 139
2489633 2489633 2022-05-09 Mason Washington 53045 12575 139
2486376 2486376 2022-05-08 Mason Washington 53045 12503 139
2483118 2483118 2022-05-07 Mason Washington 53045 12503 139
2479860 2479860 2022-05-06 Mason Washington 53045 12503 139
2476602 2476602 2022-05-05 Mason Washington 53045 12503 139
2473344 2473344 2022-05-04 Mason Washington 53045 12503 139
2470088 2470088 2022-05-03 Mason Washington 53045 12528 139
2466832 2466832 2022-05-02 Mason Washington 53045 12528 139
2463577 2463577 2022-05-01 Mason Washington 53045 12468 139
2460321 2460321 2022-04-30 Mason Washington 53045 12468 139
2457065 2457065 2022-04-29 Mason Washington 53045 12468 139
2453809 2453809 2022-04-28 Mason Washington 53045 12439 139
2450553 2450553 2022-04-27 Mason Washington 53045 12439 139
2447297 2447297 2022-04-26 Mason Washington 53045 12420 139
2444041 2444041 2022-04-25 Mason Washington 53045 12420 139
2440785 2440785 2022-04-24 Mason Washington 53045 12395 139
2437529 2437529 2022-04-23 Mason Washington 53045 12395 139
2434273 2434273 2022-04-22 Mason Washington 53045 12395 139
2431017 2431017 2022-04-21 Mason Washington 53045 12378 140
2427761 2427761 2022-04-20 Mason Washington 53045 12378 140
2424505 2424505 2022-04-19 Mason Washington 53045 12369 141
2421249 2421249 2022-04-18 Mason Washington 53045 12369 141
2417993 2417993 2022-04-17 Mason Washington 53045 12333 141
2414737 2414737 2022-04-16 Mason Washington 53045 12333 141
2411481 2411481 2022-04-15 Mason Washington 53045 12333 141
2408225 2408225 2022-04-14 Mason Washington 53045 12322 140
2404969 2404969 2022-04-13 Mason Washington 53045 12322 140
2401714 2401714 2022-04-12 Mason Washington 53045 12310 140
2398459 2398459 2022-04-11 Mason Washington 53045 12310 140
2395204 2395204 2022-04-10 Mason Washington 53045 12310 140
2391948 2391948 2022-04-09 Mason Washington 53045 12310 140
2388692 2388692 2022-04-08 Mason Washington 53045 12310 140
2385437 2385437 2022-04-07 Mason Washington 53045 12300 139
2382182 2382182 2022-04-06 Mason Washington 53045 12300 139
2378927 2378927 2022-04-05 Mason Washington 53045 12295 139
2375673 2375673 2022-04-04 Mason Washington 53045 12295 139
2372421 2372421 2022-04-03 Mason Washington 53045 12282 139
2369168 2369168 2022-04-02 Mason Washington 53045 12282 139
2365915 2365915 2022-04-01 Mason Washington 53045 12282 139
2362662 2362662 2022-03-31 Mason Washington 53045 12272 138
2359408 2359408 2022-03-30 Mason Washington 53045 12272 138
2356154 2356154 2022-03-29 Mason Washington 53045 12269 137
2352901 2352901 2022-03-28 Mason Washington 53045 12269 137
2349649 2349649 2022-03-27 Mason Washington 53045 12236 137
2346396 2346396 2022-03-26 Mason Washington 53045 12236 137
2343143 2343143 2022-03-25 Mason Washington 53045 12236 137
2339890 2339890 2022-03-24 Mason Washington 53045 12231 136
2336637 2336637 2022-03-23 Mason Washington 53045 12231 136
2333383 2333383 2022-03-22 Mason Washington 53045 12219 136
2330129 2330129 2022-03-21 Mason Washington 53045 12219 136
2326877 2326877 2022-03-20 Mason Washington 53045 12173 135
2323624 2323624 2022-03-19 Mason Washington 53045 12173 135
2320370 2320370 2022-03-18 Mason Washington 53045 12173 135
2317116 2317116 2022-03-17 Mason Washington 53045 12148 134
2313863 2313863 2022-03-16 Mason Washington 53045 12148 134
2310610 2310610 2022-03-15 Mason Washington 53045 12134 133
2307357 2307357 2022-03-14 Mason Washington 53045 12134 133
2304106 2304106 2022-03-13 Mason Washington 53045 12125 133
2300854 2300854 2022-03-12 Mason Washington 53045 12125 133
2297602 2297602 2022-03-11 Mason Washington 53045 12125 133
2294350 2294350 2022-03-10 Mason Washington 53045 12106 132
2291098 2291098 2022-03-09 Mason Washington 53045 12106 132
2287846 2287846 2022-03-08 Mason Washington 53045 12082 131
2284594 2284594 2022-03-07 Mason Washington 53045 12082 131
2281342 2281342 2022-03-06 Mason Washington 53045 12069 129
2278089 2278089 2022-03-05 Mason Washington 53045 12069 129
2274836 2274836 2022-03-04 Mason Washington 53045 12069 129
2271583 2271583 2022-03-03 Mason Washington 53045 12054 127
2268331 2268331 2022-03-02 Mason Washington 53045 12054 127
2265078 2265078 2022-03-01 Mason Washington 53045 12027 127
2261828 2261828 2022-02-28 Mason Washington 53045 12027 127
2258577 2258577 2022-02-27 Mason Washington 53045 12008 127
2255326 2255326 2022-02-26 Mason Washington 53045 12008 127
2252075 2252075 2022-02-25 Mason Washington 53045 12008 127
2248824 2248824 2022-02-24 Mason Washington 53045 11979 128
2245573 2245573 2022-02-23 Mason Washington 53045 11979 128
2242322 2242322 2022-02-22 Mason Washington 53045 11769 128
2239071 2239071 2022-02-21 Mason Washington 53045 11769 128
2235820 2235820 2022-02-20 Mason Washington 53045 11769 128
2232569 2232569 2022-02-19 Mason Washington 53045 11769 128
2229318 2229318 2022-02-18 Mason Washington 53045 11769 128
2226067 2226067 2022-02-17 Mason Washington 53045 11713 127
2222816 2222816 2022-02-16 Mason Washington 53045 11713 127
2219565 2219565 2022-02-15 Mason Washington 53045 11726 125
2216315 2216315 2022-02-14 Mason Washington 53045 11726 125
2213064 2213064 2022-02-13 Mason Washington 53045 11702 126
2209811 2209811 2022-02-12 Mason Washington 53045 11702 126
2206558 2206558 2022-02-11 Mason Washington 53045 11702 126
2203305 2203305 2022-02-10 Mason Washington 53045 11499 125
2200051 2200051 2022-02-09 Mason Washington 53045 11499 125
2196797 2196797 2022-02-08 Mason Washington 53045 11442 123
2193542 2193542 2022-02-07 Mason Washington 53045 11442 123
2190289 2190289 2022-02-06 Mason Washington 53045 11212 120
2187036 2187036 2022-02-05 Mason Washington 53045 11212 120
2183783 2183783 2022-02-04 Mason Washington 53045 11212 120
2180531 2180531 2022-02-03 Mason Washington 53045 11035 117

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