home / covid

Menu
  • GraphQL API

ny_times_us_counties

Table actions
  • GraphQL API for ny_times_us_counties
⚠️ 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

832 rows where fips = 6075 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • California 832

fips 1

  • 6075 · 832 ✖

county 1

  • San Francisco 832
Link rowid date ▲ county state fips cases deaths
2499799 2499799 2022-05-13 San Francisco California 6075 143959 866
2496541 2496541 2022-05-12 San Francisco California 6075 142863 864
2493283 2493283 2022-05-11 San Francisco California 6075 142863 864
2490025 2490025 2022-05-10 San Francisco California 6075 142863 864
2486768 2486768 2022-05-09 San Francisco California 6075 141495 861
2483510 2483510 2022-05-08 San Francisco California 6075 141495 861
2480252 2480252 2022-05-07 San Francisco California 6075 141495 861
2476994 2476994 2022-05-06 San Francisco California 6075 141495 861
2473736 2473736 2022-05-05 San Francisco California 6075 140270 860
2470479 2470479 2022-05-04 San Francisco California 6075 140270 860
2467223 2467223 2022-05-03 San Francisco California 6075 140270 860
2463968 2463968 2022-05-02 San Francisco California 6075 138912 860
2460712 2460712 2022-05-01 San Francisco California 6075 138912 860
2457456 2457456 2022-04-30 San Francisco California 6075 138912 860
2454200 2454200 2022-04-29 San Francisco California 6075 138912 860
2450944 2450944 2022-04-28 San Francisco California 6075 137816 857
2447688 2447688 2022-04-27 San Francisco California 6075 137816 857
2444432 2444432 2022-04-26 San Francisco California 6075 137816 857
2441176 2441176 2022-04-25 San Francisco California 6075 136855 857
2437920 2437920 2022-04-24 San Francisco California 6075 136855 857
2434664 2434664 2022-04-23 San Francisco California 6075 136855 857
2431408 2431408 2022-04-22 San Francisco California 6075 136855 857
2428152 2428152 2022-04-21 San Francisco California 6075 136065 854
2424896 2424896 2022-04-20 San Francisco California 6075 136065 854
2421640 2421640 2022-04-19 San Francisco California 6075 136065 854
2418384 2418384 2022-04-18 San Francisco California 6075 135447 854
2415128 2415128 2022-04-17 San Francisco California 6075 135447 854
2411872 2411872 2022-04-16 San Francisco California 6075 135447 854
2408616 2408616 2022-04-15 San Francisco California 6075 135447 854
2405360 2405360 2022-04-14 San Francisco California 6075 135079 850
2402105 2402105 2022-04-13 San Francisco California 6075 134372 844
2398850 2398850 2022-04-12 San Francisco California 6075 134372 844
2395595 2395595 2022-04-11 San Francisco California 6075 134372 844
2392339 2392339 2022-04-10 San Francisco California 6075 134372 844
2389083 2389083 2022-04-09 San Francisco California 6075 134372 844
2385828 2385828 2022-04-08 San Francisco California 6075 134372 844
2382573 2382573 2022-04-07 San Francisco California 6075 133945 843
2379318 2379318 2022-04-06 San Francisco California 6075 133945 843
2376064 2376064 2022-04-05 San Francisco California 6075 133945 843
2372812 2372812 2022-04-04 San Francisco California 6075 133484 843
2369559 2369559 2022-04-03 San Francisco California 6075 133484 843
2366306 2366306 2022-04-02 San Francisco California 6075 133484 843
2363053 2363053 2022-04-01 San Francisco California 6075 133484 843
2359799 2359799 2022-03-31 San Francisco California 6075 133339 841
2356545 2356545 2022-03-30 San Francisco California 6075 133140 840
2353292 2353292 2022-03-29 San Francisco California 6075 133029 839
2350040 2350040 2022-03-28 San Francisco California 6075 132970 839
2346787 2346787 2022-03-27 San Francisco California 6075 132616 839
2343534 2343534 2022-03-26 San Francisco California 6075 132616 839
2340281 2340281 2022-03-25 San Francisco California 6075 132616 839
2337028 2337028 2022-03-24 San Francisco California 6075 132461 838
2333774 2333774 2022-03-23 San Francisco California 6075 132316 838
2330520 2330520 2022-03-22 San Francisco California 6075 132230 835
2327268 2327268 2022-03-21 San Francisco California 6075 132176 835
2324015 2324015 2022-03-20 San Francisco California 6075 131905 833
2320761 2320761 2022-03-19 San Francisco California 6075 131905 833
2317507 2317507 2022-03-18 San Francisco California 6075 131905 833
2314254 2314254 2022-03-17 San Francisco California 6075 131764 831
2311001 2311001 2022-03-16 San Francisco California 6075 132054 831
2307748 2307748 2022-03-15 San Francisco California 6075 132103 824
2304497 2304497 2022-03-14 San Francisco California 6075 132150 824
2301245 2301245 2022-03-13 San Francisco California 6075 132138 823
2297993 2297993 2022-03-12 San Francisco California 6075 132138 823
2294741 2294741 2022-03-11 San Francisco California 6075 132138 823
2291489 2291489 2022-03-10 San Francisco California 6075 132204 812
2288237 2288237 2022-03-09 San Francisco California 6075 132261 807
2284986 2284986 2022-03-08 San Francisco California 6075 132241 807
2281734 2281734 2022-03-07 San Francisco California 6075 132328 806
2278481 2278481 2022-03-06 San Francisco California 6075 132123 798
2275228 2275228 2022-03-05 San Francisco California 6075 132123 798
2271975 2271975 2022-03-04 San Francisco California 6075 132123 798
2268723 2268723 2022-03-03 San Francisco California 6075 132028 792
2265470 2265470 2022-03-02 San Francisco California 6075 132118 792
2262219 2262219 2022-03-01 San Francisco California 6075 132039 792
2258968 2258968 2022-02-28 San Francisco California 6075 131964 791
2255717 2255717 2022-02-27 San Francisco California 6075 131716 769
2252466 2252466 2022-02-26 San Francisco California 6075 131716 769
2249215 2249215 2022-02-25 San Francisco California 6075 131716 769
2245964 2245964 2022-02-24 San Francisco California 6075 130764 769
2242713 2242713 2022-02-23 San Francisco California 6075 130538 769
2239462 2239462 2022-02-22 San Francisco California 6075 130449 769
2236211 2236211 2022-02-21 San Francisco California 6075 129781 756
2232960 2232960 2022-02-20 San Francisco California 6075 129781 756
2229709 2229709 2022-02-19 San Francisco California 6075 129781 756
2226458 2226458 2022-02-18 San Francisco California 6075 129781 756
2223207 2223207 2022-02-17 San Francisco California 6075 129571 756
2219956 2219956 2022-02-16 San Francisco California 6075 129499 756
2216705 2216705 2022-02-15 San Francisco California 6075 129321 756
2213454 2213454 2022-02-14 San Francisco California 6075 129035 756
2210202 2210202 2022-02-13 San Francisco California 6075 127853 740
2206949 2206949 2022-02-12 San Francisco California 6075 127853 740
2203696 2203696 2022-02-11 San Francisco California 6075 127853 740
2200443 2200443 2022-02-10 San Francisco California 6075 127290 731
2197189 2197189 2022-02-09 San Francisco California 6075 130054 731
2193934 2193934 2022-02-08 San Francisco California 6075 126057 727
2190681 2190681 2022-02-07 San Francisco California 6075 125227 728
2187428 2187428 2022-02-06 San Francisco California 6075 124593 720
2184175 2184175 2022-02-05 San Francisco California 6075 124593 720
2180923 2180923 2022-02-04 San Francisco California 6075 124593 720
2177672 2177672 2022-02-03 San Francisco California 6075 124120 714

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);
Powered by Datasette · Queries took 66.958ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette