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

775 rows where county = "Brown", fips = 39015 and state = "Ohio" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Ohio · 775 ✖

fips 1

  • 39015 · 775 ✖

county 1

  • Brown · 775 ✖
Link rowid date ▲ county state fips cases deaths
2501651 2501651 2022-05-13 Brown Ohio 39015 11248 180
2498393 2498393 2022-05-12 Brown Ohio 39015 11248 180
2495135 2495135 2022-05-11 Brown Ohio 39015 11216 180
2491877 2491877 2022-05-10 Brown Ohio 39015 11216 180
2488619 2488619 2022-05-09 Brown Ohio 39015 11216 180
2485362 2485362 2022-05-08 Brown Ohio 39015 11216 180
2482104 2482104 2022-05-07 Brown Ohio 39015 11216 180
2478846 2478846 2022-05-06 Brown Ohio 39015 11216 180
2475588 2475588 2022-05-05 Brown Ohio 39015 11216 180
2472331 2472331 2022-05-04 Brown Ohio 39015 11200 180
2469075 2469075 2022-05-03 Brown Ohio 39015 11200 180
2465819 2465819 2022-05-02 Brown Ohio 39015 11200 180
2462564 2462564 2022-05-01 Brown Ohio 39015 11200 180
2459308 2459308 2022-04-30 Brown Ohio 39015 11200 180
2456052 2456052 2022-04-29 Brown Ohio 39015 11200 180
2452796 2452796 2022-04-28 Brown Ohio 39015 11200 180
2449540 2449540 2022-04-27 Brown Ohio 39015 11188 179
2446283 2446283 2022-04-26 Brown Ohio 39015 11188 179
2443028 2443028 2022-04-25 Brown Ohio 39015 11188 179
2439772 2439772 2022-04-24 Brown Ohio 39015 11188 179
2436516 2436516 2022-04-23 Brown Ohio 39015 11188 179
2433260 2433260 2022-04-22 Brown Ohio 39015 11188 179
2430004 2430004 2022-04-21 Brown Ohio 39015 11188 179
2426748 2426748 2022-04-20 Brown Ohio 39015 11183 178
2423492 2423492 2022-04-19 Brown Ohio 39015 11183 178
2420235 2420235 2022-04-18 Brown Ohio 39015 11183 178
2416980 2416980 2022-04-17 Brown Ohio 39015 11183 178
2413724 2413724 2022-04-16 Brown Ohio 39015 11183 178
2410468 2410468 2022-04-15 Brown Ohio 39015 11183 178
2407212 2407212 2022-04-14 Brown Ohio 39015 11183 178
2403956 2403956 2022-04-13 Brown Ohio 39015 11179 177
2400701 2400701 2022-04-12 Brown Ohio 39015 11179 177
2397446 2397446 2022-04-11 Brown Ohio 39015 11179 177
2394191 2394191 2022-04-10 Brown Ohio 39015 11179 177
2390935 2390935 2022-04-09 Brown Ohio 39015 11179 177
2387679 2387679 2022-04-08 Brown Ohio 39015 11179 177
2384424 2384424 2022-04-07 Brown Ohio 39015 11179 177
2381169 2381169 2022-04-06 Brown Ohio 39015 11176 176
2377914 2377914 2022-04-05 Brown Ohio 39015 11176 176
2374660 2374660 2022-04-04 Brown Ohio 39015 11176 176
2371408 2371408 2022-04-03 Brown Ohio 39015 11176 176
2368155 2368155 2022-04-02 Brown Ohio 39015 11176 176
2364902 2364902 2022-04-01 Brown Ohio 39015 11176 176
2361649 2361649 2022-03-31 Brown Ohio 39015 11176 176
2358395 2358395 2022-03-30 Brown Ohio 39015 11171 175
2355141 2355141 2022-03-29 Brown Ohio 39015 11171 175
2351888 2351888 2022-03-28 Brown Ohio 39015 11171 175
2348636 2348636 2022-03-27 Brown Ohio 39015 11171 175
2345383 2345383 2022-03-26 Brown Ohio 39015 11171 175
2342130 2342130 2022-03-25 Brown Ohio 39015 11171 175
2338877 2338877 2022-03-24 Brown Ohio 39015 11171 175
2335623 2335623 2022-03-23 Brown Ohio 39015 11165 174
2332369 2332369 2022-03-22 Brown Ohio 39015 11165 174
2329116 2329116 2022-03-21 Brown Ohio 39015 11165 174
2325864 2325864 2022-03-20 Brown Ohio 39015 11165 174
2322611 2322611 2022-03-19 Brown Ohio 39015 11165 174
2319357 2319357 2022-03-18 Brown Ohio 39015 11165 174
2316103 2316103 2022-03-17 Brown Ohio 39015 11165 174
2312850 2312850 2022-03-16 Brown Ohio 39015 11160 174
2309597 2309597 2022-03-15 Brown Ohio 39015 11160 174
2306344 2306344 2022-03-14 Brown Ohio 39015 11160 174
2303093 2303093 2022-03-13 Brown Ohio 39015 11160 174
2299841 2299841 2022-03-12 Brown Ohio 39015 11160 174
2296589 2296589 2022-03-11 Brown Ohio 39015 11157 174
2293337 2293337 2022-03-10 Brown Ohio 39015 11154 173
2290085 2290085 2022-03-09 Brown Ohio 39015 11151 173
2286833 2286833 2022-03-08 Brown Ohio 39015 11148 173
2283581 2283581 2022-03-07 Brown Ohio 39015 11146 169
2280329 2280329 2022-03-06 Brown Ohio 39015 11146 169
2277076 2277076 2022-03-05 Brown Ohio 39015 11146 169
2273823 2273823 2022-03-04 Brown Ohio 39015 11144 169
2270570 2270570 2022-03-03 Brown Ohio 39015 11138 167
2267318 2267318 2022-03-02 Brown Ohio 39015 11135 167
2264065 2264065 2022-03-01 Brown Ohio 39015 11132 167
2260815 2260815 2022-02-28 Brown Ohio 39015 11125 166
2257564 2257564 2022-02-27 Brown Ohio 39015 11122 166
2254313 2254313 2022-02-26 Brown Ohio 39015 11122 166
2251062 2251062 2022-02-25 Brown Ohio 39015 11117 166
2247811 2247811 2022-02-24 Brown Ohio 39015 11108 163
2244560 2244560 2022-02-23 Brown Ohio 39015 11100 163
2241309 2241309 2022-02-22 Brown Ohio 39015 11093 163
2238058 2238058 2022-02-21 Brown Ohio 39015 11084 161
2234807 2234807 2022-02-20 Brown Ohio 39015 11079 161
2231556 2231556 2022-02-19 Brown Ohio 39015 11077 161
2228305 2228305 2022-02-18 Brown Ohio 39015 11069 161
2225054 2225054 2022-02-17 Brown Ohio 39015 11059 160
2221803 2221803 2022-02-16 Brown Ohio 39015 11044 160
2218552 2218552 2022-02-15 Brown Ohio 39015 11031 160
2215301 2215301 2022-02-14 Brown Ohio 39015 11019 156
2212050 2212050 2022-02-13 Brown Ohio 39015 11012 156
2208797 2208797 2022-02-12 Brown Ohio 39015 10996 156
2205544 2205544 2022-02-11 Brown Ohio 39015 10989 156
2202291 2202291 2022-02-10 Brown Ohio 39015 10973 154
2199037 2199037 2022-02-09 Brown Ohio 39015 10952 154
2195783 2195783 2022-02-08 Brown Ohio 39015 10919 154
2192529 2192529 2022-02-07 Brown Ohio 39015 10874 151
2189275 2189275 2022-02-06 Brown Ohio 39015 10857 151
2186022 2186022 2022-02-05 Brown Ohio 39015 10846 151
2182770 2182770 2022-02-04 Brown Ohio 39015 10838 151
2179518 2179518 2022-02-03 Brown Ohio 39015 10816 149

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