ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Vermilion" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500269 | 2500269 | 2022-05-13 | Vermilion | Illinois | 17183 | 28275 | 313 |
2497011 | 2497011 | 2022-05-12 | Vermilion | Illinois | 17183 | 28253 | 313 |
2493753 | 2493753 | 2022-05-11 | Vermilion | Illinois | 17183 | 28231 | 313 |
2490495 | 2490495 | 2022-05-10 | Vermilion | Illinois | 17183 | 28209 | 313 |
2487238 | 2487238 | 2022-05-09 | Vermilion | Illinois | 17183 | 28194 | 313 |
2483980 | 2483980 | 2022-05-08 | Vermilion | Illinois | 17183 | 28159 | 313 |
2480722 | 2480722 | 2022-05-07 | Vermilion | Illinois | 17183 | 28159 | 313 |
2477464 | 2477464 | 2022-05-06 | Vermilion | Illinois | 17183 | 28159 | 313 |
2474206 | 2474206 | 2022-05-05 | Vermilion | Illinois | 17183 | 28143 | 313 |
2470949 | 2470949 | 2022-05-04 | Vermilion | Illinois | 17183 | 28128 | 313 |
2467693 | 2467693 | 2022-05-03 | Vermilion | Illinois | 17183 | 28113 | 313 |
2464438 | 2464438 | 2022-05-02 | Vermilion | Illinois | 17183 | 28098 | 313 |
2461182 | 2461182 | 2022-05-01 | Vermilion | Illinois | 17183 | 28066 | 313 |
2457926 | 2457926 | 2022-04-30 | Vermilion | Illinois | 17183 | 28066 | 313 |
2454670 | 2454670 | 2022-04-29 | Vermilion | Illinois | 17183 | 28066 | 313 |
2451414 | 2451414 | 2022-04-28 | Vermilion | Illinois | 17183 | 28053 | 313 |
2448158 | 2448158 | 2022-04-27 | Vermilion | Illinois | 17183 | 28040 | 313 |
2444902 | 2444902 | 2022-04-26 | Vermilion | Illinois | 17183 | 28027 | 313 |
2441646 | 2441646 | 2022-04-25 | Vermilion | Illinois | 17183 | 28018 | 313 |
2438390 | 2438390 | 2022-04-24 | Vermilion | Illinois | 17183 | 28003 | 313 |
2435134 | 2435134 | 2022-04-23 | Vermilion | Illinois | 17183 | 28003 | 313 |
2431878 | 2431878 | 2022-04-22 | Vermilion | Illinois | 17183 | 28003 | 313 |
2428622 | 2428622 | 2022-04-21 | Vermilion | Illinois | 17183 | 27986 | 313 |
2425366 | 2425366 | 2022-04-20 | Vermilion | Illinois | 17183 | 27976 | 313 |
2422110 | 2422110 | 2022-04-19 | Vermilion | Illinois | 17183 | 27960 | 312 |
2418854 | 2418854 | 2022-04-18 | Vermilion | Illinois | 17183 | 27955 | 312 |
2415598 | 2415598 | 2022-04-17 | Vermilion | Illinois | 17183 | 27944 | 312 |
2412342 | 2412342 | 2022-04-16 | Vermilion | Illinois | 17183 | 27944 | 312 |
2409086 | 2409086 | 2022-04-15 | Vermilion | Illinois | 17183 | 27944 | 312 |
2405830 | 2405830 | 2022-04-14 | Vermilion | Illinois | 17183 | 27930 | 312 |
2402575 | 2402575 | 2022-04-13 | Vermilion | Illinois | 17183 | 27923 | 312 |
2399320 | 2399320 | 2022-04-12 | Vermilion | Illinois | 17183 | 27915 | 312 |
2396065 | 2396065 | 2022-04-11 | Vermilion | Illinois | 17183 | 27908 | 312 |
2392809 | 2392809 | 2022-04-10 | Vermilion | Illinois | 17183 | 27891 | 311 |
2389553 | 2389553 | 2022-04-09 | Vermilion | Illinois | 17183 | 27891 | 311 |
2386298 | 2386298 | 2022-04-08 | Vermilion | Illinois | 17183 | 27891 | 311 |
2383043 | 2383043 | 2022-04-07 | Vermilion | Illinois | 17183 | 27885 | 311 |
2379788 | 2379788 | 2022-04-06 | Vermilion | Illinois | 17183 | 27882 | 311 |
2376534 | 2376534 | 2022-04-05 | Vermilion | Illinois | 17183 | 27873 | 311 |
2373282 | 2373282 | 2022-04-04 | Vermilion | Illinois | 17183 | 27870 | 311 |
2370029 | 2370029 | 2022-04-03 | Vermilion | Illinois | 17183 | 27861 | 311 |
2366776 | 2366776 | 2022-04-02 | Vermilion | Illinois | 17183 | 27861 | 311 |
2363523 | 2363523 | 2022-04-01 | Vermilion | Illinois | 17183 | 27861 | 311 |
2360269 | 2360269 | 2022-03-31 | Vermilion | Illinois | 17183 | 27856 | 311 |
2357015 | 2357015 | 2022-03-30 | Vermilion | Illinois | 17183 | 27849 | 311 |
2353762 | 2353762 | 2022-03-29 | Vermilion | Illinois | 17183 | 27848 | 311 |
2350510 | 2350510 | 2022-03-28 | Vermilion | Illinois | 17183 | 27840 | 311 |
2347257 | 2347257 | 2022-03-27 | Vermilion | Illinois | 17183 | 27841 | 311 |
2344004 | 2344004 | 2022-03-26 | Vermilion | Illinois | 17183 | 27841 | 311 |
2340751 | 2340751 | 2022-03-25 | Vermilion | Illinois | 17183 | 27841 | 311 |
2337498 | 2337498 | 2022-03-24 | Vermilion | Illinois | 17183 | 27833 | 310 |
2334244 | 2334244 | 2022-03-23 | Vermilion | Illinois | 17183 | 27836 | 310 |
2330990 | 2330990 | 2022-03-22 | Vermilion | Illinois | 17183 | 27835 | 310 |
2327738 | 2327738 | 2022-03-21 | Vermilion | Illinois | 17183 | 27836 | 309 |
2324485 | 2324485 | 2022-03-20 | Vermilion | Illinois | 17183 | 27827 | 309 |
2321231 | 2321231 | 2022-03-19 | Vermilion | Illinois | 17183 | 27827 | 309 |
2317977 | 2317977 | 2022-03-18 | Vermilion | Illinois | 17183 | 27827 | 309 |
2314724 | 2314724 | 2022-03-17 | Vermilion | Illinois | 17183 | 27823 | 309 |
2311471 | 2311471 | 2022-03-16 | Vermilion | Illinois | 17183 | 27825 | 309 |
2308218 | 2308218 | 2022-03-15 | Vermilion | Illinois | 17183 | 27829 | 308 |
2304967 | 2304967 | 2022-03-14 | Vermilion | Illinois | 17183 | 27833 | 308 |
2301715 | 2301715 | 2022-03-13 | Vermilion | Illinois | 17183 | 27832 | 306 |
2298463 | 2298463 | 2022-03-12 | Vermilion | Illinois | 17183 | 27832 | 306 |
2295211 | 2295211 | 2022-03-11 | Vermilion | Illinois | 17183 | 27832 | 306 |
2291959 | 2291959 | 2022-03-10 | Vermilion | Illinois | 17183 | 27831 | 305 |
2288707 | 2288707 | 2022-03-09 | Vermilion | Illinois | 17183 | 27832 | 305 |
2285456 | 2285456 | 2022-03-08 | Vermilion | Illinois | 17183 | 27830 | 304 |
2282204 | 2282204 | 2022-03-07 | Vermilion | Illinois | 17183 | 27827 | 304 |
2278951 | 2278951 | 2022-03-06 | Vermilion | Illinois | 17183 | 27824 | 304 |
2275698 | 2275698 | 2022-03-05 | Vermilion | Illinois | 17183 | 27824 | 304 |
2272445 | 2272445 | 2022-03-04 | Vermilion | Illinois | 17183 | 27824 | 304 |
2269193 | 2269193 | 2022-03-03 | Vermilion | Illinois | 17183 | 27810 | 304 |
2265940 | 2265940 | 2022-03-02 | Vermilion | Illinois | 17183 | 27811 | 304 |
2262689 | 2262689 | 2022-03-01 | Vermilion | Illinois | 17183 | 27809 | 304 |
2259438 | 2259438 | 2022-02-28 | Vermilion | Illinois | 17183 | 27795 | 304 |
2256187 | 2256187 | 2022-02-27 | Vermilion | Illinois | 17183 | 27777 | 304 |
2252936 | 2252936 | 2022-02-26 | Vermilion | Illinois | 17183 | 27777 | 304 |
2249685 | 2249685 | 2022-02-25 | Vermilion | Illinois | 17183 | 27777 | 304 |
2246434 | 2246434 | 2022-02-24 | Vermilion | Illinois | 17183 | 27771 | 304 |
2243183 | 2243183 | 2022-02-23 | Vermilion | Illinois | 17183 | 27764 | 303 |
2239932 | 2239932 | 2022-02-22 | Vermilion | Illinois | 17183 | 27740 | 302 |
2236681 | 2236681 | 2022-02-21 | Vermilion | Illinois | 17183 | 27707 | 301 |
2233430 | 2233430 | 2022-02-20 | Vermilion | Illinois | 17183 | 27707 | 301 |
2230179 | 2230179 | 2022-02-19 | Vermilion | Illinois | 17183 | 27707 | 301 |
2226928 | 2226928 | 2022-02-18 | Vermilion | Illinois | 17183 | 27707 | 301 |
2223677 | 2223677 | 2022-02-17 | Vermilion | Illinois | 17183 | 27695 | 299 |
2220426 | 2220426 | 2022-02-16 | Vermilion | Illinois | 17183 | 27683 | 298 |
2217175 | 2217175 | 2022-02-15 | Vermilion | Illinois | 17183 | 27649 | 296 |
2213924 | 2213924 | 2022-02-14 | Vermilion | Illinois | 17183 | 27632 | 294 |
2210672 | 2210672 | 2022-02-13 | Vermilion | Illinois | 17183 | 27495 | 290 |
2207419 | 2207419 | 2022-02-12 | Vermilion | Illinois | 17183 | 27495 | 290 |
2204166 | 2204166 | 2022-02-11 | Vermilion | Illinois | 17183 | 27495 | 290 |
2200913 | 2200913 | 2022-02-10 | Vermilion | Illinois | 17183 | 27495 | 290 |
2197659 | 2197659 | 2022-02-09 | Vermilion | Illinois | 17183 | 27453 | 288 |
2194405 | 2194405 | 2022-02-08 | Vermilion | Illinois | 17183 | 27343 | 287 |
2191151 | 2191151 | 2022-02-07 | Vermilion | Illinois | 17183 | 27270 | 287 |
2187898 | 2187898 | 2022-02-06 | Vermilion | Illinois | 17183 | 27151 | 287 |
2184645 | 2184645 | 2022-02-05 | Vermilion | Illinois | 17183 | 27151 | 287 |
2181393 | 2181393 | 2022-02-04 | Vermilion | Illinois | 17183 | 27151 | 287 |
2178142 | 2178142 | 2022-02-03 | Vermilion | Illinois | 17183 | 27049 | 284 |
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);