ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,552 rows where county = "Vermilion" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337498 | 2337498 | 2022-03-24 | Vermilion | Illinois | 17183 | 27833 | 310 |
2337983 | 2337983 | 2022-03-24 | Vermilion | Louisiana | 22113 | 15235 | 223 |
2334244 | 2334244 | 2022-03-23 | Vermilion | Illinois | 17183 | 27836 | 310 |
2334729 | 2334729 | 2022-03-23 | Vermilion | Louisiana | 22113 | 15234 | 223 |
2330990 | 2330990 | 2022-03-22 | Vermilion | Illinois | 17183 | 27835 | 310 |
2331475 | 2331475 | 2022-03-22 | Vermilion | Louisiana | 22113 | 15234 | 223 |
2327738 | 2327738 | 2022-03-21 | Vermilion | Illinois | 17183 | 27836 | 309 |
2328223 | 2328223 | 2022-03-21 | Vermilion | Louisiana | 22113 | 15233 | 222 |
2324485 | 2324485 | 2022-03-20 | Vermilion | Illinois | 17183 | 27827 | 309 |
2324970 | 2324970 | 2022-03-20 | Vermilion | Louisiana | 22113 | 15231 | 222 |
2321231 | 2321231 | 2022-03-19 | Vermilion | Illinois | 17183 | 27827 | 309 |
2321716 | 2321716 | 2022-03-19 | Vermilion | Louisiana | 22113 | 15231 | 222 |
2317977 | 2317977 | 2022-03-18 | Vermilion | Illinois | 17183 | 27827 | 309 |
2318462 | 2318462 | 2022-03-18 | Vermilion | Louisiana | 22113 | 15231 | 222 |
2314724 | 2314724 | 2022-03-17 | Vermilion | Illinois | 17183 | 27823 | 309 |
2315209 | 2315209 | 2022-03-17 | Vermilion | Louisiana | 22113 | 15230 | 222 |
2311471 | 2311471 | 2022-03-16 | Vermilion | Illinois | 17183 | 27825 | 309 |
2311956 | 2311956 | 2022-03-16 | Vermilion | Louisiana | 22113 | 15228 | 222 |
2308218 | 2308218 | 2022-03-15 | Vermilion | Illinois | 17183 | 27829 | 308 |
2308703 | 2308703 | 2022-03-15 | Vermilion | Louisiana | 22113 | 15226 | 222 |
2304967 | 2304967 | 2022-03-14 | Vermilion | Illinois | 17183 | 27833 | 308 |
2305452 | 2305452 | 2022-03-14 | Vermilion | Louisiana | 22113 | 15225 | 222 |
2301715 | 2301715 | 2022-03-13 | Vermilion | Illinois | 17183 | 27832 | 306 |
2302200 | 2302200 | 2022-03-13 | Vermilion | Louisiana | 22113 | 15224 | 222 |
2298463 | 2298463 | 2022-03-12 | Vermilion | Illinois | 17183 | 27832 | 306 |
2298948 | 2298948 | 2022-03-12 | Vermilion | Louisiana | 22113 | 15224 | 222 |
2295211 | 2295211 | 2022-03-11 | Vermilion | Illinois | 17183 | 27832 | 306 |
2295696 | 2295696 | 2022-03-11 | Vermilion | Louisiana | 22113 | 15224 | 222 |
2291959 | 2291959 | 2022-03-10 | Vermilion | Illinois | 17183 | 27831 | 305 |
2292444 | 2292444 | 2022-03-10 | Vermilion | Louisiana | 22113 | 15221 | 222 |
2288707 | 2288707 | 2022-03-09 | Vermilion | Illinois | 17183 | 27832 | 305 |
2289192 | 2289192 | 2022-03-09 | Vermilion | Louisiana | 22113 | 15219 | 222 |
2285456 | 2285456 | 2022-03-08 | Vermilion | Illinois | 17183 | 27830 | 304 |
2285941 | 2285941 | 2022-03-08 | Vermilion | Louisiana | 22113 | 15214 | 222 |
2282204 | 2282204 | 2022-03-07 | Vermilion | Illinois | 17183 | 27827 | 304 |
2282689 | 2282689 | 2022-03-07 | Vermilion | Louisiana | 22113 | 15212 | 221 |
2278951 | 2278951 | 2022-03-06 | Vermilion | Illinois | 17183 | 27824 | 304 |
2279436 | 2279436 | 2022-03-06 | Vermilion | Louisiana | 22113 | 15207 | 219 |
2275698 | 2275698 | 2022-03-05 | Vermilion | Illinois | 17183 | 27824 | 304 |
2276183 | 2276183 | 2022-03-05 | Vermilion | Louisiana | 22113 | 15207 | 219 |
2272445 | 2272445 | 2022-03-04 | Vermilion | Illinois | 17183 | 27824 | 304 |
2272930 | 2272930 | 2022-03-04 | Vermilion | Louisiana | 22113 | 15207 | 219 |
2269193 | 2269193 | 2022-03-03 | Vermilion | Illinois | 17183 | 27810 | 304 |
2269678 | 2269678 | 2022-03-03 | Vermilion | Louisiana | 22113 | 15200 | 218 |
2265940 | 2265940 | 2022-03-02 | Vermilion | Illinois | 17183 | 27811 | 304 |
2266425 | 2266425 | 2022-03-02 | Vermilion | Louisiana | 22113 | 15197 | 217 |
2262689 | 2262689 | 2022-03-01 | Vermilion | Illinois | 17183 | 27809 | 304 |
2263174 | 2263174 | 2022-03-01 | Vermilion | Louisiana | 22113 | 15169 | 216 |
2259438 | 2259438 | 2022-02-28 | Vermilion | Illinois | 17183 | 27795 | 304 |
2259923 | 2259923 | 2022-02-28 | Vermilion | Louisiana | 22113 | 15169 | 216 |
2256187 | 2256187 | 2022-02-27 | Vermilion | Illinois | 17183 | 27777 | 304 |
2256672 | 2256672 | 2022-02-27 | Vermilion | Louisiana | 22113 | 15169 | 216 |
2252936 | 2252936 | 2022-02-26 | Vermilion | Illinois | 17183 | 27777 | 304 |
2253421 | 2253421 | 2022-02-26 | Vermilion | Louisiana | 22113 | 15169 | 216 |
2249685 | 2249685 | 2022-02-25 | Vermilion | Illinois | 17183 | 27777 | 304 |
2250170 | 2250170 | 2022-02-25 | Vermilion | Louisiana | 22113 | 15169 | 216 |
2246434 | 2246434 | 2022-02-24 | Vermilion | Illinois | 17183 | 27771 | 304 |
2246919 | 2246919 | 2022-02-24 | Vermilion | Louisiana | 22113 | 15158 | 215 |
2243183 | 2243183 | 2022-02-23 | Vermilion | Illinois | 17183 | 27764 | 303 |
2243668 | 2243668 | 2022-02-23 | Vermilion | Louisiana | 22113 | 15150 | 215 |
2239932 | 2239932 | 2022-02-22 | Vermilion | Illinois | 17183 | 27740 | 302 |
2240417 | 2240417 | 2022-02-22 | Vermilion | Louisiana | 22113 | 15131 | 214 |
2236681 | 2236681 | 2022-02-21 | Vermilion | Illinois | 17183 | 27707 | 301 |
2237166 | 2237166 | 2022-02-21 | Vermilion | Louisiana | 22113 | 15120 | 214 |
2233430 | 2233430 | 2022-02-20 | Vermilion | Illinois | 17183 | 27707 | 301 |
2233915 | 2233915 | 2022-02-20 | Vermilion | Louisiana | 22113 | 15085 | 214 |
2230179 | 2230179 | 2022-02-19 | Vermilion | Illinois | 17183 | 27707 | 301 |
2230664 | 2230664 | 2022-02-19 | Vermilion | Louisiana | 22113 | 15085 | 214 |
2226928 | 2226928 | 2022-02-18 | Vermilion | Illinois | 17183 | 27707 | 301 |
2227413 | 2227413 | 2022-02-18 | Vermilion | Louisiana | 22113 | 15085 | 214 |
2223677 | 2223677 | 2022-02-17 | Vermilion | Illinois | 17183 | 27695 | 299 |
2224162 | 2224162 | 2022-02-17 | Vermilion | Louisiana | 22113 | 15072 | 213 |
2220426 | 2220426 | 2022-02-16 | Vermilion | Illinois | 17183 | 27683 | 298 |
2220911 | 2220911 | 2022-02-16 | Vermilion | Louisiana | 22113 | 15051 | 212 |
2217175 | 2217175 | 2022-02-15 | Vermilion | Illinois | 17183 | 27649 | 296 |
2217660 | 2217660 | 2022-02-15 | Vermilion | Louisiana | 22113 | 15027 | 212 |
2213924 | 2213924 | 2022-02-14 | Vermilion | Illinois | 17183 | 27632 | 294 |
2214409 | 2214409 | 2022-02-14 | Vermilion | Louisiana | 22113 | 14997 | 212 |
2210672 | 2210672 | 2022-02-13 | Vermilion | Illinois | 17183 | 27495 | 290 |
2211157 | 2211157 | 2022-02-13 | Vermilion | Louisiana | 22113 | 14953 | 210 |
2207419 | 2207419 | 2022-02-12 | Vermilion | Illinois | 17183 | 27495 | 290 |
2207904 | 2207904 | 2022-02-12 | Vermilion | Louisiana | 22113 | 14953 | 210 |
2204166 | 2204166 | 2022-02-11 | Vermilion | Illinois | 17183 | 27495 | 290 |
2204651 | 2204651 | 2022-02-11 | Vermilion | Louisiana | 22113 | 14953 | 210 |
2200913 | 2200913 | 2022-02-10 | Vermilion | Illinois | 17183 | 27495 | 290 |
2201398 | 2201398 | 2022-02-10 | Vermilion | Louisiana | 22113 | 14905 | 210 |
2197659 | 2197659 | 2022-02-09 | Vermilion | Illinois | 17183 | 27453 | 288 |
2198144 | 2198144 | 2022-02-09 | Vermilion | Louisiana | 22113 | 14881 | 209 |
2194405 | 2194405 | 2022-02-08 | Vermilion | Illinois | 17183 | 27343 | 287 |
2194890 | 2194890 | 2022-02-08 | Vermilion | Louisiana | 22113 | 14834 | 209 |
2191151 | 2191151 | 2022-02-07 | Vermilion | Illinois | 17183 | 27270 | 287 |
2191636 | 2191636 | 2022-02-07 | Vermilion | Louisiana | 22113 | 14788 | 209 |
2187898 | 2187898 | 2022-02-06 | Vermilion | Illinois | 17183 | 27151 | 287 |
2188383 | 2188383 | 2022-02-06 | Vermilion | Louisiana | 22113 | 14669 | 205 |
2184645 | 2184645 | 2022-02-05 | Vermilion | Illinois | 17183 | 27151 | 287 |
2185130 | 2185130 | 2022-02-05 | Vermilion | Louisiana | 22113 | 14669 | 205 |
2181393 | 2181393 | 2022-02-04 | Vermilion | Illinois | 17183 | 27151 | 287 |
2181878 | 2181878 | 2022-02-04 | Vermilion | Louisiana | 22113 | 14669 | 205 |
2178142 | 2178142 | 2022-02-03 | Vermilion | Illinois | 17183 | 27049 | 284 |
2178627 | 2178627 | 2022-02-03 | Vermilion | Louisiana | 22113 | 14610 | 205 |
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);