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

822 rows where fips = 48029 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Texas 822

fips 1

  • 48029 · 822 ✖

county 1

  • Bexar 822
Link rowid date ▲ county state fips cases deaths
2502221 2502221 2022-05-13 Bexar Texas 48029 565111 6131
2498963 2498963 2022-05-12 Bexar Texas 48029 564722 6129
2495705 2495705 2022-05-11 Bexar Texas 48029 564350 6127
2492447 2492447 2022-05-10 Bexar Texas 48029 564018 6127
2489189 2489189 2022-05-09 Bexar Texas 48029 563679 6126
2485932 2485932 2022-05-08 Bexar Texas 48029 563508 6127
2482674 2482674 2022-05-07 Bexar Texas 48029 563315 6127
2479416 2479416 2022-05-06 Bexar Texas 48029 563014 6126
2476158 2476158 2022-05-05 Bexar Texas 48029 562708 6124
2472901 2472901 2022-05-04 Bexar Texas 48029 562471 6124
2469645 2469645 2022-05-03 Bexar Texas 48029 562259 6123
2466389 2466389 2022-05-02 Bexar Texas 48029 562018 6123
2463134 2463134 2022-05-01 Bexar Texas 48029 561892 6123
2459878 2459878 2022-04-30 Bexar Texas 48029 561726 6123
2456622 2456622 2022-04-29 Bexar Texas 48029 561401 6122
2453366 2453366 2022-04-28 Bexar Texas 48029 561122 6121
2450110 2450110 2022-04-27 Bexar Texas 48029 560772 6121
2446853 2446853 2022-04-26 Bexar Texas 48029 560455 6120
2443598 2443598 2022-04-25 Bexar Texas 48029 560200 6120
2440342 2440342 2022-04-24 Bexar Texas 48029 560085 6120
2437086 2437086 2022-04-23 Bexar Texas 48029 559941 6120
2433830 2433830 2022-04-22 Bexar Texas 48029 559708 6118
2430574 2430574 2022-04-21 Bexar Texas 48029 559395 6118
2427318 2427318 2022-04-20 Bexar Texas 48029 559154 6117
2424062 2424062 2022-04-19 Bexar Texas 48029 558922 6117
2420806 2420806 2022-04-18 Bexar Texas 48029 558662 6112
2417550 2417550 2022-04-17 Bexar Texas 48029 557963 6111
2414294 2414294 2022-04-16 Bexar Texas 48029 557963 6111
2411038 2411038 2022-04-15 Bexar Texas 48029 557963 6111
2407782 2407782 2022-04-14 Bexar Texas 48029 557963 6111
2404526 2404526 2022-04-13 Bexar Texas 48029 557710 6109
2401271 2401271 2022-04-12 Bexar Texas 48029 557456 6105
2398016 2398016 2022-04-11 Bexar Texas 48029 557213 6103
2394761 2394761 2022-04-10 Bexar Texas 48029 557147 6103
2391505 2391505 2022-04-09 Bexar Texas 48029 557072 6104
2388249 2388249 2022-04-08 Bexar Texas 48029 556988 6102
2384994 2384994 2022-04-07 Bexar Texas 48029 556782 6101
2381739 2381739 2022-04-06 Bexar Texas 48029 556552 6097
2378484 2378484 2022-04-05 Bexar Texas 48029 556312 6094
2375230 2375230 2022-04-04 Bexar Texas 48029 556055 6092
2371978 2371978 2022-04-03 Bexar Texas 48029 555976 6091
2368725 2368725 2022-04-02 Bexar Texas 48029 555890 6089
2365472 2365472 2022-04-01 Bexar Texas 48029 555738 6087
2362219 2362219 2022-03-31 Bexar Texas 48029 555651 6084
2358965 2358965 2022-03-30 Bexar Texas 48029 555452 6080
2355711 2355711 2022-03-29 Bexar Texas 48029 555291 6075
2352458 2352458 2022-03-28 Bexar Texas 48029 555008 6071
2349206 2349206 2022-03-27 Bexar Texas 48029 554992 6071
2345953 2345953 2022-03-26 Bexar Texas 48029 554964 6069
2342700 2342700 2022-03-25 Bexar Texas 48029 552514 6066
2339447 2339447 2022-03-24 Bexar Texas 48029 552157 6058
2336193 2336193 2022-03-23 Bexar Texas 48029 551869 6049
2332939 2332939 2022-03-22 Bexar Texas 48029 551603 6042
2329686 2329686 2022-03-21 Bexar Texas 48029 551429 6037
2326434 2326434 2022-03-20 Bexar Texas 48029 551384 6036
2323181 2323181 2022-03-19 Bexar Texas 48029 551258 6036
2319927 2319927 2022-03-18 Bexar Texas 48029 551177 6029
2316673 2316673 2022-03-17 Bexar Texas 48029 550886 6020
2313420 2313420 2022-03-16 Bexar Texas 48029 550651 6015
2310167 2310167 2022-03-15 Bexar Texas 48029 550386 6003
2306914 2306914 2022-03-14 Bexar Texas 48029 550137 6001
2303663 2303663 2022-03-13 Bexar Texas 48029 550078 6001
2300411 2300411 2022-03-12 Bexar Texas 48029 549990 5999
2297159 2297159 2022-03-11 Bexar Texas 48029 549669 5990
2293907 2293907 2022-03-10 Bexar Texas 48029 548413 5983
2290655 2290655 2022-03-09 Bexar Texas 48029 547710 5975
2287403 2287403 2022-03-08 Bexar Texas 48029 547096 5959
2284151 2284151 2022-03-07 Bexar Texas 48029 546417 5956
2280899 2280899 2022-03-06 Bexar Texas 48029 546219 5956
2277646 2277646 2022-03-05 Bexar Texas 48029 546165 5956
2274393 2274393 2022-03-04 Bexar Texas 48029 545702 5950
2271140 2271140 2022-03-03 Bexar Texas 48029 545340 5934
2267888 2267888 2022-03-02 Bexar Texas 48029 544984 5926
2264635 2264635 2022-03-01 Bexar Texas 48029 544615 5913
2261385 2261385 2022-02-28 Bexar Texas 48029 544104 5904
2258134 2258134 2022-02-27 Bexar Texas 48029 543450 5902
2254883 2254883 2022-02-26 Bexar Texas 48029 543350 5895
2251632 2251632 2022-02-25 Bexar Texas 48029 542930 5882
2248381 2248381 2022-02-24 Bexar Texas 48029 542472 5871
2245130 2245130 2022-02-23 Bexar Texas 48029 541961 5850
2241879 2241879 2022-02-22 Bexar Texas 48029 541581 5825
2238628 2238628 2022-02-21 Bexar Texas 48029 540858 5812
2235377 2235377 2022-02-20 Bexar Texas 48029 540487 5812
2232126 2232126 2022-02-19 Bexar Texas 48029 540313 5809
2228875 2228875 2022-02-18 Bexar Texas 48029 539172 5789
2225624 2225624 2022-02-17 Bexar Texas 48029 538648 5776
2222373 2222373 2022-02-16 Bexar Texas 48029 537781 5762
2219122 2219122 2022-02-15 Bexar Texas 48029 537149 5739
2215871 2215871 2022-02-14 Bexar Texas 48029 535791 5724
2212620 2212620 2022-02-13 Bexar Texas 48029 535332 5722
2209367 2209367 2022-02-12 Bexar Texas 48029 534410 5706
2206114 2206114 2022-02-11 Bexar Texas 48029 533372 5686
2202861 2202861 2022-02-10 Bexar Texas 48029 532001 5665
2199607 2199607 2022-02-09 Bexar Texas 48029 530179 5645
2196353 2196353 2022-02-08 Bexar Texas 48029 529136 5629
2193099 2193099 2022-02-07 Bexar Texas 48029 527675 5612
2189845 2189845 2022-02-06 Bexar Texas 48029 525923 5610
2186592 2186592 2022-02-05 Bexar Texas 48029 523514 5611
2183340 2183340 2022-02-04 Bexar Texas 48029 521501 5601
2180088 2180088 2022-02-03 Bexar Texas 48029 519321 5592

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