ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Gregg" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
324549 | 324549 | 2020-07-11 | Gregg | Texas | 48183 | 788 | 14 |
321368 | 321368 | 2020-07-10 | Gregg | Texas | 48183 | 788 | 14 |
318189 | 318189 | 2020-07-09 | Gregg | Texas | 48183 | 745 | 14 |
315016 | 315016 | 2020-07-08 | Gregg | Texas | 48183 | 668 | 14 |
311842 | 311842 | 2020-07-07 | Gregg | Texas | 48183 | 486 | 14 |
308673 | 308673 | 2020-07-06 | Gregg | Texas | 48183 | 486 | 14 |
305505 | 305505 | 2020-07-05 | Gregg | Texas | 48183 | 417 | 14 |
302341 | 302341 | 2020-07-04 | Gregg | Texas | 48183 | 417 | 14 |
299177 | 299177 | 2020-07-03 | Gregg | Texas | 48183 | 417 | 14 |
296017 | 296017 | 2020-07-02 | Gregg | Texas | 48183 | 417 | 14 |
292862 | 292862 | 2020-07-01 | Gregg | Texas | 48183 | 397 | 14 |
289709 | 289709 | 2020-06-30 | Gregg | Texas | 48183 | 355 | 14 |
286559 | 286559 | 2020-06-29 | Gregg | Texas | 48183 | 354 | 14 |
283413 | 283413 | 2020-06-28 | Gregg | Texas | 48183 | 340 | 14 |
280267 | 280267 | 2020-06-27 | Gregg | Texas | 48183 | 340 | 14 |
277119 | 277119 | 2020-06-26 | Gregg | Texas | 48183 | 340 | 14 |
273972 | 273972 | 2020-06-25 | Gregg | Texas | 48183 | 334 | 14 |
270832 | 270832 | 2020-06-24 | Gregg | Texas | 48183 | 320 | 14 |
267698 | 267698 | 2020-06-23 | Gregg | Texas | 48183 | 317 | 13 |
264570 | 264570 | 2020-06-22 | Gregg | Texas | 48183 | 309 | 13 |
261442 | 261442 | 2020-06-21 | Gregg | Texas | 48183 | 306 | 13 |
258315 | 258315 | 2020-06-20 | Gregg | Texas | 48183 | 306 | 13 |
255188 | 255188 | 2020-06-19 | Gregg | Texas | 48183 | 306 | 13 |
252073 | 252073 | 2020-06-18 | Gregg | Texas | 48183 | 302 | 13 |
248958 | 248958 | 2020-06-17 | Gregg | Texas | 48183 | 299 | 13 |
245845 | 245845 | 2020-06-16 | Gregg | Texas | 48183 | 299 | 13 |
242733 | 242733 | 2020-06-15 | Gregg | Texas | 48183 | 287 | 12 |
239623 | 239623 | 2020-06-14 | Gregg | Texas | 48183 | 284 | 12 |
236515 | 236515 | 2020-06-13 | Gregg | Texas | 48183 | 284 | 12 |
233409 | 233409 | 2020-06-12 | Gregg | Texas | 48183 | 284 | 12 |
230305 | 230305 | 2020-06-11 | Gregg | Texas | 48183 | 332 | 11 |
227201 | 227201 | 2020-06-10 | Gregg | Texas | 48183 | 331 | 11 |
224101 | 224101 | 2020-06-09 | Gregg | Texas | 48183 | 325 | 11 |
221006 | 221006 | 2020-06-08 | Gregg | Texas | 48183 | 325 | 11 |
217914 | 217914 | 2020-06-07 | Gregg | Texas | 48183 | 312 | 10 |
214824 | 214824 | 2020-06-06 | Gregg | Texas | 48183 | 312 | 10 |
211737 | 211737 | 2020-06-05 | Gregg | Texas | 48183 | 312 | 10 |
208653 | 208653 | 2020-06-04 | Gregg | Texas | 48183 | 307 | 9 |
205571 | 205571 | 2020-06-03 | Gregg | Texas | 48183 | 304 | 9 |
202492 | 202492 | 2020-06-02 | Gregg | Texas | 48183 | 299 | 7 |
199417 | 199417 | 2020-06-01 | Gregg | Texas | 48183 | 291 | 6 |
196344 | 196344 | 2020-05-31 | Gregg | Texas | 48183 | 249 | 6 |
193274 | 193274 | 2020-05-30 | Gregg | Texas | 48183 | 249 | 6 |
190209 | 190209 | 2020-05-29 | Gregg | Texas | 48183 | 249 | 6 |
187145 | 187145 | 2020-05-28 | Gregg | Texas | 48183 | 249 | 6 |
184088 | 184088 | 2020-05-27 | Gregg | Texas | 48183 | 248 | 6 |
181038 | 181038 | 2020-05-26 | Gregg | Texas | 48183 | 204 | 5 |
177995 | 177995 | 2020-05-25 | Gregg | Texas | 48183 | 187 | 4 |
174951 | 174951 | 2020-05-24 | Gregg | Texas | 48183 | 187 | 4 |
171908 | 171908 | 2020-05-23 | Gregg | Texas | 48183 | 187 | 4 |
168869 | 168869 | 2020-05-22 | Gregg | Texas | 48183 | 187 | 4 |
165833 | 165833 | 2020-05-21 | Gregg | Texas | 48183 | 180 | 4 |
162804 | 162804 | 2020-05-20 | Gregg | Texas | 48183 | 173 | 4 |
159777 | 159777 | 2020-05-19 | Gregg | Texas | 48183 | 173 | 0 |
156755 | 156755 | 2020-05-18 | Gregg | Texas | 48183 | 170 | 0 |
153738 | 153738 | 2020-05-17 | Gregg | Texas | 48183 | 170 | 0 |
150727 | 150727 | 2020-05-16 | Gregg | Texas | 48183 | 170 | 0 |
147719 | 147719 | 2020-05-15 | Gregg | Texas | 48183 | 142 | 0 |
144716 | 144716 | 2020-05-14 | Gregg | Texas | 48183 | 138 | 0 |
141719 | 141719 | 2020-05-13 | Gregg | Texas | 48183 | 136 | 0 |
138723 | 138723 | 2020-05-12 | Gregg | Texas | 48183 | 132 | 0 |
135733 | 135733 | 2020-05-11 | Gregg | Texas | 48183 | 118 | 0 |
132742 | 132742 | 2020-05-10 | Gregg | Texas | 48183 | 118 | 0 |
129752 | 129752 | 2020-05-09 | Gregg | Texas | 48183 | 117 | 0 |
126763 | 126763 | 2020-05-08 | Gregg | Texas | 48183 | 117 | 0 |
123780 | 123780 | 2020-05-07 | Gregg | Texas | 48183 | 109 | 0 |
120801 | 120801 | 2020-05-06 | Gregg | Texas | 48183 | 107 | 0 |
117837 | 117837 | 2020-05-05 | Gregg | Texas | 48183 | 97 | 0 |
114878 | 114878 | 2020-05-04 | Gregg | Texas | 48183 | 87 | 0 |
111996 | 111996 | 2020-05-03 | Gregg | Texas | 48183 | 87 | 0 |
109122 | 109122 | 2020-05-02 | Gregg | Texas | 48183 | 87 | 0 |
106253 | 106253 | 2020-05-01 | Gregg | Texas | 48183 | 80 | 0 |
103389 | 103389 | 2020-04-30 | Gregg | Texas | 48183 | 73 | 0 |
100534 | 100534 | 2020-04-29 | Gregg | Texas | 48183 | 69 | 0 |
97684 | 97684 | 2020-04-28 | Gregg | Texas | 48183 | 69 | 0 |
94844 | 94844 | 2020-04-27 | Gregg | Texas | 48183 | 66 | 0 |
92015 | 92015 | 2020-04-26 | Gregg | Texas | 48183 | 62 | 0 |
89198 | 89198 | 2020-04-25 | Gregg | Texas | 48183 | 58 | 0 |
86383 | 86383 | 2020-04-24 | Gregg | Texas | 48183 | 58 | 0 |
83578 | 83578 | 2020-04-23 | Gregg | Texas | 48183 | 55 | 0 |
80778 | 80778 | 2020-04-22 | Gregg | Texas | 48183 | 53 | 0 |
77987 | 77987 | 2020-04-21 | Gregg | Texas | 48183 | 52 | 0 |
75205 | 75205 | 2020-04-20 | Gregg | Texas | 48183 | 51 | 0 |
72430 | 72430 | 2020-04-19 | Gregg | Texas | 48183 | 51 | 0 |
69662 | 69662 | 2020-04-18 | Gregg | Texas | 48183 | 50 | 0 |
66902 | 66902 | 2020-04-17 | Gregg | Texas | 48183 | 48 | 0 |
64155 | 64155 | 2020-04-16 | Gregg | Texas | 48183 | 48 | 0 |
61428 | 61428 | 2020-04-15 | Gregg | Texas | 48183 | 46 | 0 |
58710 | 58710 | 2020-04-14 | Gregg | Texas | 48183 | 45 | 0 |
56005 | 56005 | 2020-04-13 | Gregg | Texas | 48183 | 39 | 0 |
53317 | 53317 | 2020-04-12 | Gregg | Texas | 48183 | 39 | 0 |
50642 | 50642 | 2020-04-11 | Gregg | Texas | 48183 | 39 | 0 |
47984 | 47984 | 2020-04-10 | Gregg | Texas | 48183 | 39 | 0 |
45364 | 45364 | 2020-04-09 | Gregg | Texas | 48183 | 37 | 0 |
42775 | 42775 | 2020-04-08 | Gregg | Texas | 48183 | 34 | 0 |
40208 | 40208 | 2020-04-07 | Gregg | Texas | 48183 | 26 | 0 |
37683 | 37683 | 2020-04-06 | Gregg | Texas | 48183 | 26 | 0 |
35207 | 35207 | 2020-04-05 | Gregg | Texas | 48183 | 13 | 0 |
32769 | 32769 | 2020-04-04 | Gregg | Texas | 48183 | 13 | 0 |
30376 | 30376 | 2020-04-03 | Gregg | Texas | 48183 | 8 | 0 |
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);