ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

784 rows where county = "Unknown" and state = "Georgia" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

state 1

  • Georgia · 784 ✖

fips 1

  • - 784

county 1

  • Unknown · 784 ✖
Link rowid date ▲ county state fips cases deaths
2500110 2500110 2022-05-13 Unknown Georgia   10941 6
2496852 2496852 2022-05-12 Unknown Georgia   10941 6
2493594 2493594 2022-05-11 Unknown Georgia   10941 6
2490336 2490336 2022-05-10 Unknown Georgia   10770 6
2487079 2487079 2022-05-09 Unknown Georgia   10770 6
2483821 2483821 2022-05-08 Unknown Georgia   10770 6
2480563 2480563 2022-05-07 Unknown Georgia   10770 6
2477305 2477305 2022-05-06 Unknown Georgia   10770 6
2474047 2474047 2022-05-05 Unknown Georgia   10770 6
2470790 2470790 2022-05-04 Unknown Georgia   10770 6
2467534 2467534 2022-05-03 Unknown Georgia   10746 6
2464279 2464279 2022-05-02 Unknown Georgia   10746 6
2461023 2461023 2022-05-01 Unknown Georgia   10745 6
2457767 2457767 2022-04-30 Unknown Georgia   10745 6
2454511 2454511 2022-04-29 Unknown Georgia   10745 6
2451255 2451255 2022-04-28 Unknown Georgia   10745 6
2447999 2447999 2022-04-27 Unknown Georgia   10745 6
2444743 2444743 2022-04-26 Unknown Georgia   10710 6
2441487 2441487 2022-04-25 Unknown Georgia   10710 6
2438231 2438231 2022-04-24 Unknown Georgia   10711 6
2434975 2434975 2022-04-23 Unknown Georgia   10711 6
2431719 2431719 2022-04-22 Unknown Georgia   10711 6
2428463 2428463 2022-04-21 Unknown Georgia   10711 6
2425207 2425207 2022-04-20 Unknown Georgia   10711 6
2421951 2421951 2022-04-19 Unknown Georgia   10570 7
2418695 2418695 2022-04-18 Unknown Georgia   10570 7
2415439 2415439 2022-04-17 Unknown Georgia   10572 7
2412183 2412183 2022-04-16 Unknown Georgia   10572 7
2408927 2408927 2022-04-15 Unknown Georgia   10572 7
2405671 2405671 2022-04-14 Unknown Georgia   10539 7
2402416 2402416 2022-04-13 Unknown Georgia   10544 7
2399161 2399161 2022-04-12 Unknown Georgia   10547 7
2395906 2395906 2022-04-11 Unknown Georgia   10553 7
2392650 2392650 2022-04-10 Unknown Georgia   10517 9
2389394 2389394 2022-04-09 Unknown Georgia   10517 9
2386139 2386139 2022-04-08 Unknown Georgia   10517 9
2382884 2382884 2022-04-07 Unknown Georgia   10462 12
2379629 2379629 2022-04-06 Unknown Georgia   10458 13
2376375 2376375 2022-04-05 Unknown Georgia   10492 14
2373123 2373123 2022-04-04 Unknown Georgia   10462 14
2369870 2369870 2022-04-03 Unknown Georgia   10469 14
2366617 2366617 2022-04-02 Unknown Georgia   10469 14
2363364 2363364 2022-04-01 Unknown Georgia   10469 14
2360110 2360110 2022-03-31 Unknown Georgia   10429 14
2356856 2356856 2022-03-30 Unknown Georgia   10560 14
2353603 2353603 2022-03-29 Unknown Georgia   10530 14
2350351 2350351 2022-03-28 Unknown Georgia   10579 14
2347098 2347098 2022-03-27 Unknown Georgia   10579 14
2343845 2343845 2022-03-26 Unknown Georgia   10579 14
2340592 2340592 2022-03-25 Unknown Georgia   10579 14
2337339 2337339 2022-03-24 Unknown Georgia   10532 14
2334085 2334085 2022-03-23 Unknown Georgia   10396 14
2330831 2330831 2022-03-22 Unknown Georgia   10400 14
2327579 2327579 2022-03-21 Unknown Georgia   10415 14
2324326 2324326 2022-03-20 Unknown Georgia   10423 14
2321072 2321072 2022-03-19 Unknown Georgia   10423 14
2317818 2317818 2022-03-18 Unknown Georgia   10423 14
2314565 2314565 2022-03-17 Unknown Georgia   10427 21
2311312 2311312 2022-03-16 Unknown Georgia   10421 21
2308059 2308059 2022-03-15 Unknown Georgia   10378 21
2304808 2304808 2022-03-14 Unknown Georgia   10409 21
2301556 2301556 2022-03-13 Unknown Georgia   10442 21
2298304 2298304 2022-03-12 Unknown Georgia   10442 21
2295052 2295052 2022-03-11 Unknown Georgia   10442 21
2291800 2291800 2022-03-10 Unknown Georgia   10445 21
2288548 2288548 2022-03-09 Unknown Georgia   10430 20
2285297 2285297 2022-03-08 Unknown Georgia   10429 20
2282045 2282045 2022-03-07 Unknown Georgia   10416 19
2278792 2278792 2022-03-06 Unknown Georgia   10555 18
2275539 2275539 2022-03-05 Unknown Georgia   10555 18
2272286 2272286 2022-03-04 Unknown Georgia   10555 18
2269034 2269034 2022-03-03 Unknown Georgia   10551 16
2265781 2265781 2022-03-02 Unknown Georgia   10538 18
2262530 2262530 2022-03-01 Unknown Georgia   10595 19
2259279 2259279 2022-02-28 Unknown Georgia   10608 19
2256028 2256028 2022-02-27 Unknown Georgia   10611 16
2252777 2252777 2022-02-26 Unknown Georgia   10611 16
2249526 2249526 2022-02-25 Unknown Georgia   10611 16
2246275 2246275 2022-02-24 Unknown Georgia   10606 15
2243024 2243024 2022-02-23 Unknown Georgia   10620 24
2239773 2239773 2022-02-22 Unknown Georgia   10649 23
2236522 2236522 2022-02-21 Unknown Georgia   10713 23
2233271 2233271 2022-02-20 Unknown Georgia   10849 22
2230020 2230020 2022-02-19 Unknown Georgia   10849 22
2226769 2226769 2022-02-18 Unknown Georgia   10849 22
2223518 2223518 2022-02-17 Unknown Georgia   10806 23
2220267 2220267 2022-02-16 Unknown Georgia   10846 19
2217016 2217016 2022-02-15 Unknown Georgia   10944 17
2213765 2213765 2022-02-14 Unknown Georgia   10918 16
2210513 2210513 2022-02-13 Unknown Georgia   10946 12
2207260 2207260 2022-02-12 Unknown Georgia   10946 12
2204007 2204007 2022-02-11 Unknown Georgia   10946 12
2200754 2200754 2022-02-10 Unknown Georgia   10894 12
2197500 2197500 2022-02-09 Unknown Georgia   11193 13
2194246 2194246 2022-02-08 Unknown Georgia   11227 12
2190992 2190992 2022-02-07 Unknown Georgia   11222 11
2187739 2187739 2022-02-06 Unknown Georgia   11425 11
2184486 2184486 2022-02-05 Unknown Georgia   11425 11
2181234 2181234 2022-02-04 Unknown Georgia   11425 11
2177983 2177983 2022-02-03 Unknown Georgia   11415 11

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);