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

839 rows where fips = 4013 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Arizona 839

fips 1

  • 4013 · 839 ✖

county 1

  • Maricopa 839
Link rowid date ▲ county state fips cases deaths
2499678 2499678 2022-05-13 Maricopa Arizona 4013 1283590 17326
2496420 2496420 2022-05-12 Maricopa Arizona 4013 1283590 17326
2493162 2493162 2022-05-11 Maricopa Arizona 4013 1283590 17326
2489904 2489904 2022-05-10 Maricopa Arizona 4013 1279872 17305
2486647 2486647 2022-05-09 Maricopa Arizona 4013 1279872 17305
2483389 2483389 2022-05-08 Maricopa Arizona 4013 1279872 17305
2480131 2480131 2022-05-07 Maricopa Arizona 4013 1279872 17305
2476873 2476873 2022-05-06 Maricopa Arizona 4013 1279872 17305
2473615 2473615 2022-05-05 Maricopa Arizona 4013 1279872 17305
2470358 2470358 2022-05-04 Maricopa Arizona 4013 1279872 17305
2467102 2467102 2022-05-03 Maricopa Arizona 4013 1277230 17153
2463847 2463847 2022-05-02 Maricopa Arizona 4013 1277230 17153
2460591 2460591 2022-05-01 Maricopa Arizona 4013 1277230 17153
2457335 2457335 2022-04-30 Maricopa Arizona 4013 1277230 17153
2454079 2454079 2022-04-29 Maricopa Arizona 4013 1277230 17153
2450823 2450823 2022-04-28 Maricopa Arizona 4013 1277230 17153
2447567 2447567 2022-04-27 Maricopa Arizona 4013 1277230 17153
2444311 2444311 2022-04-26 Maricopa Arizona 4013 1275525 17103
2441055 2441055 2022-04-25 Maricopa Arizona 4013 1275525 17103
2437799 2437799 2022-04-24 Maricopa Arizona 4013 1275525 17103
2434543 2434543 2022-04-23 Maricopa Arizona 4013 1275525 17103
2431287 2431287 2022-04-22 Maricopa Arizona 4013 1275525 17103
2428031 2428031 2022-04-21 Maricopa Arizona 4013 1275525 17103
2424775 2424775 2022-04-20 Maricopa Arizona 4013 1275525 17103
2421519 2421519 2022-04-19 Maricopa Arizona 4013 1273651 17079
2418263 2418263 2022-04-18 Maricopa Arizona 4013 1273651 17079
2415007 2415007 2022-04-17 Maricopa Arizona 4013 1273651 17079
2411751 2411751 2022-04-16 Maricopa Arizona 4013 1273651 17079
2408495 2408495 2022-04-15 Maricopa Arizona 4013 1273651 17079
2405239 2405239 2022-04-14 Maricopa Arizona 4013 1273651 17079
2401984 2401984 2022-04-13 Maricopa Arizona 4013 1273651 17079
2398729 2398729 2022-04-12 Maricopa Arizona 4013 1272999 17004
2395474 2395474 2022-04-11 Maricopa Arizona 4013 1272999 17004
2392218 2392218 2022-04-10 Maricopa Arizona 4013 1272999 17004
2388962 2388962 2022-04-09 Maricopa Arizona 4013 1272999 17004
2385707 2385707 2022-04-08 Maricopa Arizona 4013 1272999 17004
2382452 2382452 2022-04-07 Maricopa Arizona 4013 1272999 17004
2379197 2379197 2022-04-06 Maricopa Arizona 4013 1272999 17004
2375943 2375943 2022-04-05 Maricopa Arizona 4013 1268293 16686
2372691 2372691 2022-04-04 Maricopa Arizona 4013 1268293 16686
2369438 2369438 2022-04-03 Maricopa Arizona 4013 1268293 16686
2366185 2366185 2022-04-02 Maricopa Arizona 4013 1268293 16686
2362932 2362932 2022-04-01 Maricopa Arizona 4013 1268293 16686
2359678 2359678 2022-03-31 Maricopa Arizona 4013 1268293 16686
2356424 2356424 2022-03-30 Maricopa Arizona 4013 1268293 16686
2353171 2353171 2022-03-29 Maricopa Arizona 4013 1260012 16393
2349919 2349919 2022-03-28 Maricopa Arizona 4013 1260012 16393
2346666 2346666 2022-03-27 Maricopa Arizona 4013 1260012 16393
2343413 2343413 2022-03-26 Maricopa Arizona 4013 1260012 16393
2340160 2340160 2022-03-25 Maricopa Arizona 4013 1260012 16393
2336907 2336907 2022-03-24 Maricopa Arizona 4013 1260012 16393
2333653 2333653 2022-03-23 Maricopa Arizona 4013 1260012 16393
2330399 2330399 2022-03-22 Maricopa Arizona 4013 1256653 16166
2327147 2327147 2022-03-21 Maricopa Arizona 4013 1256653 16166
2323894 2323894 2022-03-20 Maricopa Arizona 4013 1256653 16166
2320640 2320640 2022-03-19 Maricopa Arizona 4013 1256653 16166
2317386 2317386 2022-03-18 Maricopa Arizona 4013 1256653 16166
2314133 2314133 2022-03-17 Maricopa Arizona 4013 1256653 16166
2310880 2310880 2022-03-16 Maricopa Arizona 4013 1256653 16166
2307627 2307627 2022-03-15 Maricopa Arizona 4013 1253285 15855
2304376 2304376 2022-03-14 Maricopa Arizona 4013 1253285 15855
2301124 2301124 2022-03-13 Maricopa Arizona 4013 1253285 15855
2297872 2297872 2022-03-12 Maricopa Arizona 4013 1253285 15855
2294620 2294620 2022-03-11 Maricopa Arizona 4013 1253285 15855
2291368 2291368 2022-03-10 Maricopa Arizona 4013 1253285 15855
2288116 2288116 2022-03-09 Maricopa Arizona 4013 1253285 15855
2284864 2284864 2022-03-08 Maricopa Arizona 4013 1248818 15761
2281612 2281612 2022-03-07 Maricopa Arizona 4013 1248818 15761
2278359 2278359 2022-03-06 Maricopa Arizona 4013 1248818 15761
2275106 2275106 2022-03-05 Maricopa Arizona 4013 1248818 15761
2271853 2271853 2022-03-04 Maricopa Arizona 4013 1248818 15761
2268601 2268601 2022-03-03 Maricopa Arizona 4013 1248818 15761
2265348 2265348 2022-03-02 Maricopa Arizona 4013 1248818 15761
2262098 2262098 2022-03-01 Maricopa Arizona 4013 1246178 15761
2258847 2258847 2022-02-28 Maricopa Arizona 4013 1246178 15761
2255596 2255596 2022-02-27 Maricopa Arizona 4013 1246178 15761
2252345 2252345 2022-02-26 Maricopa Arizona 4013 1246178 15761
2249094 2249094 2022-02-25 Maricopa Arizona 4013 1245088 15753
2245843 2245843 2022-02-24 Maricopa Arizona 4013 1243994 15710
2242592 2242592 2022-02-23 Maricopa Arizona 4013 1242703 15661
2239341 2239341 2022-02-22 Maricopa Arizona 4013 1242071 15631
2236090 2236090 2022-02-21 Maricopa Arizona 4013 1240498 15563
2232839 2232839 2022-02-20 Maricopa Arizona 4013 1240505 15563
2229588 2229588 2022-02-19 Maricopa Arizona 4013 1239274 15562
2226337 2226337 2022-02-18 Maricopa Arizona 4013 1237579 15486
2223086 2223086 2022-02-17 Maricopa Arizona 4013 1235746 15424
2219835 2219835 2022-02-16 Maricopa Arizona 4013 1234151 15321
2216584 2216584 2022-02-15 Maricopa Arizona 4013 1233036 15320
2213333 2213333 2022-02-14 Maricopa Arizona 4013 1232073 15320
2210081 2210081 2022-02-13 Maricopa Arizona 4013 1230503 15320
2206828 2206828 2022-02-12 Maricopa Arizona 4013 1227972 15308
2203575 2203575 2022-02-11 Maricopa Arizona 4013 1225561 15256
2200321 2200321 2022-02-10 Maricopa Arizona 4013 1223947 15219
2197067 2197067 2022-02-09 Maricopa Arizona 4013 1219818 15100
2193812 2193812 2022-02-08 Maricopa Arizona 4013 1216724 15087
2190559 2190559 2022-02-07 Maricopa Arizona 4013 1214267 14987
2187306 2187306 2022-02-06 Maricopa Arizona 4013 1211770 14987
2184053 2184053 2022-02-05 Maricopa Arizona 4013 1207881 14984
2180801 2180801 2022-02-04 Maricopa Arizona 4013 1203219 14936
2177550 2177550 2022-02-03 Maricopa Arizona 4013 1198179 14872

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