ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 48167 and state = "Texas" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
1885 | 1885 | 2020-03-13 | Galveston | Texas | 48167 | 1 | 0 |
2251 | 2251 | 2020-03-14 | Galveston | Texas | 48167 | 1 | 0 |
2677 | 2677 | 2020-03-15 | Galveston | Texas | 48167 | 1 | 0 |
3145 | 3145 | 2020-03-16 | Galveston | Texas | 48167 | 1 | 0 |
3680 | 3680 | 2020-03-17 | Galveston | Texas | 48167 | 1 | 0 |
4303 | 4303 | 2020-03-18 | Galveston | Texas | 48167 | 4 | 0 |
5057 | 5057 | 2020-03-19 | Galveston | Texas | 48167 | 4 | 0 |
5949 | 5949 | 2020-03-20 | Galveston | Texas | 48167 | 6 | 0 |
6969 | 6969 | 2020-03-21 | Galveston | Texas | 48167 | 8 | 0 |
8099 | 8099 | 2020-03-22 | Galveston | Texas | 48167 | 11 | 0 |
9317 | 9317 | 2020-03-23 | Galveston | Texas | 48167 | 17 | 0 |
10654 | 10654 | 2020-03-24 | Galveston | Texas | 48167 | 18 | 0 |
12143 | 12143 | 2020-03-25 | Galveston | Texas | 48167 | 22 | 0 |
13772 | 13772 | 2020-03-26 | Galveston | Texas | 48167 | 27 | 0 |
15526 | 15526 | 2020-03-27 | Galveston | Texas | 48167 | 49 | 0 |
17395 | 17395 | 2020-03-28 | Galveston | Texas | 48167 | 60 | 0 |
19348 | 19348 | 2020-03-29 | Galveston | Texas | 48167 | 70 | 0 |
21407 | 21407 | 2020-03-30 | Galveston | Texas | 48167 | 92 | 0 |
23546 | 23546 | 2020-03-31 | Galveston | Texas | 48167 | 106 | 0 |
25754 | 25754 | 2020-04-01 | Galveston | Texas | 48167 | 118 | 0 |
28035 | 28035 | 2020-04-02 | Galveston | Texas | 48167 | 130 | 0 |
30370 | 30370 | 2020-04-03 | Galveston | Texas | 48167 | 206 | 0 |
32763 | 32763 | 2020-04-04 | Galveston | Texas | 48167 | 222 | 1 |
35201 | 35201 | 2020-04-05 | Galveston | Texas | 48167 | 240 | 1 |
37677 | 37677 | 2020-04-06 | Galveston | Texas | 48167 | 256 | 1 |
40202 | 40202 | 2020-04-07 | Galveston | Texas | 48167 | 272 | 5 |
42769 | 42769 | 2020-04-08 | Galveston | Texas | 48167 | 287 | 5 |
45358 | 45358 | 2020-04-09 | Galveston | Texas | 48167 | 308 | 7 |
47978 | 47978 | 2020-04-10 | Galveston | Texas | 48167 | 341 | 8 |
50636 | 50636 | 2020-04-11 | Galveston | Texas | 48167 | 355 | 8 |
53311 | 53311 | 2020-04-12 | Galveston | Texas | 48167 | 355 | 8 |
55999 | 55999 | 2020-04-13 | Galveston | Texas | 48167 | 377 | 9 |
58704 | 58704 | 2020-04-14 | Galveston | Texas | 48167 | 392 | 11 |
61422 | 61422 | 2020-04-15 | Galveston | Texas | 48167 | 401 | 13 |
64149 | 64149 | 2020-04-16 | Galveston | Texas | 48167 | 421 | 14 |
66896 | 66896 | 2020-04-17 | Galveston | Texas | 48167 | 438 | 14 |
69656 | 69656 | 2020-04-18 | Galveston | Texas | 48167 | 450 | 15 |
72424 | 72424 | 2020-04-19 | Galveston | Texas | 48167 | 455 | 17 |
75199 | 75199 | 2020-04-20 | Galveston | Texas | 48167 | 468 | 19 |
77981 | 77981 | 2020-04-21 | Galveston | Texas | 48167 | 479 | 20 |
80772 | 80772 | 2020-04-22 | Galveston | Texas | 48167 | 491 | 21 |
83572 | 83572 | 2020-04-23 | Galveston | Texas | 48167 | 507 | 21 |
86377 | 86377 | 2020-04-24 | Galveston | Texas | 48167 | 522 | 21 |
89192 | 89192 | 2020-04-25 | Galveston | Texas | 48167 | 539 | 22 |
92009 | 92009 | 2020-04-26 | Galveston | Texas | 48167 | 541 | 22 |
94838 | 94838 | 2020-04-27 | Galveston | Texas | 48167 | 548 | 24 |
97678 | 97678 | 2020-04-28 | Galveston | Texas | 48167 | 554 | 24 |
100528 | 100528 | 2020-04-29 | Galveston | Texas | 48167 | 572 | 24 |
103381 | 103381 | 2020-04-30 | Galveston | Texas | 48167 | 595 | 26 |
106245 | 106245 | 2020-05-01 | Galveston | Texas | 48167 | 614 | 27 |
109114 | 109114 | 2020-05-02 | Galveston | Texas | 48167 | 629 | 28 |
111988 | 111988 | 2020-05-03 | Galveston | Texas | 48167 | 636 | 28 |
114870 | 114870 | 2020-05-04 | Galveston | Texas | 48167 | 648 | 28 |
117829 | 117829 | 2020-05-05 | Galveston | Texas | 48167 | 659 | 28 |
120793 | 120793 | 2020-05-06 | Galveston | Texas | 48167 | 669 | 28 |
123772 | 123772 | 2020-05-07 | Galveston | Texas | 48167 | 672 | 28 |
126755 | 126755 | 2020-05-08 | Galveston | Texas | 48167 | 676 | 28 |
129744 | 129744 | 2020-05-09 | Galveston | Texas | 48167 | 680 | 29 |
132734 | 132734 | 2020-05-10 | Galveston | Texas | 48167 | 685 | 29 |
135725 | 135725 | 2020-05-11 | Galveston | Texas | 48167 | 686 | 29 |
138715 | 138715 | 2020-05-12 | Galveston | Texas | 48167 | 688 | 29 |
141711 | 141711 | 2020-05-13 | Galveston | Texas | 48167 | 691 | 29 |
144708 | 144708 | 2020-05-14 | Galveston | Texas | 48167 | 693 | 30 |
147711 | 147711 | 2020-05-15 | Galveston | Texas | 48167 | 696 | 30 |
150719 | 150719 | 2020-05-16 | Galveston | Texas | 48167 | 701 | 31 |
153730 | 153730 | 2020-05-17 | Galveston | Texas | 48167 | 702 | 31 |
156747 | 156747 | 2020-05-18 | Galveston | Texas | 48167 | 706 | 31 |
159769 | 159769 | 2020-05-19 | Galveston | Texas | 48167 | 706 | 31 |
162796 | 162796 | 2020-05-20 | Galveston | Texas | 48167 | 715 | 31 |
165825 | 165825 | 2020-05-21 | Galveston | Texas | 48167 | 732 | 31 |
168861 | 168861 | 2020-05-22 | Galveston | Texas | 48167 | 740 | 31 |
171900 | 171900 | 2020-05-23 | Galveston | Texas | 48167 | 749 | 32 |
174943 | 174943 | 2020-05-24 | Galveston | Texas | 48167 | 752 | 32 |
177987 | 177987 | 2020-05-25 | Galveston | Texas | 48167 | 753 | 32 |
181030 | 181030 | 2020-05-26 | Galveston | Texas | 48167 | 763 | 32 |
184080 | 184080 | 2020-05-27 | Galveston | Texas | 48167 | 779 | 32 |
187137 | 187137 | 2020-05-28 | Galveston | Texas | 48167 | 788 | 32 |
190201 | 190201 | 2020-05-29 | Galveston | Texas | 48167 | 795 | 32 |
193266 | 193266 | 2020-05-30 | Galveston | Texas | 48167 | 807 | 37 |
196336 | 196336 | 2020-05-31 | Galveston | Texas | 48167 | 817 | 37 |
199409 | 199409 | 2020-06-01 | Galveston | Texas | 48167 | 847 | 37 |
202484 | 202484 | 2020-06-02 | Galveston | Texas | 48167 | 857 | 37 |
205563 | 205563 | 2020-06-03 | Galveston | Texas | 48167 | 876 | 37 |
208645 | 208645 | 2020-06-04 | Galveston | Texas | 48167 | 906 | 38 |
211729 | 211729 | 2020-06-05 | Galveston | Texas | 48167 | 906 | 38 |
214816 | 214816 | 2020-06-06 | Galveston | Texas | 48167 | 972 | 38 |
217906 | 217906 | 2020-06-07 | Galveston | Texas | 48167 | 994 | 38 |
220998 | 220998 | 2020-06-08 | Galveston | Texas | 48167 | 1026 | 38 |
224093 | 224093 | 2020-06-09 | Galveston | Texas | 48167 | 1051 | 38 |
227193 | 227193 | 2020-06-10 | Galveston | Texas | 48167 | 1084 | 38 |
230297 | 230297 | 2020-06-11 | Galveston | Texas | 48167 | 1114 | 38 |
233401 | 233401 | 2020-06-12 | Galveston | Texas | 48167 | 1166 | 40 |
236507 | 236507 | 2020-06-13 | Galveston | Texas | 48167 | 1237 | 40 |
239615 | 239615 | 2020-06-14 | Galveston | Texas | 48167 | 1255 | 40 |
242725 | 242725 | 2020-06-15 | Galveston | Texas | 48167 | 1312 | 40 |
245837 | 245837 | 2020-06-16 | Galveston | Texas | 48167 | 1378 | 40 |
248950 | 248950 | 2020-06-17 | Galveston | Texas | 48167 | 1486 | 40 |
252065 | 252065 | 2020-06-18 | Galveston | Texas | 48167 | 1535 | 40 |
255180 | 255180 | 2020-06-19 | Galveston | Texas | 48167 | 1642 | 40 |
258307 | 258307 | 2020-06-20 | Galveston | Texas | 48167 | 1784 | 40 |
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);