ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Jefferson" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500217 | 2500217 | 2022-05-13 | Jefferson | Illinois | 17081 | 11159 | 176 |
2496959 | 2496959 | 2022-05-12 | Jefferson | Illinois | 17081 | 11155 | 176 |
2493701 | 2493701 | 2022-05-11 | Jefferson | Illinois | 17081 | 11153 | 176 |
2490443 | 2490443 | 2022-05-10 | Jefferson | Illinois | 17081 | 11148 | 176 |
2487186 | 2487186 | 2022-05-09 | Jefferson | Illinois | 17081 | 11146 | 176 |
2483928 | 2483928 | 2022-05-08 | Jefferson | Illinois | 17081 | 11143 | 176 |
2480670 | 2480670 | 2022-05-07 | Jefferson | Illinois | 17081 | 11143 | 176 |
2477412 | 2477412 | 2022-05-06 | Jefferson | Illinois | 17081 | 11143 | 176 |
2474154 | 2474154 | 2022-05-05 | Jefferson | Illinois | 17081 | 11134 | 176 |
2470897 | 2470897 | 2022-05-04 | Jefferson | Illinois | 17081 | 11134 | 176 |
2467641 | 2467641 | 2022-05-03 | Jefferson | Illinois | 17081 | 11134 | 176 |
2464386 | 2464386 | 2022-05-02 | Jefferson | Illinois | 17081 | 11128 | 176 |
2461130 | 2461130 | 2022-05-01 | Jefferson | Illinois | 17081 | 11124 | 176 |
2457874 | 2457874 | 2022-04-30 | Jefferson | Illinois | 17081 | 11124 | 176 |
2454618 | 2454618 | 2022-04-29 | Jefferson | Illinois | 17081 | 11124 | 176 |
2451362 | 2451362 | 2022-04-28 | Jefferson | Illinois | 17081 | 11119 | 176 |
2448106 | 2448106 | 2022-04-27 | Jefferson | Illinois | 17081 | 11117 | 176 |
2444850 | 2444850 | 2022-04-26 | Jefferson | Illinois | 17081 | 11117 | 176 |
2441594 | 2441594 | 2022-04-25 | Jefferson | Illinois | 17081 | 11112 | 176 |
2438338 | 2438338 | 2022-04-24 | Jefferson | Illinois | 17081 | 11109 | 176 |
2435082 | 2435082 | 2022-04-23 | Jefferson | Illinois | 17081 | 11109 | 176 |
2431826 | 2431826 | 2022-04-22 | Jefferson | Illinois | 17081 | 11109 | 176 |
2428570 | 2428570 | 2022-04-21 | Jefferson | Illinois | 17081 | 11105 | 176 |
2425314 | 2425314 | 2022-04-20 | Jefferson | Illinois | 17081 | 11104 | 176 |
2422058 | 2422058 | 2022-04-19 | Jefferson | Illinois | 17081 | 11106 | 176 |
2418802 | 2418802 | 2022-04-18 | Jefferson | Illinois | 17081 | 11102 | 176 |
2415546 | 2415546 | 2022-04-17 | Jefferson | Illinois | 17081 | 11100 | 176 |
2412290 | 2412290 | 2022-04-16 | Jefferson | Illinois | 17081 | 11100 | 176 |
2409034 | 2409034 | 2022-04-15 | Jefferson | Illinois | 17081 | 11100 | 176 |
2405778 | 2405778 | 2022-04-14 | Jefferson | Illinois | 17081 | 11101 | 176 |
2402523 | 2402523 | 2022-04-13 | Jefferson | Illinois | 17081 | 11100 | 176 |
2399268 | 2399268 | 2022-04-12 | Jefferson | Illinois | 17081 | 11097 | 176 |
2396013 | 2396013 | 2022-04-11 | Jefferson | Illinois | 17081 | 11097 | 176 |
2392757 | 2392757 | 2022-04-10 | Jefferson | Illinois | 17081 | 11097 | 176 |
2389501 | 2389501 | 2022-04-09 | Jefferson | Illinois | 17081 | 11097 | 176 |
2386246 | 2386246 | 2022-04-08 | Jefferson | Illinois | 17081 | 11097 | 176 |
2382991 | 2382991 | 2022-04-07 | Jefferson | Illinois | 17081 | 11095 | 176 |
2379736 | 2379736 | 2022-04-06 | Jefferson | Illinois | 17081 | 11093 | 176 |
2376482 | 2376482 | 2022-04-05 | Jefferson | Illinois | 17081 | 11091 | 176 |
2373230 | 2373230 | 2022-04-04 | Jefferson | Illinois | 17081 | 11092 | 176 |
2369977 | 2369977 | 2022-04-03 | Jefferson | Illinois | 17081 | 11092 | 176 |
2366724 | 2366724 | 2022-04-02 | Jefferson | Illinois | 17081 | 11092 | 176 |
2363471 | 2363471 | 2022-04-01 | Jefferson | Illinois | 17081 | 11092 | 176 |
2360217 | 2360217 | 2022-03-31 | Jefferson | Illinois | 17081 | 11092 | 176 |
2356963 | 2356963 | 2022-03-30 | Jefferson | Illinois | 17081 | 11088 | 175 |
2353710 | 2353710 | 2022-03-29 | Jefferson | Illinois | 17081 | 11083 | 175 |
2350458 | 2350458 | 2022-03-28 | Jefferson | Illinois | 17081 | 11057 | 175 |
2347205 | 2347205 | 2022-03-27 | Jefferson | Illinois | 17081 | 11036 | 175 |
2343952 | 2343952 | 2022-03-26 | Jefferson | Illinois | 17081 | 11036 | 175 |
2340699 | 2340699 | 2022-03-25 | Jefferson | Illinois | 17081 | 11036 | 175 |
2337446 | 2337446 | 2022-03-24 | Jefferson | Illinois | 17081 | 11032 | 174 |
2334192 | 2334192 | 2022-03-23 | Jefferson | Illinois | 17081 | 11027 | 174 |
2330938 | 2330938 | 2022-03-22 | Jefferson | Illinois | 17081 | 11027 | 173 |
2327686 | 2327686 | 2022-03-21 | Jefferson | Illinois | 17081 | 11026 | 173 |
2324433 | 2324433 | 2022-03-20 | Jefferson | Illinois | 17081 | 11022 | 173 |
2321179 | 2321179 | 2022-03-19 | Jefferson | Illinois | 17081 | 11022 | 173 |
2317925 | 2317925 | 2022-03-18 | Jefferson | Illinois | 17081 | 11022 | 173 |
2314672 | 2314672 | 2022-03-17 | Jefferson | Illinois | 17081 | 11021 | 173 |
2311419 | 2311419 | 2022-03-16 | Jefferson | Illinois | 17081 | 11020 | 173 |
2308166 | 2308166 | 2022-03-15 | Jefferson | Illinois | 17081 | 11019 | 173 |
2304915 | 2304915 | 2022-03-14 | Jefferson | Illinois | 17081 | 11018 | 173 |
2301663 | 2301663 | 2022-03-13 | Jefferson | Illinois | 17081 | 11014 | 174 |
2298411 | 2298411 | 2022-03-12 | Jefferson | Illinois | 17081 | 11014 | 174 |
2295159 | 2295159 | 2022-03-11 | Jefferson | Illinois | 17081 | 11014 | 174 |
2291907 | 2291907 | 2022-03-10 | Jefferson | Illinois | 17081 | 11011 | 174 |
2288655 | 2288655 | 2022-03-09 | Jefferson | Illinois | 17081 | 11007 | 173 |
2285404 | 2285404 | 2022-03-08 | Jefferson | Illinois | 17081 | 11001 | 172 |
2282152 | 2282152 | 2022-03-07 | Jefferson | Illinois | 17081 | 10997 | 172 |
2278899 | 2278899 | 2022-03-06 | Jefferson | Illinois | 17081 | 10986 | 171 |
2275646 | 2275646 | 2022-03-05 | Jefferson | Illinois | 17081 | 10986 | 171 |
2272393 | 2272393 | 2022-03-04 | Jefferson | Illinois | 17081 | 10986 | 171 |
2269141 | 2269141 | 2022-03-03 | Jefferson | Illinois | 17081 | 10985 | 171 |
2265888 | 2265888 | 2022-03-02 | Jefferson | Illinois | 17081 | 10983 | 171 |
2262637 | 2262637 | 2022-03-01 | Jefferson | Illinois | 17081 | 10975 | 171 |
2259386 | 2259386 | 2022-02-28 | Jefferson | Illinois | 17081 | 10973 | 171 |
2256135 | 2256135 | 2022-02-27 | Jefferson | Illinois | 17081 | 10955 | 170 |
2252884 | 2252884 | 2022-02-26 | Jefferson | Illinois | 17081 | 10955 | 170 |
2249633 | 2249633 | 2022-02-25 | Jefferson | Illinois | 17081 | 10955 | 170 |
2246382 | 2246382 | 2022-02-24 | Jefferson | Illinois | 17081 | 10947 | 169 |
2243131 | 2243131 | 2022-02-23 | Jefferson | Illinois | 17081 | 10936 | 169 |
2239880 | 2239880 | 2022-02-22 | Jefferson | Illinois | 17081 | 10926 | 169 |
2236629 | 2236629 | 2022-02-21 | Jefferson | Illinois | 17081 | 10891 | 168 |
2233378 | 2233378 | 2022-02-20 | Jefferson | Illinois | 17081 | 10891 | 168 |
2230127 | 2230127 | 2022-02-19 | Jefferson | Illinois | 17081 | 10891 | 168 |
2226876 | 2226876 | 2022-02-18 | Jefferson | Illinois | 17081 | 10891 | 168 |
2223625 | 2223625 | 2022-02-17 | Jefferson | Illinois | 17081 | 10876 | 168 |
2220374 | 2220374 | 2022-02-16 | Jefferson | Illinois | 17081 | 10861 | 168 |
2217123 | 2217123 | 2022-02-15 | Jefferson | Illinois | 17081 | 10830 | 166 |
2213872 | 2213872 | 2022-02-14 | Jefferson | Illinois | 17081 | 10819 | 166 |
2210620 | 2210620 | 2022-02-13 | Jefferson | Illinois | 17081 | 10724 | 164 |
2207367 | 2207367 | 2022-02-12 | Jefferson | Illinois | 17081 | 10724 | 164 |
2204114 | 2204114 | 2022-02-11 | Jefferson | Illinois | 17081 | 10724 | 164 |
2200861 | 2200861 | 2022-02-10 | Jefferson | Illinois | 17081 | 10724 | 164 |
2197607 | 2197607 | 2022-02-09 | Jefferson | Illinois | 17081 | 10703 | 164 |
2194353 | 2194353 | 2022-02-08 | Jefferson | Illinois | 17081 | 10640 | 163 |
2191099 | 2191099 | 2022-02-07 | Jefferson | Illinois | 17081 | 10599 | 163 |
2187846 | 2187846 | 2022-02-06 | Jefferson | Illinois | 17081 | 10560 | 163 |
2184593 | 2184593 | 2022-02-05 | Jefferson | Illinois | 17081 | 10560 | 163 |
2181341 | 2181341 | 2022-02-04 | Jefferson | Illinois | 17081 | 10560 | 163 |
2178090 | 2178090 | 2022-02-03 | Jefferson | Illinois | 17081 | 10466 | 162 |
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);