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

794 rows where county = "St. Johns" and state = "Florida" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Florida · 794 ✖

fips 1

county 1

  • St. Johns · 794 ✖
Link rowid date ▲ county state fips cases deaths
2499955 2499955 2022-05-13 St. Johns Florida 12109 63143 567
2496697 2496697 2022-05-12 St. Johns Florida 12109 63143 567
2493439 2493439 2022-05-11 St. Johns Florida 12109 63143 567
2490181 2490181 2022-05-10 St. Johns Florida 12109 63143 566
2486924 2486924 2022-05-09 St. Johns Florida 12109 63143 566
2483666 2483666 2022-05-08 St. Johns Florida 12109 63143 566
2480408 2480408 2022-05-07 St. Johns Florida 12109 63143 566
2477150 2477150 2022-05-06 St. Johns Florida 12109 63143 566
2473892 2473892 2022-05-05 St. Johns Florida 12109 62698 566
2470635 2470635 2022-05-04 St. Johns Florida 12109 62698 566
2467379 2467379 2022-05-03 St. Johns Florida 12109 62698 566
2464124 2464124 2022-05-02 St. Johns Florida 12109 62698 566
2460868 2460868 2022-05-01 St. Johns Florida 12109 62698 566
2457612 2457612 2022-04-30 St. Johns Florida 12109 62698 566
2454356 2454356 2022-04-29 St. Johns Florida 12109 62698 566
2451100 2451100 2022-04-28 St. Johns Florida 12109 62698 566
2447844 2447844 2022-04-27 St. Johns Florida 12109 62698 566
2444588 2444588 2022-04-26 St. Johns Florida 12109 62698 565
2441332 2441332 2022-04-25 St. Johns Florida 12109 62698 565
2438076 2438076 2022-04-24 St. Johns Florida 12109 62698 565
2434820 2434820 2022-04-23 St. Johns Florida 12109 62698 565
2431564 2431564 2022-04-22 St. Johns Florida 12109 62698 565
2428308 2428308 2022-04-21 St. Johns Florida 12109 62469 565
2425052 2425052 2022-04-20 St. Johns Florida 12109 62469 565
2421796 2421796 2022-04-19 St. Johns Florida 12109 62469 563
2418540 2418540 2022-04-18 St. Johns Florida 12109 62469 563
2415284 2415284 2022-04-17 St. Johns Florida 12109 62469 563
2412028 2412028 2022-04-16 St. Johns Florida 12109 62469 563
2408772 2408772 2022-04-15 St. Johns Florida 12109 62469 563
2405516 2405516 2022-04-14 St. Johns Florida 12109 62469 563
2402261 2402261 2022-04-13 St. Johns Florida 12109 62469 563
2399006 2399006 2022-04-12 St. Johns Florida 12109 62469 560
2395751 2395751 2022-04-11 St. Johns Florida 12109 62469 560
2392495 2392495 2022-04-10 St. Johns Florida 12109 62469 560
2389239 2389239 2022-04-09 St. Johns Florida 12109 62469 560
2385984 2385984 2022-04-08 St. Johns Florida 12109 62469 560
2382729 2382729 2022-04-07 St. Johns Florida 12109 62310 560
2379474 2379474 2022-04-06 St. Johns Florida 12109 62310 560
2376220 2376220 2022-04-05 St. Johns Florida 12109 62310 558
2372968 2372968 2022-04-04 St. Johns Florida 12109 62310 558
2369715 2369715 2022-04-03 St. Johns Florida 12109 62310 558
2366462 2366462 2022-04-02 St. Johns Florida 12109 62310 558
2363209 2363209 2022-04-01 St. Johns Florida 12109 62310 558
2359955 2359955 2022-03-31 St. Johns Florida 12109 62310 558
2356701 2356701 2022-03-30 St. Johns Florida 12109 62310 558
2353448 2353448 2022-03-29 St. Johns Florida 12109 62310 559
2350196 2350196 2022-03-28 St. Johns Florida 12109 62310 559
2346943 2346943 2022-03-27 St. Johns Florida 12109 62310 559
2343690 2343690 2022-03-26 St. Johns Florida 12109 62310 559
2340437 2340437 2022-03-25 St. Johns Florida 12109 62310 559
2337184 2337184 2022-03-24 St. Johns Florida 12109 62270 559
2333930 2333930 2022-03-23 St. Johns Florida 12109 62270 550
2330676 2330676 2022-03-22 St. Johns Florida 12109 62270 550
2327424 2327424 2022-03-21 St. Johns Florida 12109 62270 550
2324171 2324171 2022-03-20 St. Johns Florida 12109 62270 550
2320917 2320917 2022-03-19 St. Johns Florida 12109 62270 550
2317663 2317663 2022-03-18 St. Johns Florida 12109 62270 550
2314410 2314410 2022-03-17 St. Johns Florida 12109 62270 550
2311157 2311157 2022-03-16 St. Johns Florida 12109 62270 550
2307904 2307904 2022-03-15 St. Johns Florida 12109 62270 538
2304653 2304653 2022-03-14 St. Johns Florida 12109 62270 538
2301401 2301401 2022-03-13 St. Johns Florida 12109 62270 538
2298149 2298149 2022-03-12 St. Johns Florida 12109 62270 538
2294897 2294897 2022-03-11 St. Johns Florida 12109 62270 538
2291645 2291645 2022-03-10 St. Johns Florida 12109 62337 538
2288393 2288393 2022-03-09 St. Johns Florida 12109 62337 538
2285142 2285142 2022-03-08 St. Johns Florida 12109 62337 527
2281890 2281890 2022-03-07 St. Johns Florida 12109 62337 527
2278637 2278637 2022-03-06 St. Johns Florida 12109 62337 527
2275384 2275384 2022-03-05 St. Johns Florida 12109 62337 527
2272131 2272131 2022-03-04 St. Johns Florida 12109 62337 527
2268879 2268879 2022-03-03 St. Johns Florida 12109 62303 527
2265626 2265626 2022-03-02 St. Johns Florida 12109 62303 527
2262375 2262375 2022-03-01 St. Johns Florida 12109 62303 518
2259124 2259124 2022-02-28 St. Johns Florida 12109 62303 518
2255873 2255873 2022-02-27 St. Johns Florida 12109 62303 518
2252622 2252622 2022-02-26 St. Johns Florida 12109 62303 518
2249371 2249371 2022-02-25 St. Johns Florida 12109 62303 518
2246120 2246120 2022-02-24 St. Johns Florida 12109 62128 518
2242869 2242869 2022-02-23 St. Johns Florida 12109 62128 518
2239618 2239618 2022-02-22 St. Johns Florida 12109 62128 504
2236367 2236367 2022-02-21 St. Johns Florida 12109 62128 504
2233116 2233116 2022-02-20 St. Johns Florida 12109 62128 504
2229865 2229865 2022-02-19 St. Johns Florida 12109 62128 504
2226614 2226614 2022-02-18 St. Johns Florida 12109 62128 504
2223363 2223363 2022-02-17 St. Johns Florida 12109 61593 504
2220112 2220112 2022-02-16 St. Johns Florida 12109 61593 504
2216861 2216861 2022-02-15 St. Johns Florida 12109 61593 498
2213610 2213610 2022-02-14 St. Johns Florida 12109 61593 498
2210358 2210358 2022-02-13 St. Johns Florida 12109 61593 498
2207105 2207105 2022-02-12 St. Johns Florida 12109 61593 498
2203852 2203852 2022-02-11 St. Johns Florida 12109 61593 498
2200599 2200599 2022-02-10 St. Johns Florida 12109 59809 498
2197345 2197345 2022-02-09 St. Johns Florida 12109 59809 498
2194091 2194091 2022-02-08 St. Johns Florida 12109 59809 489
2190837 2190837 2022-02-07 St. Johns Florida 12109 59809 489
2187584 2187584 2022-02-06 St. Johns Florida 12109 59809 489
2184331 2184331 2022-02-05 St. Johns Florida 12109 59809 489
2181079 2181079 2022-02-04 St. Johns Florida 12109 59809 489
2177828 2177828 2022-02-03 St. Johns Florida 12109 57380 489

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