ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Grayson" and state = "Texas" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
10655 | 10655 | 2020-03-24 | Grayson | Texas | 48181 | 1 | 0 |
12144 | 12144 | 2020-03-25 | Grayson | Texas | 48181 | 2 | 0 |
13773 | 13773 | 2020-03-26 | Grayson | Texas | 48181 | 2 | 0 |
15527 | 15527 | 2020-03-27 | Grayson | Texas | 48181 | 2 | 0 |
17396 | 17396 | 2020-03-28 | Grayson | Texas | 48181 | 2 | 0 |
19349 | 19349 | 2020-03-29 | Grayson | Texas | 48181 | 3 | 0 |
21408 | 21408 | 2020-03-30 | Grayson | Texas | 48181 | 6 | 0 |
23547 | 23547 | 2020-03-31 | Grayson | Texas | 48181 | 7 | 0 |
25757 | 25757 | 2020-04-01 | Grayson | Texas | 48181 | 8 | 0 |
28040 | 28040 | 2020-04-02 | Grayson | Texas | 48181 | 11 | 0 |
30375 | 30375 | 2020-04-03 | Grayson | Texas | 48181 | 12 | 0 |
32768 | 32768 | 2020-04-04 | Grayson | Texas | 48181 | 12 | 0 |
35206 | 35206 | 2020-04-05 | Grayson | Texas | 48181 | 12 | 0 |
37682 | 37682 | 2020-04-06 | Grayson | Texas | 48181 | 14 | 0 |
40207 | 40207 | 2020-04-07 | Grayson | Texas | 48181 | 14 | 0 |
42774 | 42774 | 2020-04-08 | Grayson | Texas | 48181 | 14 | 0 |
45363 | 45363 | 2020-04-09 | Grayson | Texas | 48181 | 15 | 0 |
47983 | 47983 | 2020-04-10 | Grayson | Texas | 48181 | 17 | 0 |
50641 | 50641 | 2020-04-11 | Grayson | Texas | 48181 | 17 | 0 |
53316 | 53316 | 2020-04-12 | Grayson | Texas | 48181 | 17 | 0 |
56004 | 56004 | 2020-04-13 | Grayson | Texas | 48181 | 17 | 0 |
58709 | 58709 | 2020-04-14 | Grayson | Texas | 48181 | 17 | 0 |
61427 | 61427 | 2020-04-15 | Grayson | Texas | 48181 | 19 | 0 |
64154 | 64154 | 2020-04-16 | Grayson | Texas | 48181 | 19 | 0 |
66901 | 66901 | 2020-04-17 | Grayson | Texas | 48181 | 19 | 0 |
69661 | 69661 | 2020-04-18 | Grayson | Texas | 48181 | 19 | 0 |
72429 | 72429 | 2020-04-19 | Grayson | Texas | 48181 | 19 | 0 |
75204 | 75204 | 2020-04-20 | Grayson | Texas | 48181 | 19 | 0 |
77986 | 77986 | 2020-04-21 | Grayson | Texas | 48181 | 19 | 0 |
80777 | 80777 | 2020-04-22 | Grayson | Texas | 48181 | 19 | 0 |
83577 | 83577 | 2020-04-23 | Grayson | Texas | 48181 | 19 | 0 |
86382 | 86382 | 2020-04-24 | Grayson | Texas | 48181 | 19 | 0 |
89197 | 89197 | 2020-04-25 | Grayson | Texas | 48181 | 22 | 0 |
92014 | 92014 | 2020-04-26 | Grayson | Texas | 48181 | 22 | 0 |
94843 | 94843 | 2020-04-27 | Grayson | Texas | 48181 | 23 | 0 |
97683 | 97683 | 2020-04-28 | Grayson | Texas | 48181 | 24 | 0 |
100533 | 100533 | 2020-04-29 | Grayson | Texas | 48181 | 27 | 0 |
103388 | 103388 | 2020-04-30 | Grayson | Texas | 48181 | 31 | 0 |
106252 | 106252 | 2020-05-01 | Grayson | Texas | 48181 | 34 | 0 |
109121 | 109121 | 2020-05-02 | Grayson | Texas | 48181 | 38 | 0 |
111995 | 111995 | 2020-05-03 | Grayson | Texas | 48181 | 41 | 0 |
114877 | 114877 | 2020-05-04 | Grayson | Texas | 48181 | 49 | 0 |
117836 | 117836 | 2020-05-05 | Grayson | Texas | 48181 | 53 | 0 |
120800 | 120800 | 2020-05-06 | Grayson | Texas | 48181 | 58 | 0 |
123779 | 123779 | 2020-05-07 | Grayson | Texas | 48181 | 60 | 0 |
126762 | 126762 | 2020-05-08 | Grayson | Texas | 48181 | 78 | 0 |
129751 | 129751 | 2020-05-09 | Grayson | Texas | 48181 | 83 | 0 |
132741 | 132741 | 2020-05-10 | Grayson | Texas | 48181 | 89 | 0 |
135732 | 135732 | 2020-05-11 | Grayson | Texas | 48181 | 91 | 0 |
138722 | 138722 | 2020-05-12 | Grayson | Texas | 48181 | 105 | 0 |
141718 | 141718 | 2020-05-13 | Grayson | Texas | 48181 | 112 | 0 |
144715 | 144715 | 2020-05-14 | Grayson | Texas | 48181 | 122 | 0 |
147718 | 147718 | 2020-05-15 | Grayson | Texas | 48181 | 129 | 0 |
150726 | 150726 | 2020-05-16 | Grayson | Texas | 48181 | 140 | 0 |
153737 | 153737 | 2020-05-17 | Grayson | Texas | 48181 | 147 | 0 |
156754 | 156754 | 2020-05-18 | Grayson | Texas | 48181 | 152 | 0 |
159776 | 159776 | 2020-05-19 | Grayson | Texas | 48181 | 165 | 0 |
162803 | 162803 | 2020-05-20 | Grayson | Texas | 48181 | 199 | 1 |
165832 | 165832 | 2020-05-21 | Grayson | Texas | 48181 | 268 | 1 |
168868 | 168868 | 2020-05-22 | Grayson | Texas | 48181 | 268 | 1 |
171907 | 171907 | 2020-05-23 | Grayson | Texas | 48181 | 287 | 2 |
174950 | 174950 | 2020-05-24 | Grayson | Texas | 48181 | 296 | 2 |
177994 | 177994 | 2020-05-25 | Grayson | Texas | 48181 | 300 | 2 |
181037 | 181037 | 2020-05-26 | Grayson | Texas | 48181 | 303 | 2 |
184087 | 184087 | 2020-05-27 | Grayson | Texas | 48181 | 310 | 2 |
187144 | 187144 | 2020-05-28 | Grayson | Texas | 48181 | 316 | 2 |
190208 | 190208 | 2020-05-29 | Grayson | Texas | 48181 | 323 | 2 |
193273 | 193273 | 2020-05-30 | Grayson | Texas | 48181 | 327 | 2 |
196343 | 196343 | 2020-05-31 | Grayson | Texas | 48181 | 333 | 2 |
199416 | 199416 | 2020-06-01 | Grayson | Texas | 48181 | 338 | 2 |
202491 | 202491 | 2020-06-02 | Grayson | Texas | 48181 | 342 | 2 |
205570 | 205570 | 2020-06-03 | Grayson | Texas | 48181 | 350 | 2 |
208652 | 208652 | 2020-06-04 | Grayson | Texas | 48181 | 355 | 2 |
211736 | 211736 | 2020-06-05 | Grayson | Texas | 48181 | 366 | 2 |
214823 | 214823 | 2020-06-06 | Grayson | Texas | 48181 | 372 | 2 |
217913 | 217913 | 2020-06-07 | Grayson | Texas | 48181 | 375 | 2 |
221005 | 221005 | 2020-06-08 | Grayson | Texas | 48181 | 377 | 2 |
224100 | 224100 | 2020-06-09 | Grayson | Texas | 48181 | 384 | 3 |
227200 | 227200 | 2020-06-10 | Grayson | Texas | 48181 | 389 | 4 |
230304 | 230304 | 2020-06-11 | Grayson | Texas | 48181 | 403 | 4 |
233408 | 233408 | 2020-06-12 | Grayson | Texas | 48181 | 408 | 4 |
236514 | 236514 | 2020-06-13 | Grayson | Texas | 48181 | 433 | 4 |
239622 | 239622 | 2020-06-14 | Grayson | Texas | 48181 | 433 | 4 |
242732 | 242732 | 2020-06-15 | Grayson | Texas | 48181 | 438 | 4 |
245844 | 245844 | 2020-06-16 | Grayson | Texas | 48181 | 440 | 4 |
248957 | 248957 | 2020-06-17 | Grayson | Texas | 48181 | 473 | 4 |
252072 | 252072 | 2020-06-18 | Grayson | Texas | 48181 | 481 | 4 |
255187 | 255187 | 2020-06-19 | Grayson | Texas | 48181 | 491 | 5 |
258314 | 258314 | 2020-06-20 | Grayson | Texas | 48181 | 491 | 5 |
261441 | 261441 | 2020-06-21 | Grayson | Texas | 48181 | 514 | 5 |
264569 | 264569 | 2020-06-22 | Grayson | Texas | 48181 | 518 | 5 |
267697 | 267697 | 2020-06-23 | Grayson | Texas | 48181 | 521 | 5 |
270831 | 270831 | 2020-06-24 | Grayson | Texas | 48181 | 537 | 5 |
273971 | 273971 | 2020-06-25 | Grayson | Texas | 48181 | 547 | 5 |
277118 | 277118 | 2020-06-26 | Grayson | Texas | 48181 | 550 | 5 |
280266 | 280266 | 2020-06-27 | Grayson | Texas | 48181 | 558 | 5 |
283412 | 283412 | 2020-06-28 | Grayson | Texas | 48181 | 563 | 5 |
286558 | 286558 | 2020-06-29 | Grayson | Texas | 48181 | 566 | 5 |
289708 | 289708 | 2020-06-30 | Grayson | Texas | 48181 | 572 | 5 |
292861 | 292861 | 2020-07-01 | Grayson | Texas | 48181 | 580 | 5 |
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);