ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Pike" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500079 | 2500079 | 2022-05-13 | Pike | Georgia | 13231 | 5473 | 98 |
2496821 | 2496821 | 2022-05-12 | Pike | Georgia | 13231 | 5473 | 98 |
2493563 | 2493563 | 2022-05-11 | Pike | Georgia | 13231 | 5473 | 98 |
2490305 | 2490305 | 2022-05-10 | Pike | Georgia | 13231 | 5466 | 98 |
2487048 | 2487048 | 2022-05-09 | Pike | Georgia | 13231 | 5466 | 98 |
2483790 | 2483790 | 2022-05-08 | Pike | Georgia | 13231 | 5465 | 98 |
2480532 | 2480532 | 2022-05-07 | Pike | Georgia | 13231 | 5465 | 98 |
2477274 | 2477274 | 2022-05-06 | Pike | Georgia | 13231 | 5465 | 98 |
2474016 | 2474016 | 2022-05-05 | Pike | Georgia | 13231 | 5465 | 98 |
2470759 | 2470759 | 2022-05-04 | Pike | Georgia | 13231 | 5465 | 98 |
2467503 | 2467503 | 2022-05-03 | Pike | Georgia | 13231 | 5461 | 97 |
2464248 | 2464248 | 2022-05-02 | Pike | Georgia | 13231 | 5461 | 97 |
2460992 | 2460992 | 2022-05-01 | Pike | Georgia | 13231 | 5461 | 97 |
2457736 | 2457736 | 2022-04-30 | Pike | Georgia | 13231 | 5461 | 97 |
2454480 | 2454480 | 2022-04-29 | Pike | Georgia | 13231 | 5461 | 97 |
2451224 | 2451224 | 2022-04-28 | Pike | Georgia | 13231 | 5461 | 97 |
2447968 | 2447968 | 2022-04-27 | Pike | Georgia | 13231 | 5461 | 97 |
2444712 | 2444712 | 2022-04-26 | Pike | Georgia | 13231 | 5459 | 97 |
2441456 | 2441456 | 2022-04-25 | Pike | Georgia | 13231 | 5459 | 97 |
2438200 | 2438200 | 2022-04-24 | Pike | Georgia | 13231 | 5459 | 97 |
2434944 | 2434944 | 2022-04-23 | Pike | Georgia | 13231 | 5459 | 97 |
2431688 | 2431688 | 2022-04-22 | Pike | Georgia | 13231 | 5459 | 97 |
2428432 | 2428432 | 2022-04-21 | Pike | Georgia | 13231 | 5459 | 97 |
2425176 | 2425176 | 2022-04-20 | Pike | Georgia | 13231 | 5459 | 97 |
2421920 | 2421920 | 2022-04-19 | Pike | Georgia | 13231 | 5455 | 96 |
2418664 | 2418664 | 2022-04-18 | Pike | Georgia | 13231 | 5455 | 96 |
2415408 | 2415408 | 2022-04-17 | Pike | Georgia | 13231 | 5454 | 96 |
2412152 | 2412152 | 2022-04-16 | Pike | Georgia | 13231 | 5454 | 96 |
2408896 | 2408896 | 2022-04-15 | Pike | Georgia | 13231 | 5454 | 96 |
2405640 | 2405640 | 2022-04-14 | Pike | Georgia | 13231 | 5453 | 96 |
2402385 | 2402385 | 2022-04-13 | Pike | Georgia | 13231 | 5452 | 95 |
2399130 | 2399130 | 2022-04-12 | Pike | Georgia | 13231 | 5452 | 95 |
2395875 | 2395875 | 2022-04-11 | Pike | Georgia | 13231 | 5452 | 94 |
2392619 | 2392619 | 2022-04-10 | Pike | Georgia | 13231 | 5451 | 93 |
2389363 | 2389363 | 2022-04-09 | Pike | Georgia | 13231 | 5451 | 93 |
2386108 | 2386108 | 2022-04-08 | Pike | Georgia | 13231 | 5451 | 93 |
2382853 | 2382853 | 2022-04-07 | Pike | Georgia | 13231 | 5450 | 93 |
2379598 | 2379598 | 2022-04-06 | Pike | Georgia | 13231 | 5450 | 93 |
2376344 | 2376344 | 2022-04-05 | Pike | Georgia | 13231 | 5449 | 93 |
2373092 | 2373092 | 2022-04-04 | Pike | Georgia | 13231 | 5448 | 93 |
2369839 | 2369839 | 2022-04-03 | Pike | Georgia | 13231 | 5447 | 93 |
2366586 | 2366586 | 2022-04-02 | Pike | Georgia | 13231 | 5447 | 93 |
2363333 | 2363333 | 2022-04-01 | Pike | Georgia | 13231 | 5447 | 93 |
2360079 | 2360079 | 2022-03-31 | Pike | Georgia | 13231 | 5447 | 93 |
2356825 | 2356825 | 2022-03-30 | Pike | Georgia | 13231 | 5447 | 93 |
2353572 | 2353572 | 2022-03-29 | Pike | Georgia | 13231 | 5445 | 93 |
2350320 | 2350320 | 2022-03-28 | Pike | Georgia | 13231 | 5445 | 92 |
2347067 | 2347067 | 2022-03-27 | Pike | Georgia | 13231 | 5442 | 91 |
2343814 | 2343814 | 2022-03-26 | Pike | Georgia | 13231 | 5442 | 91 |
2340561 | 2340561 | 2022-03-25 | Pike | Georgia | 13231 | 5442 | 91 |
2337308 | 2337308 | 2022-03-24 | Pike | Georgia | 13231 | 5441 | 89 |
2334054 | 2334054 | 2022-03-23 | Pike | Georgia | 13231 | 5439 | 89 |
2330800 | 2330800 | 2022-03-22 | Pike | Georgia | 13231 | 5437 | 89 |
2327548 | 2327548 | 2022-03-21 | Pike | Georgia | 13231 | 5435 | 89 |
2324295 | 2324295 | 2022-03-20 | Pike | Georgia | 13231 | 5432 | 89 |
2321041 | 2321041 | 2022-03-19 | Pike | Georgia | 13231 | 5432 | 89 |
2317787 | 2317787 | 2022-03-18 | Pike | Georgia | 13231 | 5432 | 89 |
2314534 | 2314534 | 2022-03-17 | Pike | Georgia | 13231 | 5431 | 89 |
2311281 | 2311281 | 2022-03-16 | Pike | Georgia | 13231 | 5428 | 89 |
2308028 | 2308028 | 2022-03-15 | Pike | Georgia | 13231 | 5423 | 89 |
2304777 | 2304777 | 2022-03-14 | Pike | Georgia | 13231 | 5416 | 89 |
2301525 | 2301525 | 2022-03-13 | Pike | Georgia | 13231 | 5413 | 89 |
2298273 | 2298273 | 2022-03-12 | Pike | Georgia | 13231 | 5413 | 89 |
2295021 | 2295021 | 2022-03-11 | Pike | Georgia | 13231 | 5413 | 89 |
2291769 | 2291769 | 2022-03-10 | Pike | Georgia | 13231 | 5410 | 89 |
2288517 | 2288517 | 2022-03-09 | Pike | Georgia | 13231 | 5406 | 88 |
2285266 | 2285266 | 2022-03-08 | Pike | Georgia | 13231 | 5402 | 88 |
2282014 | 2282014 | 2022-03-07 | Pike | Georgia | 13231 | 5394 | 88 |
2278761 | 2278761 | 2022-03-06 | Pike | Georgia | 13231 | 5392 | 88 |
2275508 | 2275508 | 2022-03-05 | Pike | Georgia | 13231 | 5392 | 88 |
2272255 | 2272255 | 2022-03-04 | Pike | Georgia | 13231 | 5392 | 88 |
2269003 | 2269003 | 2022-03-03 | Pike | Georgia | 13231 | 5387 | 87 |
2265750 | 2265750 | 2022-03-02 | Pike | Georgia | 13231 | 5383 | 87 |
2262499 | 2262499 | 2022-03-01 | Pike | Georgia | 13231 | 5374 | 87 |
2259248 | 2259248 | 2022-02-28 | Pike | Georgia | 13231 | 5357 | 87 |
2255997 | 2255997 | 2022-02-27 | Pike | Georgia | 13231 | 5343 | 87 |
2252746 | 2252746 | 2022-02-26 | Pike | Georgia | 13231 | 5343 | 87 |
2249495 | 2249495 | 2022-02-25 | Pike | Georgia | 13231 | 5343 | 87 |
2246244 | 2246244 | 2022-02-24 | Pike | Georgia | 13231 | 5338 | 87 |
2242993 | 2242993 | 2022-02-23 | Pike | Georgia | 13231 | 5338 | 86 |
2239742 | 2239742 | 2022-02-22 | Pike | Georgia | 13231 | 5320 | 86 |
2236491 | 2236491 | 2022-02-21 | Pike | Georgia | 13231 | 5315 | 85 |
2233240 | 2233240 | 2022-02-20 | Pike | Georgia | 13231 | 5308 | 84 |
2229989 | 2229989 | 2022-02-19 | Pike | Georgia | 13231 | 5308 | 84 |
2226738 | 2226738 | 2022-02-18 | Pike | Georgia | 13231 | 5308 | 84 |
2223487 | 2223487 | 2022-02-17 | Pike | Georgia | 13231 | 5298 | 84 |
2220236 | 2220236 | 2022-02-16 | Pike | Georgia | 13231 | 5287 | 84 |
2216985 | 2216985 | 2022-02-15 | Pike | Georgia | 13231 | 5280 | 84 |
2213734 | 2213734 | 2022-02-14 | Pike | Georgia | 13231 | 5270 | 84 |
2210482 | 2210482 | 2022-02-13 | Pike | Georgia | 13231 | 5262 | 84 |
2207229 | 2207229 | 2022-02-12 | Pike | Georgia | 13231 | 5262 | 84 |
2203976 | 2203976 | 2022-02-11 | Pike | Georgia | 13231 | 5262 | 84 |
2200723 | 2200723 | 2022-02-10 | Pike | Georgia | 13231 | 5250 | 84 |
2197469 | 2197469 | 2022-02-09 | Pike | Georgia | 13231 | 5243 | 83 |
2194215 | 2194215 | 2022-02-08 | Pike | Georgia | 13231 | 5234 | 80 |
2190961 | 2190961 | 2022-02-07 | Pike | Georgia | 13231 | 5213 | 80 |
2187708 | 2187708 | 2022-02-06 | Pike | Georgia | 13231 | 5208 | 79 |
2184455 | 2184455 | 2022-02-05 | Pike | Georgia | 13231 | 5208 | 79 |
2181203 | 2181203 | 2022-02-04 | Pike | Georgia | 13231 | 5208 | 79 |
2177952 | 2177952 | 2022-02-03 | Pike | Georgia | 13231 | 5194 | 79 |
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);