ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Galveston" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
324541 | 324541 | 2020-07-11 | Galveston | Texas | 48167 | 5873 | 54 |
321360 | 321360 | 2020-07-10 | Galveston | Texas | 48167 | 5630 | 50 |
318181 | 318181 | 2020-07-09 | Galveston | Texas | 48167 | 5320 | 50 |
315008 | 315008 | 2020-07-08 | Galveston | Texas | 48167 | 5063 | 50 |
311834 | 311834 | 2020-07-07 | Galveston | Texas | 48167 | 4809 | 50 |
308665 | 308665 | 2020-07-06 | Galveston | Texas | 48167 | 4586 | 46 |
305497 | 305497 | 2020-07-05 | Galveston | Texas | 48167 | 3990 | 46 |
302333 | 302333 | 2020-07-04 | Galveston | Texas | 48167 | 3990 | 46 |
299169 | 299169 | 2020-07-03 | Galveston | Texas | 48167 | 3990 | 46 |
296009 | 296009 | 2020-07-02 | Galveston | Texas | 48167 | 3778 | 45 |
292854 | 292854 | 2020-07-01 | Galveston | Texas | 48167 | 3565 | 40 |
289701 | 289701 | 2020-06-30 | Galveston | Texas | 48167 | 3293 | 40 |
286551 | 286551 | 2020-06-29 | Galveston | Texas | 48167 | 3062 | 40 |
283405 | 283405 | 2020-06-28 | Galveston | Texas | 48167 | 2923 | 40 |
280259 | 280259 | 2020-06-27 | Galveston | Texas | 48167 | 2821 | 40 |
277111 | 277111 | 2020-06-26 | Galveston | Texas | 48167 | 2667 | 40 |
273964 | 273964 | 2020-06-25 | Galveston | Texas | 48167 | 2415 | 40 |
270824 | 270824 | 2020-06-24 | Galveston | Texas | 48167 | 2266 | 40 |
267690 | 267690 | 2020-06-23 | Galveston | Texas | 48167 | 2040 | 40 |
264562 | 264562 | 2020-06-22 | Galveston | Texas | 48167 | 1968 | 40 |
261434 | 261434 | 2020-06-21 | Galveston | Texas | 48167 | 1867 | 40 |
258307 | 258307 | 2020-06-20 | Galveston | Texas | 48167 | 1784 | 40 |
255180 | 255180 | 2020-06-19 | Galveston | Texas | 48167 | 1642 | 40 |
252065 | 252065 | 2020-06-18 | Galveston | Texas | 48167 | 1535 | 40 |
248950 | 248950 | 2020-06-17 | Galveston | Texas | 48167 | 1486 | 40 |
245837 | 245837 | 2020-06-16 | Galveston | Texas | 48167 | 1378 | 40 |
242725 | 242725 | 2020-06-15 | Galveston | Texas | 48167 | 1312 | 40 |
239615 | 239615 | 2020-06-14 | Galveston | Texas | 48167 | 1255 | 40 |
236507 | 236507 | 2020-06-13 | Galveston | Texas | 48167 | 1237 | 40 |
233401 | 233401 | 2020-06-12 | Galveston | Texas | 48167 | 1166 | 40 |
230297 | 230297 | 2020-06-11 | Galveston | Texas | 48167 | 1114 | 38 |
227193 | 227193 | 2020-06-10 | Galveston | Texas | 48167 | 1084 | 38 |
224093 | 224093 | 2020-06-09 | Galveston | Texas | 48167 | 1051 | 38 |
220998 | 220998 | 2020-06-08 | Galveston | Texas | 48167 | 1026 | 38 |
217906 | 217906 | 2020-06-07 | Galveston | Texas | 48167 | 994 | 38 |
214816 | 214816 | 2020-06-06 | Galveston | Texas | 48167 | 972 | 38 |
211729 | 211729 | 2020-06-05 | Galveston | Texas | 48167 | 906 | 38 |
208645 | 208645 | 2020-06-04 | Galveston | Texas | 48167 | 906 | 38 |
205563 | 205563 | 2020-06-03 | Galveston | Texas | 48167 | 876 | 37 |
202484 | 202484 | 2020-06-02 | Galveston | Texas | 48167 | 857 | 37 |
199409 | 199409 | 2020-06-01 | Galveston | Texas | 48167 | 847 | 37 |
196336 | 196336 | 2020-05-31 | Galveston | Texas | 48167 | 817 | 37 |
193266 | 193266 | 2020-05-30 | Galveston | Texas | 48167 | 807 | 37 |
190201 | 190201 | 2020-05-29 | Galveston | Texas | 48167 | 795 | 32 |
187137 | 187137 | 2020-05-28 | Galveston | Texas | 48167 | 788 | 32 |
184080 | 184080 | 2020-05-27 | Galveston | Texas | 48167 | 779 | 32 |
181030 | 181030 | 2020-05-26 | Galveston | Texas | 48167 | 763 | 32 |
177987 | 177987 | 2020-05-25 | Galveston | Texas | 48167 | 753 | 32 |
174943 | 174943 | 2020-05-24 | Galveston | Texas | 48167 | 752 | 32 |
171900 | 171900 | 2020-05-23 | Galveston | Texas | 48167 | 749 | 32 |
168861 | 168861 | 2020-05-22 | Galveston | Texas | 48167 | 740 | 31 |
165825 | 165825 | 2020-05-21 | Galveston | Texas | 48167 | 732 | 31 |
162796 | 162796 | 2020-05-20 | Galveston | Texas | 48167 | 715 | 31 |
159769 | 159769 | 2020-05-19 | Galveston | Texas | 48167 | 706 | 31 |
156747 | 156747 | 2020-05-18 | Galveston | Texas | 48167 | 706 | 31 |
153730 | 153730 | 2020-05-17 | Galveston | Texas | 48167 | 702 | 31 |
150719 | 150719 | 2020-05-16 | Galveston | Texas | 48167 | 701 | 31 |
147711 | 147711 | 2020-05-15 | Galveston | Texas | 48167 | 696 | 30 |
144708 | 144708 | 2020-05-14 | Galveston | Texas | 48167 | 693 | 30 |
141711 | 141711 | 2020-05-13 | Galveston | Texas | 48167 | 691 | 29 |
138715 | 138715 | 2020-05-12 | Galveston | Texas | 48167 | 688 | 29 |
135725 | 135725 | 2020-05-11 | Galveston | Texas | 48167 | 686 | 29 |
132734 | 132734 | 2020-05-10 | Galveston | Texas | 48167 | 685 | 29 |
129744 | 129744 | 2020-05-09 | Galveston | Texas | 48167 | 680 | 29 |
126755 | 126755 | 2020-05-08 | Galveston | Texas | 48167 | 676 | 28 |
123772 | 123772 | 2020-05-07 | Galveston | Texas | 48167 | 672 | 28 |
120793 | 120793 | 2020-05-06 | Galveston | Texas | 48167 | 669 | 28 |
117829 | 117829 | 2020-05-05 | Galveston | Texas | 48167 | 659 | 28 |
114870 | 114870 | 2020-05-04 | Galveston | Texas | 48167 | 648 | 28 |
111988 | 111988 | 2020-05-03 | Galveston | Texas | 48167 | 636 | 28 |
109114 | 109114 | 2020-05-02 | Galveston | Texas | 48167 | 629 | 28 |
106245 | 106245 | 2020-05-01 | Galveston | Texas | 48167 | 614 | 27 |
103381 | 103381 | 2020-04-30 | Galveston | Texas | 48167 | 595 | 26 |
100528 | 100528 | 2020-04-29 | Galveston | Texas | 48167 | 572 | 24 |
97678 | 97678 | 2020-04-28 | Galveston | Texas | 48167 | 554 | 24 |
94838 | 94838 | 2020-04-27 | Galveston | Texas | 48167 | 548 | 24 |
92009 | 92009 | 2020-04-26 | Galveston | Texas | 48167 | 541 | 22 |
89192 | 89192 | 2020-04-25 | Galveston | Texas | 48167 | 539 | 22 |
86377 | 86377 | 2020-04-24 | Galveston | Texas | 48167 | 522 | 21 |
83572 | 83572 | 2020-04-23 | Galveston | Texas | 48167 | 507 | 21 |
80772 | 80772 | 2020-04-22 | Galveston | Texas | 48167 | 491 | 21 |
77981 | 77981 | 2020-04-21 | Galveston | Texas | 48167 | 479 | 20 |
75199 | 75199 | 2020-04-20 | Galveston | Texas | 48167 | 468 | 19 |
72424 | 72424 | 2020-04-19 | Galveston | Texas | 48167 | 455 | 17 |
69656 | 69656 | 2020-04-18 | Galveston | Texas | 48167 | 450 | 15 |
66896 | 66896 | 2020-04-17 | Galveston | Texas | 48167 | 438 | 14 |
64149 | 64149 | 2020-04-16 | Galveston | Texas | 48167 | 421 | 14 |
61422 | 61422 | 2020-04-15 | Galveston | Texas | 48167 | 401 | 13 |
58704 | 58704 | 2020-04-14 | Galveston | Texas | 48167 | 392 | 11 |
55999 | 55999 | 2020-04-13 | Galveston | Texas | 48167 | 377 | 9 |
53311 | 53311 | 2020-04-12 | Galveston | Texas | 48167 | 355 | 8 |
50636 | 50636 | 2020-04-11 | Galveston | Texas | 48167 | 355 | 8 |
47978 | 47978 | 2020-04-10 | Galveston | Texas | 48167 | 341 | 8 |
45358 | 45358 | 2020-04-09 | Galveston | Texas | 48167 | 308 | 7 |
42769 | 42769 | 2020-04-08 | Galveston | Texas | 48167 | 287 | 5 |
40202 | 40202 | 2020-04-07 | Galveston | Texas | 48167 | 272 | 5 |
37677 | 37677 | 2020-04-06 | Galveston | Texas | 48167 | 256 | 1 |
35201 | 35201 | 2020-04-05 | Galveston | Texas | 48167 | 240 | 1 |
32763 | 32763 | 2020-04-04 | Galveston | Texas | 48167 | 222 | 1 |
30370 | 30370 | 2020-04-03 | Galveston | Texas | 48167 | 206 | 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);