ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,555 rows where county = "Tazewell" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337495 | 2337495 | 2022-03-24 | Tazewell | Illinois | 17179 | 36500 | 495 |
2339857 | 2339857 | 2022-03-24 | Tazewell | Virginia | 51185 | 10145 | 164 |
2334241 | 2334241 | 2022-03-23 | Tazewell | Illinois | 17179 | 36486 | 495 |
2336603 | 2336603 | 2022-03-23 | Tazewell | Virginia | 51185 | 10137 | 164 |
2330987 | 2330987 | 2022-03-22 | Tazewell | Illinois | 17179 | 36478 | 495 |
2333349 | 2333349 | 2022-03-22 | Tazewell | Virginia | 51185 | 10109 | 162 |
2327735 | 2327735 | 2022-03-21 | Tazewell | Illinois | 17179 | 36465 | 495 |
2330096 | 2330096 | 2022-03-21 | Tazewell | Virginia | 51185 | 10109 | 162 |
2324482 | 2324482 | 2022-03-20 | Tazewell | Illinois | 17179 | 36444 | 495 |
2326844 | 2326844 | 2022-03-20 | Tazewell | Virginia | 51185 | 10090 | 160 |
2321228 | 2321228 | 2022-03-19 | Tazewell | Illinois | 17179 | 36444 | 495 |
2323591 | 2323591 | 2022-03-19 | Tazewell | Virginia | 51185 | 10090 | 160 |
2317974 | 2317974 | 2022-03-18 | Tazewell | Illinois | 17179 | 36444 | 495 |
2320337 | 2320337 | 2022-03-18 | Tazewell | Virginia | 51185 | 10090 | 160 |
2314721 | 2314721 | 2022-03-17 | Tazewell | Illinois | 17179 | 36437 | 495 |
2317083 | 2317083 | 2022-03-17 | Tazewell | Virginia | 51185 | 10068 | 160 |
2311468 | 2311468 | 2022-03-16 | Tazewell | Illinois | 17179 | 36425 | 495 |
2313830 | 2313830 | 2022-03-16 | Tazewell | Virginia | 51185 | 10066 | 160 |
2308215 | 2308215 | 2022-03-15 | Tazewell | Illinois | 17179 | 36415 | 494 |
2310577 | 2310577 | 2022-03-15 | Tazewell | Virginia | 51185 | 10061 | 159 |
2304964 | 2304964 | 2022-03-14 | Tazewell | Illinois | 17179 | 36399 | 494 |
2307324 | 2307324 | 2022-03-14 | Tazewell | Virginia | 51185 | 10045 | 159 |
2301712 | 2301712 | 2022-03-13 | Tazewell | Illinois | 17179 | 36375 | 494 |
2304073 | 2304073 | 2022-03-13 | Tazewell | Virginia | 51185 | 10030 | 159 |
2298460 | 2298460 | 2022-03-12 | Tazewell | Illinois | 17179 | 36375 | 494 |
2300821 | 2300821 | 2022-03-12 | Tazewell | Virginia | 51185 | 10030 | 159 |
2295208 | 2295208 | 2022-03-11 | Tazewell | Illinois | 17179 | 36375 | 494 |
2297569 | 2297569 | 2022-03-11 | Tazewell | Virginia | 51185 | 10030 | 159 |
2291956 | 2291956 | 2022-03-10 | Tazewell | Illinois | 17179 | 36363 | 494 |
2294317 | 2294317 | 2022-03-10 | Tazewell | Virginia | 51185 | 10035 | 159 |
2288704 | 2288704 | 2022-03-09 | Tazewell | Illinois | 17179 | 36351 | 493 |
2291065 | 2291065 | 2022-03-09 | Tazewell | Virginia | 51185 | 10028 | 158 |
2285453 | 2285453 | 2022-03-08 | Tazewell | Illinois | 17179 | 36337 | 491 |
2287813 | 2287813 | 2022-03-08 | Tazewell | Virginia | 51185 | 10015 | 157 |
2282201 | 2282201 | 2022-03-07 | Tazewell | Illinois | 17179 | 36330 | 491 |
2284561 | 2284561 | 2022-03-07 | Tazewell | Virginia | 51185 | 10008 | 158 |
2278948 | 2278948 | 2022-03-06 | Tazewell | Illinois | 17179 | 36311 | 491 |
2281309 | 2281309 | 2022-03-06 | Tazewell | Virginia | 51185 | 9972 | 157 |
2275695 | 2275695 | 2022-03-05 | Tazewell | Illinois | 17179 | 36311 | 491 |
2278056 | 2278056 | 2022-03-05 | Tazewell | Virginia | 51185 | 9972 | 157 |
2272442 | 2272442 | 2022-03-04 | Tazewell | Illinois | 17179 | 36311 | 491 |
2274803 | 2274803 | 2022-03-04 | Tazewell | Virginia | 51185 | 9972 | 157 |
2269190 | 2269190 | 2022-03-03 | Tazewell | Illinois | 17179 | 36305 | 491 |
2271550 | 2271550 | 2022-03-03 | Tazewell | Virginia | 51185 | 9957 | 157 |
2265937 | 2265937 | 2022-03-02 | Tazewell | Illinois | 17179 | 36287 | 491 |
2268298 | 2268298 | 2022-03-02 | Tazewell | Virginia | 51185 | 9927 | 156 |
2262686 | 2262686 | 2022-03-01 | Tazewell | Illinois | 17179 | 36274 | 491 |
2265045 | 2265045 | 2022-03-01 | Tazewell | Virginia | 51185 | 9896 | 155 |
2259435 | 2259435 | 2022-02-28 | Tazewell | Illinois | 17179 | 36252 | 487 |
2261795 | 2261795 | 2022-02-28 | Tazewell | Virginia | 51185 | 9888 | 155 |
2256184 | 2256184 | 2022-02-27 | Tazewell | Illinois | 17179 | 36210 | 486 |
2258544 | 2258544 | 2022-02-27 | Tazewell | Virginia | 51185 | 9857 | 154 |
2252933 | 2252933 | 2022-02-26 | Tazewell | Illinois | 17179 | 36210 | 486 |
2255293 | 2255293 | 2022-02-26 | Tazewell | Virginia | 51185 | 9857 | 154 |
2249682 | 2249682 | 2022-02-25 | Tazewell | Illinois | 17179 | 36210 | 486 |
2252042 | 2252042 | 2022-02-25 | Tazewell | Virginia | 51185 | 9857 | 154 |
2246431 | 2246431 | 2022-02-24 | Tazewell | Illinois | 17179 | 36197 | 485 |
2248791 | 2248791 | 2022-02-24 | Tazewell | Virginia | 51185 | 9843 | 152 |
2243180 | 2243180 | 2022-02-23 | Tazewell | Illinois | 17179 | 36175 | 484 |
2245540 | 2245540 | 2022-02-23 | Tazewell | Virginia | 51185 | 9816 | 151 |
2239929 | 2239929 | 2022-02-22 | Tazewell | Illinois | 17179 | 36137 | 484 |
2242289 | 2242289 | 2022-02-22 | Tazewell | Virginia | 51185 | 9758 | 148 |
2236678 | 2236678 | 2022-02-21 | Tazewell | Illinois | 17179 | 36051 | 482 |
2239038 | 2239038 | 2022-02-21 | Tazewell | Virginia | 51185 | 9739 | 148 |
2233427 | 2233427 | 2022-02-20 | Tazewell | Illinois | 17179 | 36051 | 482 |
2235787 | 2235787 | 2022-02-20 | Tazewell | Virginia | 51185 | 9696 | 146 |
2230176 | 2230176 | 2022-02-19 | Tazewell | Illinois | 17179 | 36051 | 482 |
2232536 | 2232536 | 2022-02-19 | Tazewell | Virginia | 51185 | 9696 | 146 |
2226925 | 2226925 | 2022-02-18 | Tazewell | Illinois | 17179 | 36051 | 482 |
2229285 | 2229285 | 2022-02-18 | Tazewell | Virginia | 51185 | 9696 | 146 |
2223674 | 2223674 | 2022-02-17 | Tazewell | Illinois | 17179 | 36012 | 480 |
2226034 | 2226034 | 2022-02-17 | Tazewell | Virginia | 51185 | 9650 | 144 |
2220423 | 2220423 | 2022-02-16 | Tazewell | Illinois | 17179 | 35980 | 480 |
2222783 | 2222783 | 2022-02-16 | Tazewell | Virginia | 51185 | 9595 | 144 |
2217172 | 2217172 | 2022-02-15 | Tazewell | Illinois | 17179 | 35949 | 480 |
2219532 | 2219532 | 2022-02-15 | Tazewell | Virginia | 51185 | 9529 | 143 |
2213921 | 2213921 | 2022-02-14 | Tazewell | Illinois | 17179 | 35924 | 479 |
2216282 | 2216282 | 2022-02-14 | Tazewell | Virginia | 51185 | 9499 | 142 |
2210669 | 2210669 | 2022-02-13 | Tazewell | Illinois | 17179 | 35754 | 475 |
2213031 | 2213031 | 2022-02-13 | Tazewell | Virginia | 51185 | 9419 | 141 |
2207416 | 2207416 | 2022-02-12 | Tazewell | Illinois | 17179 | 35754 | 475 |
2209778 | 2209778 | 2022-02-12 | Tazewell | Virginia | 51185 | 9419 | 141 |
2204163 | 2204163 | 2022-02-11 | Tazewell | Illinois | 17179 | 35754 | 475 |
2206525 | 2206525 | 2022-02-11 | Tazewell | Virginia | 51185 | 9419 | 141 |
2200910 | 2200910 | 2022-02-10 | Tazewell | Illinois | 17179 | 35754 | 475 |
2203272 | 2203272 | 2022-02-10 | Tazewell | Virginia | 51185 | 9274 | 141 |
2197656 | 2197656 | 2022-02-09 | Tazewell | Illinois | 17179 | 35678 | 473 |
2200018 | 2200018 | 2022-02-09 | Tazewell | Virginia | 51185 | 9216 | 141 |
2194402 | 2194402 | 2022-02-08 | Tazewell | Illinois | 17179 | 35620 | 473 |
2196764 | 2196764 | 2022-02-08 | Tazewell | Virginia | 51185 | 9123 | 136 |
2191148 | 2191148 | 2022-02-07 | Tazewell | Illinois | 17179 | 35549 | 473 |
2193509 | 2193509 | 2022-02-07 | Tazewell | Virginia | 51185 | 9074 | 136 |
2187895 | 2187895 | 2022-02-06 | Tazewell | Illinois | 17179 | 35358 | 471 |
2190256 | 2190256 | 2022-02-06 | Tazewell | Virginia | 51185 | 8966 | 132 |
2184642 | 2184642 | 2022-02-05 | Tazewell | Illinois | 17179 | 35358 | 471 |
2187003 | 2187003 | 2022-02-05 | Tazewell | Virginia | 51185 | 8966 | 132 |
2181390 | 2181390 | 2022-02-04 | Tazewell | Illinois | 17179 | 35358 | 471 |
2183750 | 2183750 | 2022-02-04 | Tazewell | Virginia | 51185 | 8966 | 132 |
2178139 | 2178139 | 2022-02-03 | Tazewell | Illinois | 17179 | 35220 | 470 |
2180498 | 2180498 | 2022-02-03 | Tazewell | Virginia | 51185 | 8888 | 131 |
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);