ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
822 rows where fips = 48029 sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-02-12 1
- 2020-02-13 1
- 2020-02-14 1
- 2020-02-15 1
- 2020-02-16 1
- 2020-02-17 1
- 2020-02-18 1
- 2020-02-19 1
- 2020-02-20 1
- 2020-02-21 1
- 2020-02-22 1
- 2020-02-23 1
- 2020-02-24 1
- 2020-02-25 1
- 2020-02-26 1
- 2020-02-27 1
- 2020-02-28 1
- 2020-02-29 1
- 2020-03-01 1
- 2020-03-02 1
- 2020-03-03 1
- 2020-03-04 1
- 2020-03-05 1
- 2020-03-06 1
- 2020-03-07 1
- 2020-03-08 1
- 2020-03-09 1
- 2020-03-10 1
- 2020-03-11 1
- 2020-03-12 1
- …
state 1
- Texas 822
fips 1
- 48029 · 822 ✖
county 1
- Bexar 822
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
144 | 144 | 2020-02-12 | Bexar | Texas | 48029 | 1 | 0 |
155 | 155 | 2020-02-13 | Bexar | Texas | 48029 | 2 | 0 |
166 | 166 | 2020-02-14 | Bexar | Texas | 48029 | 2 | 0 |
177 | 177 | 2020-02-15 | Bexar | Texas | 48029 | 2 | 0 |
188 | 188 | 2020-02-16 | Bexar | Texas | 48029 | 2 | 0 |
200 | 200 | 2020-02-17 | Bexar | Texas | 48029 | 2 | 0 |
212 | 212 | 2020-02-18 | Bexar | Texas | 48029 | 2 | 0 |
224 | 224 | 2020-02-19 | Bexar | Texas | 48029 | 2 | 0 |
237 | 237 | 2020-02-20 | Bexar | Texas | 48029 | 2 | 0 |
251 | 251 | 2020-02-21 | Bexar | Texas | 48029 | 4 | 0 |
265 | 265 | 2020-02-22 | Bexar | Texas | 48029 | 4 | 0 |
279 | 279 | 2020-02-23 | Bexar | Texas | 48029 | 4 | 0 |
294 | 294 | 2020-02-24 | Bexar | Texas | 48029 | 10 | 0 |
310 | 310 | 2020-02-25 | Bexar | Texas | 48029 | 10 | 0 |
330 | 330 | 2020-02-26 | Bexar | Texas | 48029 | 10 | 0 |
350 | 350 | 2020-02-27 | Bexar | Texas | 48029 | 10 | 0 |
371 | 371 | 2020-02-28 | Bexar | Texas | 48029 | 11 | 0 |
393 | 393 | 2020-02-29 | Bexar | Texas | 48029 | 11 | 0 |
420 | 420 | 2020-03-01 | Bexar | Texas | 48029 | 11 | 0 |
452 | 452 | 2020-03-02 | Bexar | Texas | 48029 | 11 | 0 |
487 | 487 | 2020-03-03 | Bexar | Texas | 48029 | 11 | 0 |
524 | 524 | 2020-03-04 | Bexar | Texas | 48029 | 11 | 0 |
572 | 572 | 2020-03-05 | Bexar | Texas | 48029 | 11 | 0 |
641 | 641 | 2020-03-06 | Bexar | Texas | 48029 | 11 | 0 |
733 | 733 | 2020-03-07 | Bexar | Texas | 48029 | 11 | 0 |
845 | 845 | 2020-03-08 | Bexar | Texas | 48029 | 11 | 0 |
974 | 974 | 2020-03-09 | Bexar | Texas | 48029 | 11 | 0 |
1132 | 1132 | 2020-03-10 | Bexar | Texas | 48029 | 11 | 0 |
1328 | 1328 | 2020-03-11 | Bexar | Texas | 48029 | 11 | 0 |
1575 | 1575 | 2020-03-12 | Bexar | Texas | 48029 | 11 | 0 |
1880 | 1880 | 2020-03-13 | Bexar | Texas | 48029 | 11 | 0 |
2245 | 2245 | 2020-03-14 | Bexar | Texas | 48029 | 12 | 0 |
2670 | 2670 | 2020-03-15 | Bexar | Texas | 48029 | 12 | 0 |
3137 | 3137 | 2020-03-16 | Bexar | Texas | 48029 | 13 | 0 |
3670 | 3670 | 2020-03-17 | Bexar | Texas | 48029 | 13 | 0 |
4293 | 4293 | 2020-03-18 | Bexar | Texas | 48029 | 13 | 0 |
5044 | 5044 | 2020-03-19 | Bexar | Texas | 48029 | 17 | 0 |
5933 | 5933 | 2020-03-20 | Bexar | Texas | 48029 | 40 | 0 |
6951 | 6951 | 2020-03-21 | Bexar | Texas | 48029 | 50 | 0 |
8081 | 8081 | 2020-03-22 | Bexar | Texas | 48029 | 50 | 1 |
9299 | 9299 | 2020-03-23 | Bexar | Texas | 48029 | 50 | 1 |
10633 | 10633 | 2020-03-24 | Bexar | Texas | 48029 | 68 | 1 |
12115 | 12115 | 2020-03-25 | Bexar | Texas | 48029 | 69 | 1 |
13743 | 13743 | 2020-03-26 | Bexar | Texas | 48029 | 84 | 3 |
15496 | 15496 | 2020-03-27 | Bexar | Texas | 48029 | 113 | 5 |
17363 | 17363 | 2020-03-28 | Bexar | Texas | 48029 | 125 | 5 |
19313 | 19313 | 2020-03-29 | Bexar | Texas | 48029 | 140 | 5 |
21372 | 21372 | 2020-03-30 | Bexar | Texas | 48029 | 157 | 5 |
23511 | 23511 | 2020-03-31 | Bexar | Texas | 48029 | 207 | 9 |
25715 | 25715 | 2020-04-01 | Bexar | Texas | 48029 | 229 | 9 |
27995 | 27995 | 2020-04-02 | Bexar | Texas | 48029 | 254 | 9 |
30330 | 30330 | 2020-04-03 | Bexar | Texas | 48029 | 342 | 10 |
32723 | 32723 | 2020-04-04 | Bexar | Texas | 48029 | 395 | 11 |
35161 | 35161 | 2020-04-05 | Bexar | Texas | 48029 | 421 | 11 |
37637 | 37637 | 2020-04-06 | Bexar | Texas | 48029 | 467 | 12 |
40159 | 40159 | 2020-04-07 | Bexar | Texas | 48029 | 514 | 18 |
42722 | 42722 | 2020-04-08 | Bexar | Texas | 48029 | 514 | 18 |
45311 | 45311 | 2020-04-09 | Bexar | Texas | 48029 | 626 | 22 |
47929 | 47929 | 2020-04-10 | Bexar | Texas | 48029 | 676 | 24 |
50586 | 50586 | 2020-04-11 | Bexar | Texas | 48029 | 723 | 24 |
53261 | 53261 | 2020-04-12 | Bexar | Texas | 48029 | 734 | 27 |
55949 | 55949 | 2020-04-13 | Bexar | Texas | 48029 | 783 | 27 |
58653 | 58653 | 2020-04-14 | Bexar | Texas | 48029 | 805 | 33 |
61369 | 61369 | 2020-04-15 | Bexar | Texas | 48029 | 901 | 37 |
64096 | 64096 | 2020-04-16 | Bexar | Texas | 48029 | 901 | 37 |
66843 | 66843 | 2020-04-17 | Bexar | Texas | 48029 | 970 | 37 |
69602 | 69602 | 2020-04-18 | Bexar | Texas | 48029 | 1003 | 38 |
72369 | 72369 | 2020-04-19 | Bexar | Texas | 48029 | 1015 | 39 |
75144 | 75144 | 2020-04-20 | Bexar | Texas | 48029 | 1040 | 39 |
77926 | 77926 | 2020-04-21 | Bexar | Texas | 48029 | 1080 | 39 |
80716 | 80716 | 2020-04-22 | Bexar | Texas | 48029 | 1126 | 39 |
83515 | 83515 | 2020-04-23 | Bexar | Texas | 48029 | 1178 | 43 |
86320 | 86320 | 2020-04-24 | Bexar | Texas | 48029 | 1206 | 43 |
89135 | 89135 | 2020-04-25 | Bexar | Texas | 48029 | 1243 | 43 |
91952 | 91952 | 2020-04-26 | Bexar | Texas | 48029 | 1254 | 43 |
94780 | 94780 | 2020-04-27 | Bexar | Texas | 48029 | 1287 | 44 |
97620 | 97620 | 2020-04-28 | Bexar | Texas | 48029 | 1307 | 44 |
100470 | 100470 | 2020-04-29 | Bexar | Texas | 48029 | 1326 | 46 |
103323 | 103323 | 2020-04-30 | Bexar | Texas | 48029 | 1374 | 48 |
106186 | 106186 | 2020-05-01 | Bexar | Texas | 48029 | 1489 | 48 |
109053 | 109053 | 2020-05-02 | Bexar | Texas | 48029 | 1585 | 48 |
111927 | 111927 | 2020-05-03 | Bexar | Texas | 48029 | 1625 | 48 |
114809 | 114809 | 2020-05-04 | Bexar | Texas | 48029 | 1664 | 48 |
117766 | 117766 | 2020-05-05 | Bexar | Texas | 48029 | 1689 | 52 |
120730 | 120730 | 2020-05-06 | Bexar | Texas | 48029 | 1761 | 53 |
123709 | 123709 | 2020-05-07 | Bexar | Texas | 48029 | 1805 | 54 |
126692 | 126692 | 2020-05-08 | Bexar | Texas | 48029 | 1835 | 56 |
129681 | 129681 | 2020-05-09 | Bexar | Texas | 48029 | 1887 | 56 |
132671 | 132671 | 2020-05-10 | Bexar | Texas | 48029 | 1901 | 56 |
135662 | 135662 | 2020-05-11 | Bexar | Texas | 48029 | 1920 | 57 |
138652 | 138652 | 2020-05-12 | Bexar | Texas | 48029 | 1942 | 57 |
141648 | 141648 | 2020-05-13 | Bexar | Texas | 48029 | 1976 | 58 |
144645 | 144645 | 2020-05-14 | Bexar | Texas | 48029 | 2041 | 59 |
147647 | 147647 | 2020-05-15 | Bexar | Texas | 48029 | 2120 | 62 |
150655 | 150655 | 2020-05-16 | Bexar | Texas | 48029 | 2120 | 62 |
153666 | 153666 | 2020-05-17 | Bexar | Texas | 48029 | 2120 | 62 |
156683 | 156683 | 2020-05-18 | Bexar | Texas | 48029 | 2192 | 62 |
159705 | 159705 | 2020-05-19 | Bexar | Texas | 48029 | 2278 | 62 |
162732 | 162732 | 2020-05-20 | Bexar | Texas | 48029 | 2322 | 63 |
165761 | 165761 | 2020-05-21 | Bexar | Texas | 48029 | 2371 | 64 |
Advanced export
JSON shape: default, array, newline-delimited
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);