ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 48183 and state = "Texas" sorted by county descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1332 | 1332 | 2020-03-11 | Gregg | Texas | 48183 | 1 | 0 |
1579 | 1579 | 2020-03-12 | Gregg | Texas | 48183 | 1 | 0 |
1886 | 1886 | 2020-03-13 | Gregg | Texas | 48183 | 1 | 0 |
2252 | 2252 | 2020-03-14 | Gregg | Texas | 48183 | 1 | 0 |
2678 | 2678 | 2020-03-15 | Gregg | Texas | 48183 | 1 | 0 |
3146 | 3146 | 2020-03-16 | Gregg | Texas | 48183 | 1 | 0 |
3681 | 3681 | 2020-03-17 | Gregg | Texas | 48183 | 1 | 0 |
4304 | 4304 | 2020-03-18 | Gregg | Texas | 48183 | 1 | 0 |
5058 | 5058 | 2020-03-19 | Gregg | Texas | 48183 | 1 | 0 |
5950 | 5950 | 2020-03-20 | Gregg | Texas | 48183 | 1 | 0 |
6970 | 6970 | 2020-03-21 | Gregg | Texas | 48183 | 1 | 0 |
8100 | 8100 | 2020-03-22 | Gregg | Texas | 48183 | 1 | 0 |
9318 | 9318 | 2020-03-23 | Gregg | Texas | 48183 | 1 | 0 |
10656 | 10656 | 2020-03-24 | Gregg | Texas | 48183 | 1 | 0 |
12145 | 12145 | 2020-03-25 | Gregg | Texas | 48183 | 1 | 0 |
13774 | 13774 | 2020-03-26 | Gregg | Texas | 48183 | 3 | 0 |
15528 | 15528 | 2020-03-27 | Gregg | Texas | 48183 | 4 | 0 |
17397 | 17397 | 2020-03-28 | Gregg | Texas | 48183 | 4 | 0 |
19350 | 19350 | 2020-03-29 | Gregg | Texas | 48183 | 4 | 0 |
21409 | 21409 | 2020-03-30 | Gregg | Texas | 48183 | 5 | 0 |
23548 | 23548 | 2020-03-31 | Gregg | Texas | 48183 | 5 | 0 |
25758 | 25758 | 2020-04-01 | Gregg | Texas | 48183 | 6 | 0 |
28041 | 28041 | 2020-04-02 | Gregg | Texas | 48183 | 7 | 0 |
30376 | 30376 | 2020-04-03 | Gregg | Texas | 48183 | 8 | 0 |
32769 | 32769 | 2020-04-04 | Gregg | Texas | 48183 | 13 | 0 |
35207 | 35207 | 2020-04-05 | Gregg | Texas | 48183 | 13 | 0 |
37683 | 37683 | 2020-04-06 | Gregg | Texas | 48183 | 26 | 0 |
40208 | 40208 | 2020-04-07 | Gregg | Texas | 48183 | 26 | 0 |
42775 | 42775 | 2020-04-08 | Gregg | Texas | 48183 | 34 | 0 |
45364 | 45364 | 2020-04-09 | Gregg | Texas | 48183 | 37 | 0 |
47984 | 47984 | 2020-04-10 | Gregg | Texas | 48183 | 39 | 0 |
50642 | 50642 | 2020-04-11 | Gregg | Texas | 48183 | 39 | 0 |
53317 | 53317 | 2020-04-12 | Gregg | Texas | 48183 | 39 | 0 |
56005 | 56005 | 2020-04-13 | Gregg | Texas | 48183 | 39 | 0 |
58710 | 58710 | 2020-04-14 | Gregg | Texas | 48183 | 45 | 0 |
61428 | 61428 | 2020-04-15 | Gregg | Texas | 48183 | 46 | 0 |
64155 | 64155 | 2020-04-16 | Gregg | Texas | 48183 | 48 | 0 |
66902 | 66902 | 2020-04-17 | Gregg | Texas | 48183 | 48 | 0 |
69662 | 69662 | 2020-04-18 | Gregg | Texas | 48183 | 50 | 0 |
72430 | 72430 | 2020-04-19 | Gregg | Texas | 48183 | 51 | 0 |
75205 | 75205 | 2020-04-20 | Gregg | Texas | 48183 | 51 | 0 |
77987 | 77987 | 2020-04-21 | Gregg | Texas | 48183 | 52 | 0 |
80778 | 80778 | 2020-04-22 | Gregg | Texas | 48183 | 53 | 0 |
83578 | 83578 | 2020-04-23 | Gregg | Texas | 48183 | 55 | 0 |
86383 | 86383 | 2020-04-24 | Gregg | Texas | 48183 | 58 | 0 |
89198 | 89198 | 2020-04-25 | Gregg | Texas | 48183 | 58 | 0 |
92015 | 92015 | 2020-04-26 | Gregg | Texas | 48183 | 62 | 0 |
94844 | 94844 | 2020-04-27 | Gregg | Texas | 48183 | 66 | 0 |
97684 | 97684 | 2020-04-28 | Gregg | Texas | 48183 | 69 | 0 |
100534 | 100534 | 2020-04-29 | Gregg | Texas | 48183 | 69 | 0 |
103389 | 103389 | 2020-04-30 | Gregg | Texas | 48183 | 73 | 0 |
106253 | 106253 | 2020-05-01 | Gregg | Texas | 48183 | 80 | 0 |
109122 | 109122 | 2020-05-02 | Gregg | Texas | 48183 | 87 | 0 |
111996 | 111996 | 2020-05-03 | Gregg | Texas | 48183 | 87 | 0 |
114878 | 114878 | 2020-05-04 | Gregg | Texas | 48183 | 87 | 0 |
117837 | 117837 | 2020-05-05 | Gregg | Texas | 48183 | 97 | 0 |
120801 | 120801 | 2020-05-06 | Gregg | Texas | 48183 | 107 | 0 |
123780 | 123780 | 2020-05-07 | Gregg | Texas | 48183 | 109 | 0 |
126763 | 126763 | 2020-05-08 | Gregg | Texas | 48183 | 117 | 0 |
129752 | 129752 | 2020-05-09 | Gregg | Texas | 48183 | 117 | 0 |
132742 | 132742 | 2020-05-10 | Gregg | Texas | 48183 | 118 | 0 |
135733 | 135733 | 2020-05-11 | Gregg | Texas | 48183 | 118 | 0 |
138723 | 138723 | 2020-05-12 | Gregg | Texas | 48183 | 132 | 0 |
141719 | 141719 | 2020-05-13 | Gregg | Texas | 48183 | 136 | 0 |
144716 | 144716 | 2020-05-14 | Gregg | Texas | 48183 | 138 | 0 |
147719 | 147719 | 2020-05-15 | Gregg | Texas | 48183 | 142 | 0 |
150727 | 150727 | 2020-05-16 | Gregg | Texas | 48183 | 170 | 0 |
153738 | 153738 | 2020-05-17 | Gregg | Texas | 48183 | 170 | 0 |
156755 | 156755 | 2020-05-18 | Gregg | Texas | 48183 | 170 | 0 |
159777 | 159777 | 2020-05-19 | Gregg | Texas | 48183 | 173 | 0 |
162804 | 162804 | 2020-05-20 | Gregg | Texas | 48183 | 173 | 4 |
165833 | 165833 | 2020-05-21 | Gregg | Texas | 48183 | 180 | 4 |
168869 | 168869 | 2020-05-22 | Gregg | Texas | 48183 | 187 | 4 |
171908 | 171908 | 2020-05-23 | Gregg | Texas | 48183 | 187 | 4 |
174951 | 174951 | 2020-05-24 | Gregg | Texas | 48183 | 187 | 4 |
177995 | 177995 | 2020-05-25 | Gregg | Texas | 48183 | 187 | 4 |
181038 | 181038 | 2020-05-26 | Gregg | Texas | 48183 | 204 | 5 |
184088 | 184088 | 2020-05-27 | Gregg | Texas | 48183 | 248 | 6 |
187145 | 187145 | 2020-05-28 | Gregg | Texas | 48183 | 249 | 6 |
190209 | 190209 | 2020-05-29 | Gregg | Texas | 48183 | 249 | 6 |
193274 | 193274 | 2020-05-30 | Gregg | Texas | 48183 | 249 | 6 |
196344 | 196344 | 2020-05-31 | Gregg | Texas | 48183 | 249 | 6 |
199417 | 199417 | 2020-06-01 | Gregg | Texas | 48183 | 291 | 6 |
202492 | 202492 | 2020-06-02 | Gregg | Texas | 48183 | 299 | 7 |
205571 | 205571 | 2020-06-03 | Gregg | Texas | 48183 | 304 | 9 |
208653 | 208653 | 2020-06-04 | Gregg | Texas | 48183 | 307 | 9 |
211737 | 211737 | 2020-06-05 | Gregg | Texas | 48183 | 312 | 10 |
214824 | 214824 | 2020-06-06 | Gregg | Texas | 48183 | 312 | 10 |
217914 | 217914 | 2020-06-07 | Gregg | Texas | 48183 | 312 | 10 |
221006 | 221006 | 2020-06-08 | Gregg | Texas | 48183 | 325 | 11 |
224101 | 224101 | 2020-06-09 | Gregg | Texas | 48183 | 325 | 11 |
227201 | 227201 | 2020-06-10 | Gregg | Texas | 48183 | 331 | 11 |
230305 | 230305 | 2020-06-11 | Gregg | Texas | 48183 | 332 | 11 |
233409 | 233409 | 2020-06-12 | Gregg | Texas | 48183 | 284 | 12 |
236515 | 236515 | 2020-06-13 | Gregg | Texas | 48183 | 284 | 12 |
239623 | 239623 | 2020-06-14 | Gregg | Texas | 48183 | 284 | 12 |
242733 | 242733 | 2020-06-15 | Gregg | Texas | 48183 | 287 | 12 |
245845 | 245845 | 2020-06-16 | Gregg | Texas | 48183 | 299 | 13 |
248958 | 248958 | 2020-06-17 | Gregg | Texas | 48183 | 299 | 13 |
252073 | 252073 | 2020-06-18 | Gregg | Texas | 48183 | 302 | 13 |
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);