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

810 rows where fips = 6095 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • California 810

fips 1

  • 6095 · 810 ✖

county 1

  • Solano 810
Link rowid date ▲ county state fips cases deaths
2499809 2499809 2022-05-13 Solano California 6095 89419 451
2496551 2496551 2022-05-12 Solano California 6095 89142 450
2493293 2493293 2022-05-11 Solano California 6095 89142 450
2490035 2490035 2022-05-10 Solano California 6095 89142 450
2486778 2486778 2022-05-09 Solano California 6095 88716 450
2483520 2483520 2022-05-08 Solano California 6095 88716 450
2480262 2480262 2022-05-07 Solano California 6095 88716 450
2477004 2477004 2022-05-06 Solano California 6095 88716 450
2473746 2473746 2022-05-05 Solano California 6095 88420 449
2470489 2470489 2022-05-04 Solano California 6095 88420 449
2467233 2467233 2022-05-03 Solano California 6095 88420 449
2463978 2463978 2022-05-02 Solano California 6095 88083 449
2460722 2460722 2022-05-01 Solano California 6095 88083 449
2457466 2457466 2022-04-30 Solano California 6095 88083 449
2454210 2454210 2022-04-29 Solano California 6095 88083 449
2450954 2450954 2022-04-28 Solano California 6095 87818 448
2447698 2447698 2022-04-27 Solano California 6095 87818 448
2444442 2444442 2022-04-26 Solano California 6095 87818 448
2441186 2441186 2022-04-25 Solano California 6095 87580 448
2437930 2437930 2022-04-24 Solano California 6095 87580 448
2434674 2434674 2022-04-23 Solano California 6095 87580 448
2431418 2431418 2022-04-22 Solano California 6095 87580 448
2428162 2428162 2022-04-21 Solano California 6095 87416 447
2424906 2424906 2022-04-20 Solano California 6095 87416 447
2421650 2421650 2022-04-19 Solano California 6095 87416 447
2418394 2418394 2022-04-18 Solano California 6095 87356 447
2415138 2415138 2022-04-17 Solano California 6095 87356 447
2411882 2411882 2022-04-16 Solano California 6095 87356 447
2408626 2408626 2022-04-15 Solano California 6095 87356 447
2405370 2405370 2022-04-14 Solano California 6095 87418 448
2402115 2402115 2022-04-13 Solano California 6095 87439 448
2398860 2398860 2022-04-12 Solano California 6095 87439 448
2395605 2395605 2022-04-11 Solano California 6095 87439 448
2392349 2392349 2022-04-10 Solano California 6095 87439 448
2389093 2389093 2022-04-09 Solano California 6095 87439 448
2385838 2385838 2022-04-08 Solano California 6095 87439 448
2382583 2382583 2022-04-07 Solano California 6095 87342 447
2379328 2379328 2022-04-06 Solano California 6095 87342 447
2376074 2376074 2022-04-05 Solano California 6095 87342 447
2372822 2372822 2022-04-04 Solano California 6095 87401 446
2369569 2369569 2022-04-03 Solano California 6095 87401 446
2366316 2366316 2022-04-02 Solano California 6095 87401 446
2363063 2363063 2022-04-01 Solano California 6095 87401 446
2359809 2359809 2022-03-31 Solano California 6095 87369 443
2356555 2356555 2022-03-30 Solano California 6095 87257 441
2353302 2353302 2022-03-29 Solano California 6095 87248 441
2350050 2350050 2022-03-28 Solano California 6095 87235 441
2346797 2346797 2022-03-27 Solano California 6095 87203 441
2343544 2343544 2022-03-26 Solano California 6095 87203 441
2340291 2340291 2022-03-25 Solano California 6095 87203 441
2337038 2337038 2022-03-24 Solano California 6095 87159 441
2333784 2333784 2022-03-23 Solano California 6095 87117 440
2330530 2330530 2022-03-22 Solano California 6095 86929 441
2327278 2327278 2022-03-21 Solano California 6095 86923 441
2324025 2324025 2022-03-20 Solano California 6095 86870 441
2320771 2320771 2022-03-19 Solano California 6095 86870 441
2317517 2317517 2022-03-18 Solano California 6095 86870 441
2314264 2314264 2022-03-17 Solano California 6095 86807 440
2311011 2311011 2022-03-16 Solano California 6095 86736 440
2307758 2307758 2022-03-15 Solano California 6095 86709 440
2304507 2304507 2022-03-14 Solano California 6095 86693 440
2301255 2301255 2022-03-13 Solano California 6095 86534 436
2298003 2298003 2022-03-12 Solano California 6095 86534 436
2294751 2294751 2022-03-11 Solano California 6095 86534 436
2291499 2291499 2022-03-10 Solano California 6095 86460 436
2288247 2288247 2022-03-09 Solano California 6095 86356 434
2284996 2284996 2022-03-08 Solano California 6095 86318 435
2281744 2281744 2022-03-07 Solano California 6095 86265 435
2278491 2278491 2022-03-06 Solano California 6095 86122 435
2275238 2275238 2022-03-05 Solano California 6095 86122 435
2271985 2271985 2022-03-04 Solano California 6095 86122 435
2268733 2268733 2022-03-03 Solano California 6095 86058 433
2265480 2265480 2022-03-02 Solano California 6095 85968 434
2262229 2262229 2022-03-01 Solano California 6095 85956 430
2258978 2258978 2022-02-28 Solano California 6095 85927 430
2255727 2255727 2022-02-27 Solano California 6095 85637 428
2252476 2252476 2022-02-26 Solano California 6095 85637 428
2249225 2249225 2022-02-25 Solano California 6095 85637 428
2245974 2245974 2022-02-24 Solano California 6095 85515 427
2242723 2242723 2022-02-23 Solano California 6095 85164 425
2239472 2239472 2022-02-22 Solano California 6095 85102 425
2236221 2236221 2022-02-21 Solano California 6095 84110 424
2232970 2232970 2022-02-20 Solano California 6095 84110 424
2229719 2229719 2022-02-19 Solano California 6095 84110 424
2226468 2226468 2022-02-18 Solano California 6095 84110 424
2223217 2223217 2022-02-17 Solano California 6095 83938 422
2219966 2219966 2022-02-16 Solano California 6095 83874 426
2216715 2216715 2022-02-15 Solano California 6095 83781 427
2213464 2213464 2022-02-14 Solano California 6095 83672 426
2210212 2210212 2022-02-13 Solano California 6095 83113 424
2206959 2206959 2022-02-12 Solano California 6095 83113 424
2203706 2203706 2022-02-11 Solano California 6095 83113 424
2200453 2200453 2022-02-10 Solano California 6095 82547 421
2197199 2197199 2022-02-09 Solano California 6095 82215 421
2193944 2193944 2022-02-08 Solano California 6095 79118 420
2190691 2190691 2022-02-07 Solano California 6095 78659 419
2187438 2187438 2022-02-06 Solano California 6095 78296 415
2184185 2184185 2022-02-05 Solano California 6095 78296 415
2180933 2180933 2022-02-04 Solano California 6095 78296 415
2177682 2177682 2022-02-03 Solano California 6095 77895 414

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 47.993ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette