ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,574 rows where county = "McHenry" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337468 | 2337468 | 2022-03-24 | McHenry | Illinois | 17111 | 75584 | 503 |
2338836 | 2338836 | 2022-03-24 | McHenry | North Dakota | 38049 | 1301 | 31 |
2334214 | 2334214 | 2022-03-23 | McHenry | Illinois | 17111 | 75543 | 502 |
2335582 | 2335582 | 2022-03-23 | McHenry | North Dakota | 38049 | 1301 | 31 |
2330960 | 2330960 | 2022-03-22 | McHenry | Illinois | 17111 | 75515 | 502 |
2332328 | 2332328 | 2022-03-22 | McHenry | North Dakota | 38049 | 1301 | 31 |
2327708 | 2327708 | 2022-03-21 | McHenry | Illinois | 17111 | 75467 | 501 |
2329075 | 2329075 | 2022-03-21 | McHenry | North Dakota | 38049 | 1301 | 31 |
2324455 | 2324455 | 2022-03-20 | McHenry | Illinois | 17111 | 75422 | 501 |
2325823 | 2325823 | 2022-03-20 | McHenry | North Dakota | 38049 | 1301 | 31 |
2321201 | 2321201 | 2022-03-19 | McHenry | Illinois | 17111 | 75422 | 501 |
2322570 | 2322570 | 2022-03-19 | McHenry | North Dakota | 38049 | 1301 | 31 |
2317947 | 2317947 | 2022-03-18 | McHenry | Illinois | 17111 | 75422 | 501 |
2319316 | 2319316 | 2022-03-18 | McHenry | North Dakota | 38049 | 1301 | 31 |
2314694 | 2314694 | 2022-03-17 | McHenry | Illinois | 17111 | 75374 | 501 |
2316062 | 2316062 | 2022-03-17 | McHenry | North Dakota | 38049 | 1300 | 31 |
2311441 | 2311441 | 2022-03-16 | McHenry | Illinois | 17111 | 75339 | 501 |
2312809 | 2312809 | 2022-03-16 | McHenry | North Dakota | 38049 | 1301 | 31 |
2308188 | 2308188 | 2022-03-15 | McHenry | Illinois | 17111 | 75306 | 501 |
2309556 | 2309556 | 2022-03-15 | McHenry | North Dakota | 38049 | 1300 | 31 |
2304937 | 2304937 | 2022-03-14 | McHenry | Illinois | 17111 | 75280 | 500 |
2306303 | 2306303 | 2022-03-14 | McHenry | North Dakota | 38049 | 1300 | 31 |
2301685 | 2301685 | 2022-03-13 | McHenry | Illinois | 17111 | 75224 | 498 |
2303052 | 2303052 | 2022-03-13 | McHenry | North Dakota | 38049 | 1300 | 31 |
2298433 | 2298433 | 2022-03-12 | McHenry | Illinois | 17111 | 75224 | 498 |
2299800 | 2299800 | 2022-03-12 | McHenry | North Dakota | 38049 | 1300 | 31 |
2295181 | 2295181 | 2022-03-11 | McHenry | Illinois | 17111 | 75224 | 498 |
2296548 | 2296548 | 2022-03-11 | McHenry | North Dakota | 38049 | 1297 | 31 |
2291929 | 2291929 | 2022-03-10 | McHenry | Illinois | 17111 | 75198 | 498 |
2293296 | 2293296 | 2022-03-10 | McHenry | North Dakota | 38049 | 1297 | 31 |
2288677 | 2288677 | 2022-03-09 | McHenry | Illinois | 17111 | 75164 | 496 |
2290044 | 2290044 | 2022-03-09 | McHenry | North Dakota | 38049 | 1297 | 31 |
2285426 | 2285426 | 2022-03-08 | McHenry | Illinois | 17111 | 75124 | 494 |
2286792 | 2286792 | 2022-03-08 | McHenry | North Dakota | 38049 | 1294 | 31 |
2282174 | 2282174 | 2022-03-07 | McHenry | Illinois | 17111 | 75084 | 493 |
2283540 | 2283540 | 2022-03-07 | McHenry | North Dakota | 38049 | 1294 | 31 |
2278921 | 2278921 | 2022-03-06 | McHenry | Illinois | 17111 | 75002 | 492 |
2280288 | 2280288 | 2022-03-06 | McHenry | North Dakota | 38049 | 1293 | 31 |
2275668 | 2275668 | 2022-03-05 | McHenry | Illinois | 17111 | 75002 | 492 |
2277035 | 2277035 | 2022-03-05 | McHenry | North Dakota | 38049 | 1293 | 31 |
2272415 | 2272415 | 2022-03-04 | McHenry | Illinois | 17111 | 75002 | 492 |
2273782 | 2273782 | 2022-03-04 | McHenry | North Dakota | 38049 | 1292 | 30 |
2269163 | 2269163 | 2022-03-03 | McHenry | Illinois | 17111 | 74959 | 492 |
2270529 | 2270529 | 2022-03-03 | McHenry | North Dakota | 38049 | 1292 | 30 |
2265910 | 2265910 | 2022-03-02 | McHenry | Illinois | 17111 | 74928 | 492 |
2267277 | 2267277 | 2022-03-02 | McHenry | North Dakota | 38049 | 1292 | 30 |
2262659 | 2262659 | 2022-03-01 | McHenry | Illinois | 17111 | 74875 | 487 |
2264025 | 2264025 | 2022-03-01 | McHenry | North Dakota | 38049 | 1292 | 30 |
2259408 | 2259408 | 2022-02-28 | McHenry | Illinois | 17111 | 74815 | 487 |
2260774 | 2260774 | 2022-02-28 | McHenry | North Dakota | 38049 | 1291 | 30 |
2256157 | 2256157 | 2022-02-27 | McHenry | Illinois | 17111 | 74685 | 483 |
2257523 | 2257523 | 2022-02-27 | McHenry | North Dakota | 38049 | 1291 | 30 |
2252906 | 2252906 | 2022-02-26 | McHenry | Illinois | 17111 | 74685 | 483 |
2254272 | 2254272 | 2022-02-26 | McHenry | North Dakota | 38049 | 1290 | 30 |
2249655 | 2249655 | 2022-02-25 | McHenry | Illinois | 17111 | 74685 | 483 |
2251021 | 2251021 | 2022-02-25 | McHenry | North Dakota | 38049 | 1289 | 30 |
2246404 | 2246404 | 2022-02-24 | McHenry | Illinois | 17111 | 74612 | 482 |
2247770 | 2247770 | 2022-02-24 | McHenry | North Dakota | 38049 | 1289 | 30 |
2243153 | 2243153 | 2022-02-23 | McHenry | Illinois | 17111 | 74570 | 482 |
2244519 | 2244519 | 2022-02-23 | McHenry | North Dakota | 38049 | 1288 | 30 |
2239902 | 2239902 | 2022-02-22 | McHenry | Illinois | 17111 | 74475 | 481 |
2241268 | 2241268 | 2022-02-22 | McHenry | North Dakota | 38049 | 1289 | 30 |
2236651 | 2236651 | 2022-02-21 | McHenry | Illinois | 17111 | 74315 | 474 |
2238017 | 2238017 | 2022-02-21 | McHenry | North Dakota | 38049 | 1285 | 30 |
2233400 | 2233400 | 2022-02-20 | McHenry | Illinois | 17111 | 74315 | 474 |
2234766 | 2234766 | 2022-02-20 | McHenry | North Dakota | 38049 | 1285 | 30 |
2230149 | 2230149 | 2022-02-19 | McHenry | Illinois | 17111 | 74315 | 474 |
2231515 | 2231515 | 2022-02-19 | McHenry | North Dakota | 38049 | 1280 | 30 |
2226898 | 2226898 | 2022-02-18 | McHenry | Illinois | 17111 | 74315 | 474 |
2228264 | 2228264 | 2022-02-18 | McHenry | North Dakota | 38049 | 1276 | 30 |
2223647 | 2223647 | 2022-02-17 | McHenry | Illinois | 17111 | 74241 | 473 |
2225013 | 2225013 | 2022-02-17 | McHenry | North Dakota | 38049 | 1273 | 30 |
2220396 | 2220396 | 2022-02-16 | McHenry | Illinois | 17111 | 74177 | 467 |
2221762 | 2221762 | 2022-02-16 | McHenry | North Dakota | 38049 | 1269 | 30 |
2217145 | 2217145 | 2022-02-15 | McHenry | Illinois | 17111 | 74066 | 466 |
2218511 | 2218511 | 2022-02-15 | McHenry | North Dakota | 38049 | 1270 | 30 |
2213894 | 2213894 | 2022-02-14 | McHenry | Illinois | 17111 | 73948 | 465 |
2215260 | 2215260 | 2022-02-14 | McHenry | North Dakota | 38049 | 1268 | 30 |
2210642 | 2210642 | 2022-02-13 | McHenry | Illinois | 17111 | 73514 | 461 |
2212009 | 2212009 | 2022-02-13 | McHenry | North Dakota | 38049 | 1267 | 30 |
2207389 | 2207389 | 2022-02-12 | McHenry | Illinois | 17111 | 73514 | 461 |
2208756 | 2208756 | 2022-02-12 | McHenry | North Dakota | 38049 | 1266 | 30 |
2204136 | 2204136 | 2022-02-11 | McHenry | Illinois | 17111 | 73514 | 461 |
2205503 | 2205503 | 2022-02-11 | McHenry | North Dakota | 38049 | 1263 | 30 |
2200883 | 2200883 | 2022-02-10 | McHenry | Illinois | 17111 | 73514 | 461 |
2202250 | 2202250 | 2022-02-10 | McHenry | North Dakota | 38049 | 1260 | 30 |
2197629 | 2197629 | 2022-02-09 | McHenry | Illinois | 17111 | 73357 | 460 |
2198996 | 2198996 | 2022-02-09 | McHenry | North Dakota | 38049 | 1260 | 30 |
2194375 | 2194375 | 2022-02-08 | McHenry | Illinois | 17111 | 73213 | 460 |
2195742 | 2195742 | 2022-02-08 | McHenry | North Dakota | 38049 | 1257 | 30 |
2191121 | 2191121 | 2022-02-07 | McHenry | Illinois | 17111 | 73062 | 459 |
2192488 | 2192488 | 2022-02-07 | McHenry | North Dakota | 38049 | 1252 | 30 |
2187868 | 2187868 | 2022-02-06 | McHenry | Illinois | 17111 | 72604 | 456 |
2189234 | 2189234 | 2022-02-06 | McHenry | North Dakota | 38049 | 1246 | 30 |
2184615 | 2184615 | 2022-02-05 | McHenry | Illinois | 17111 | 72604 | 456 |
2185981 | 2185981 | 2022-02-05 | McHenry | North Dakota | 38049 | 1246 | 30 |
2181363 | 2181363 | 2022-02-04 | McHenry | Illinois | 17111 | 72604 | 456 |
2182729 | 2182729 | 2022-02-04 | McHenry | North Dakota | 38049 | 1242 | 30 |
2178112 | 2178112 | 2022-02-03 | McHenry | Illinois | 17111 | 70588 | 454 |
2179477 | 2179477 | 2022-02-03 | McHenry | North Dakota | 38049 | 1236 | 30 |
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);