ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,577 rows where county = "Medina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2338921 | 2338921 | 2022-03-24 | Medina | Ohio | 39103 | 39955 | 501 |
2339595 | 2339595 | 2022-03-24 | Medina | Texas | 48325 | 10167 | 196 |
2335667 | 2335667 | 2022-03-23 | Medina | Ohio | 39103 | 39906 | 498 |
2336341 | 2336341 | 2022-03-23 | Medina | Texas | 48325 | 10165 | 196 |
2332413 | 2332413 | 2022-03-22 | Medina | Ohio | 39103 | 39906 | 498 |
2333087 | 2333087 | 2022-03-22 | Medina | Texas | 48325 | 10157 | 196 |
2329160 | 2329160 | 2022-03-21 | Medina | Ohio | 39103 | 39906 | 498 |
2329834 | 2329834 | 2022-03-21 | Medina | Texas | 48325 | 10153 | 196 |
2325908 | 2325908 | 2022-03-20 | Medina | Ohio | 39103 | 39906 | 498 |
2326582 | 2326582 | 2022-03-20 | Medina | Texas | 48325 | 10150 | 196 |
2322655 | 2322655 | 2022-03-19 | Medina | Ohio | 39103 | 39906 | 498 |
2323329 | 2323329 | 2022-03-19 | Medina | Texas | 48325 | 10149 | 196 |
2319401 | 2319401 | 2022-03-18 | Medina | Ohio | 39103 | 39906 | 498 |
2320075 | 2320075 | 2022-03-18 | Medina | Texas | 48325 | 10147 | 195 |
2316147 | 2316147 | 2022-03-17 | Medina | Ohio | 39103 | 39906 | 498 |
2316821 | 2316821 | 2022-03-17 | Medina | Texas | 48325 | 10133 | 195 |
2312894 | 2312894 | 2022-03-16 | Medina | Ohio | 39103 | 39884 | 498 |
2313568 | 2313568 | 2022-03-16 | Medina | Texas | 48325 | 10119 | 195 |
2309641 | 2309641 | 2022-03-15 | Medina | Ohio | 39103 | 39884 | 498 |
2310315 | 2310315 | 2022-03-15 | Medina | Texas | 48325 | 10107 | 195 |
2306388 | 2306388 | 2022-03-14 | Medina | Ohio | 39103 | 39884 | 498 |
2307062 | 2307062 | 2022-03-14 | Medina | Texas | 48325 | 10087 | 195 |
2303137 | 2303137 | 2022-03-13 | Medina | Ohio | 39103 | 39884 | 498 |
2303811 | 2303811 | 2022-03-13 | Medina | Texas | 48325 | 10086 | 195 |
2299885 | 2299885 | 2022-03-12 | Medina | Ohio | 39103 | 39878 | 498 |
2300559 | 2300559 | 2022-03-12 | Medina | Texas | 48325 | 10086 | 195 |
2296633 | 2296633 | 2022-03-11 | Medina | Ohio | 39103 | 39871 | 498 |
2297307 | 2297307 | 2022-03-11 | Medina | Texas | 48325 | 10077 | 195 |
2293381 | 2293381 | 2022-03-10 | Medina | Ohio | 39103 | 39867 | 496 |
2294055 | 2294055 | 2022-03-10 | Medina | Texas | 48325 | 10058 | 195 |
2290129 | 2290129 | 2022-03-09 | Medina | Ohio | 39103 | 39857 | 496 |
2290803 | 2290803 | 2022-03-09 | Medina | Texas | 48325 | 10038 | 195 |
2286877 | 2286877 | 2022-03-08 | Medina | Ohio | 39103 | 39852 | 496 |
2287551 | 2287551 | 2022-03-08 | Medina | Texas | 48325 | 10012 | 194 |
2283625 | 2283625 | 2022-03-07 | Medina | Ohio | 39103 | 39846 | 494 |
2284299 | 2284299 | 2022-03-07 | Medina | Texas | 48325 | 9992 | 194 |
2280373 | 2280373 | 2022-03-06 | Medina | Ohio | 39103 | 39842 | 494 |
2281047 | 2281047 | 2022-03-06 | Medina | Texas | 48325 | 9992 | 194 |
2277120 | 2277120 | 2022-03-05 | Medina | Ohio | 39103 | 39836 | 494 |
2277794 | 2277794 | 2022-03-05 | Medina | Texas | 48325 | 9991 | 194 |
2273867 | 2273867 | 2022-03-04 | Medina | Ohio | 39103 | 39823 | 494 |
2274541 | 2274541 | 2022-03-04 | Medina | Texas | 48325 | 9976 | 193 |
2270614 | 2270614 | 2022-03-03 | Medina | Ohio | 39103 | 39812 | 490 |
2271288 | 2271288 | 2022-03-03 | Medina | Texas | 48325 | 9962 | 192 |
2267362 | 2267362 | 2022-03-02 | Medina | Ohio | 39103 | 39793 | 490 |
2268036 | 2268036 | 2022-03-02 | Medina | Texas | 48325 | 9948 | 192 |
2264109 | 2264109 | 2022-03-01 | Medina | Ohio | 39103 | 39780 | 490 |
2264783 | 2264783 | 2022-03-01 | Medina | Texas | 48325 | 9927 | 192 |
2260859 | 2260859 | 2022-02-28 | Medina | Ohio | 39103 | 39769 | 482 |
2261533 | 2261533 | 2022-02-28 | Medina | Texas | 48325 | 9909 | 191 |
2257608 | 2257608 | 2022-02-27 | Medina | Ohio | 39103 | 39755 | 482 |
2258282 | 2258282 | 2022-02-27 | Medina | Texas | 48325 | 9905 | 191 |
2254357 | 2254357 | 2022-02-26 | Medina | Ohio | 39103 | 39744 | 482 |
2255031 | 2255031 | 2022-02-26 | Medina | Texas | 48325 | 9904 | 191 |
2251106 | 2251106 | 2022-02-25 | Medina | Ohio | 39103 | 39727 | 482 |
2251780 | 2251780 | 2022-02-25 | Medina | Texas | 48325 | 9876 | 191 |
2247855 | 2247855 | 2022-02-24 | Medina | Ohio | 39103 | 39718 | 479 |
2248529 | 2248529 | 2022-02-24 | Medina | Texas | 48325 | 9855 | 190 |
2244604 | 2244604 | 2022-02-23 | Medina | Ohio | 39103 | 39699 | 479 |
2245278 | 2245278 | 2022-02-23 | Medina | Texas | 48325 | 9789 | 190 |
2241353 | 2241353 | 2022-02-22 | Medina | Ohio | 39103 | 39694 | 479 |
2242027 | 2242027 | 2022-02-22 | Medina | Texas | 48325 | 9751 | 190 |
2238102 | 2238102 | 2022-02-21 | Medina | Ohio | 39103 | 39683 | 477 |
2238776 | 2238776 | 2022-02-21 | Medina | Texas | 48325 | 9750 | 190 |
2234851 | 2234851 | 2022-02-20 | Medina | Ohio | 39103 | 39673 | 477 |
2235525 | 2235525 | 2022-02-20 | Medina | Texas | 48325 | 9745 | 190 |
2231600 | 2231600 | 2022-02-19 | Medina | Ohio | 39103 | 39664 | 477 |
2232274 | 2232274 | 2022-02-19 | Medina | Texas | 48325 | 9743 | 190 |
2228349 | 2228349 | 2022-02-18 | Medina | Ohio | 39103 | 39650 | 477 |
2229023 | 2229023 | 2022-02-18 | Medina | Texas | 48325 | 9727 | 190 |
2225098 | 2225098 | 2022-02-17 | Medina | Ohio | 39103 | 39628 | 474 |
2225772 | 2225772 | 2022-02-17 | Medina | Texas | 48325 | 9702 | 189 |
2221847 | 2221847 | 2022-02-16 | Medina | Ohio | 39103 | 39619 | 474 |
2222521 | 2222521 | 2022-02-16 | Medina | Texas | 48325 | 9661 | 189 |
2218596 | 2218596 | 2022-02-15 | Medina | Ohio | 39103 | 39598 | 474 |
2219270 | 2219270 | 2022-02-15 | Medina | Texas | 48325 | 9637 | 189 |
2215345 | 2215345 | 2022-02-14 | Medina | Ohio | 39103 | 39577 | 467 |
2216019 | 2216019 | 2022-02-14 | Medina | Texas | 48325 | 9616 | 189 |
2212094 | 2212094 | 2022-02-13 | Medina | Ohio | 39103 | 39571 | 467 |
2212768 | 2212768 | 2022-02-13 | Medina | Texas | 48325 | 9608 | 189 |
2208841 | 2208841 | 2022-02-12 | Medina | Ohio | 39103 | 39554 | 467 |
2209515 | 2209515 | 2022-02-12 | Medina | Texas | 48325 | 9603 | 189 |
2205588 | 2205588 | 2022-02-11 | Medina | Ohio | 39103 | 39546 | 467 |
2206262 | 2206262 | 2022-02-11 | Medina | Texas | 48325 | 9587 | 187 |
2202335 | 2202335 | 2022-02-10 | Medina | Ohio | 39103 | 39508 | 464 |
2203009 | 2203009 | 2022-02-10 | Medina | Texas | 48325 | 9554 | 186 |
2199081 | 2199081 | 2022-02-09 | Medina | Ohio | 39103 | 39493 | 464 |
2199755 | 2199755 | 2022-02-09 | Medina | Texas | 48325 | 9541 | 186 |
2195827 | 2195827 | 2022-02-08 | Medina | Ohio | 39103 | 39469 | 464 |
2196501 | 2196501 | 2022-02-08 | Medina | Texas | 48325 | 9526 | 185 |
2192573 | 2192573 | 2022-02-07 | Medina | Ohio | 39103 | 39451 | 460 |
2193247 | 2193247 | 2022-02-07 | Medina | Texas | 48325 | 9496 | 182 |
2189319 | 2189319 | 2022-02-06 | Medina | Ohio | 39103 | 39418 | 460 |
2189993 | 2189993 | 2022-02-06 | Medina | Texas | 48325 | 9471 | 182 |
2186066 | 2186066 | 2022-02-05 | Medina | Ohio | 39103 | 39402 | 460 |
2186740 | 2186740 | 2022-02-05 | Medina | Texas | 48325 | 9448 | 182 |
2182814 | 2182814 | 2022-02-04 | Medina | Ohio | 39103 | 39376 | 460 |
2183488 | 2183488 | 2022-02-04 | Medina | Texas | 48325 | 9419 | 180 |
2179562 | 2179562 | 2022-02-03 | Medina | Ohio | 39103 | 39339 | 443 |
2180236 | 2180236 | 2022-02-03 | Medina | Texas | 48325 | 9395 | 180 |
Advanced export
JSON shape: default, array, newline-delimited
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);