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

806 rows where fips = 53033 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Washington 806

fips 1

  • 53033 · 806 ✖

county 1

  • King 806
Link rowid date ▲ county state fips cases deaths
2502659 2502659 2022-05-13 King Washington 53033 410322 2774
2499401 2499401 2022-05-12 King Washington 53033 407538 2765
2496143 2496143 2022-05-11 King Washington 53033 407538 2765
2492885 2492885 2022-05-10 King Washington 53033 405165 2757
2489627 2489627 2022-05-09 King Washington 53033 405165 2757
2486370 2486370 2022-05-08 King Washington 53033 402422 2754
2483112 2483112 2022-05-07 King Washington 53033 402422 2754
2479854 2479854 2022-05-06 King Washington 53033 402422 2754
2476596 2476596 2022-05-05 King Washington 53033 400183 2750
2473338 2473338 2022-05-04 King Washington 53033 400183 2750
2470082 2470082 2022-05-03 King Washington 53033 400290 2741
2466826 2466826 2022-05-02 King Washington 53033 400290 2741
2463571 2463571 2022-05-01 King Washington 53033 395392 2740
2460315 2460315 2022-04-30 King Washington 53033 395392 2740
2457059 2457059 2022-04-29 King Washington 53033 395392 2740
2453803 2453803 2022-04-28 King Washington 53033 393274 2736
2450547 2450547 2022-04-27 King Washington 53033 393274 2736
2447291 2447291 2022-04-26 King Washington 53033 391842 2735
2444035 2444035 2022-04-25 King Washington 53033 391842 2735
2440779 2440779 2022-04-24 King Washington 53033 388710 2733
2437523 2437523 2022-04-23 King Washington 53033 388710 2733
2434267 2434267 2022-04-22 King Washington 53033 388710 2733
2431011 2431011 2022-04-21 King Washington 53033 386808 2730
2427755 2427755 2022-04-20 King Washington 53033 386808 2730
2424499 2424499 2022-04-19 King Washington 53033 386023 2724
2421243 2421243 2022-04-18 King Washington 53033 386023 2724
2417987 2417987 2022-04-17 King Washington 53033 384353 2724
2414731 2414731 2022-04-16 King Washington 53033 384353 2724
2411475 2411475 2022-04-15 King Washington 53033 384353 2724
2408219 2408219 2022-04-14 King Washington 53033 382806 2717
2404963 2404963 2022-04-13 King Washington 53033 382806 2717
2401708 2401708 2022-04-12 King Washington 53033 381614 2716
2398453 2398453 2022-04-11 King Washington 53033 381614 2716
2395198 2395198 2022-04-10 King Washington 53033 380229 2712
2391942 2391942 2022-04-09 King Washington 53033 380229 2712
2388686 2388686 2022-04-08 King Washington 53033 380229 2712
2385431 2385431 2022-04-07 King Washington 53033 378891 2706
2382176 2382176 2022-04-06 King Washington 53033 378891 2706
2378921 2378921 2022-04-05 King Washington 53033 375676 2705
2375667 2375667 2022-04-04 King Washington 53033 375676 2705
2372415 2372415 2022-04-03 King Washington 53033 374748 2703
2369162 2369162 2022-04-02 King Washington 53033 374748 2703
2365909 2365909 2022-04-01 King Washington 53033 374748 2703
2362656 2362656 2022-03-31 King Washington 53033 373931 2699
2359402 2359402 2022-03-30 King Washington 53033 373931 2699
2356148 2356148 2022-03-29 King Washington 53033 373239 2690
2352895 2352895 2022-03-28 King Washington 53033 373239 2690
2349643 2349643 2022-03-27 King Washington 53033 372411 2684
2346390 2346390 2022-03-26 King Washington 53033 372411 2684
2343137 2343137 2022-03-25 King Washington 53033 372411 2684
2339884 2339884 2022-03-24 King Washington 53033 371678 2679
2336631 2336631 2022-03-23 King Washington 53033 371678 2679
2333377 2333377 2022-03-22 King Washington 53033 371216 2658
2330123 2330123 2022-03-21 King Washington 53033 371216 2658
2326871 2326871 2022-03-20 King Washington 53033 370694 2659
2323618 2323618 2022-03-19 King Washington 53033 370694 2659
2320364 2320364 2022-03-18 King Washington 53033 370694 2659
2317110 2317110 2022-03-17 King Washington 53033 370114 2649
2313857 2313857 2022-03-16 King Washington 53033 370114 2649
2310604 2310604 2022-03-15 King Washington 53033 369599 2635
2307351 2307351 2022-03-14 King Washington 53033 369599 2635
2304100 2304100 2022-03-13 King Washington 53033 369046 2631
2300848 2300848 2022-03-12 King Washington 53033 369046 2631
2297596 2297596 2022-03-11 King Washington 53033 369046 2631
2294344 2294344 2022-03-10 King Washington 53033 368391 2620
2291092 2291092 2022-03-09 King Washington 53033 368391 2620
2287840 2287840 2022-03-08 King Washington 53033 367807 2593
2284588 2284588 2022-03-07 King Washington 53033 367807 2593
2281336 2281336 2022-03-06 King Washington 53033 367328 2593
2278083 2278083 2022-03-05 King Washington 53033 367328 2593
2274830 2274830 2022-03-04 King Washington 53033 367328 2593
2271577 2271577 2022-03-03 King Washington 53033 366645 2577
2268325 2268325 2022-03-02 King Washington 53033 366645 2577
2265072 2265072 2022-03-01 King Washington 53033 365873 2569
2261822 2261822 2022-02-28 King Washington 53033 365873 2569
2258571 2258571 2022-02-27 King Washington 53033 364955 2553
2255320 2255320 2022-02-26 King Washington 53033 364955 2553
2252069 2252069 2022-02-25 King Washington 53033 364955 2553
2248818 2248818 2022-02-24 King Washington 53033 364846 2540
2245567 2245567 2022-02-23 King Washington 53033 364481 2541
2242316 2242316 2022-02-22 King Washington 53033 364445 2532
2239065 2239065 2022-02-21 King Washington 53033 362616 2526
2235814 2235814 2022-02-20 King Washington 53033 362616 2526
2232563 2232563 2022-02-19 King Washington 53033 362616 2526
2229312 2229312 2022-02-18 King Washington 53033 362616 2526
2226061 2226061 2022-02-17 King Washington 53033 362256 2517
2222810 2222810 2022-02-16 King Washington 53033 362022 2500
2219559 2219559 2022-02-15 King Washington 53033 361829 2484
2216309 2216309 2022-02-14 King Washington 53033 361948 2484
2213058 2213058 2022-02-13 King Washington 53033 361215 2467
2209805 2209805 2022-02-12 King Washington 53033 361215 2467
2206552 2206552 2022-02-11 King Washington 53033 361215 2467
2203299 2203299 2022-02-10 King Washington 53033 360425 2453
2200045 2200045 2022-02-09 King Washington 53033 357858 2447
2196791 2196791 2022-02-08 King Washington 53033 356460 2431
2193536 2193536 2022-02-07 King Washington 53033 356001 2419
2190283 2190283 2022-02-06 King Washington 53033 351932 2401
2187030 2187030 2022-02-05 King Washington 53033 351932 2401
2183777 2183777 2022-02-04 King Washington 53033 351932 2401
2180525 2180525 2022-02-03 King Washington 53033 350701 2394

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