ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Crane" and state = "Texas" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
5050 | 5050 | 2020-03-19 | Crane | Texas | 48103 | 1 | 0 |
5941 | 5941 | 2020-03-20 | Crane | Texas | 48103 | 1 | 0 |
6960 | 6960 | 2020-03-21 | Crane | Texas | 48103 | 1 | 0 |
8090 | 8090 | 2020-03-22 | Crane | Texas | 48103 | 1 | 0 |
9308 | 9308 | 2020-03-23 | Crane | Texas | 48103 | 1 | 0 |
10644 | 10644 | 2020-03-24 | Crane | Texas | 48103 | 1 | 0 |
12129 | 12129 | 2020-03-25 | Crane | Texas | 48103 | 1 | 0 |
13758 | 13758 | 2020-03-26 | Crane | Texas | 48103 | 1 | 0 |
15512 | 15512 | 2020-03-27 | Crane | Texas | 48103 | 1 | 0 |
17381 | 17381 | 2020-03-28 | Crane | Texas | 48103 | 1 | 0 |
19331 | 19331 | 2020-03-29 | Crane | Texas | 48103 | 1 | 0 |
21390 | 21390 | 2020-03-30 | Crane | Texas | 48103 | 1 | 0 |
23529 | 23529 | 2020-03-31 | Crane | Texas | 48103 | 1 | 0 |
25737 | 25737 | 2020-04-01 | Crane | Texas | 48103 | 2 | 0 |
28017 | 28017 | 2020-04-02 | Crane | Texas | 48103 | 2 | 0 |
30352 | 30352 | 2020-04-03 | Crane | Texas | 48103 | 2 | 0 |
32745 | 32745 | 2020-04-04 | Crane | Texas | 48103 | 2 | 0 |
35183 | 35183 | 2020-04-05 | Crane | Texas | 48103 | 2 | 0 |
37659 | 37659 | 2020-04-06 | Crane | Texas | 48103 | 2 | 0 |
40182 | 40182 | 2020-04-07 | Crane | Texas | 48103 | 2 | 0 |
42745 | 42745 | 2020-04-08 | Crane | Texas | 48103 | 2 | 0 |
45334 | 45334 | 2020-04-09 | Crane | Texas | 48103 | 2 | 0 |
47954 | 47954 | 2020-04-10 | Crane | Texas | 48103 | 2 | 0 |
50611 | 50611 | 2020-04-11 | Crane | Texas | 48103 | 2 | 0 |
53286 | 53286 | 2020-04-12 | Crane | Texas | 48103 | 2 | 0 |
55974 | 55974 | 2020-04-13 | Crane | Texas | 48103 | 2 | 0 |
58678 | 58678 | 2020-04-14 | Crane | Texas | 48103 | 2 | 0 |
61395 | 61395 | 2020-04-15 | Crane | Texas | 48103 | 2 | 0 |
64122 | 64122 | 2020-04-16 | Crane | Texas | 48103 | 2 | 0 |
66869 | 66869 | 2020-04-17 | Crane | Texas | 48103 | 2 | 0 |
69629 | 69629 | 2020-04-18 | Crane | Texas | 48103 | 2 | 0 |
72397 | 72397 | 2020-04-19 | Crane | Texas | 48103 | 2 | 0 |
75172 | 75172 | 2020-04-20 | Crane | Texas | 48103 | 2 | 0 |
77954 | 77954 | 2020-04-21 | Crane | Texas | 48103 | 2 | 0 |
80745 | 80745 | 2020-04-22 | Crane | Texas | 48103 | 2 | 0 |
83545 | 83545 | 2020-04-23 | Crane | Texas | 48103 | 2 | 0 |
86350 | 86350 | 2020-04-24 | Crane | Texas | 48103 | 2 | 0 |
89165 | 89165 | 2020-04-25 | Crane | Texas | 48103 | 2 | 0 |
91982 | 91982 | 2020-04-26 | Crane | Texas | 48103 | 2 | 0 |
94811 | 94811 | 2020-04-27 | Crane | Texas | 48103 | 2 | 0 |
97651 | 97651 | 2020-04-28 | Crane | Texas | 48103 | 2 | 0 |
100501 | 100501 | 2020-04-29 | Crane | Texas | 48103 | 2 | 0 |
103354 | 103354 | 2020-04-30 | Crane | Texas | 48103 | 2 | 0 |
106218 | 106218 | 2020-05-01 | Crane | Texas | 48103 | 2 | 0 |
109087 | 109087 | 2020-05-02 | Crane | Texas | 48103 | 2 | 0 |
111961 | 111961 | 2020-05-03 | Crane | Texas | 48103 | 2 | 0 |
114843 | 114843 | 2020-05-04 | Crane | Texas | 48103 | 2 | 0 |
117802 | 117802 | 2020-05-05 | Crane | Texas | 48103 | 2 | 0 |
120766 | 120766 | 2020-05-06 | Crane | Texas | 48103 | 2 | 0 |
123745 | 123745 | 2020-05-07 | Crane | Texas | 48103 | 2 | 0 |
126728 | 126728 | 2020-05-08 | Crane | Texas | 48103 | 2 | 0 |
129717 | 129717 | 2020-05-09 | Crane | Texas | 48103 | 2 | 0 |
132707 | 132707 | 2020-05-10 | Crane | Texas | 48103 | 2 | 0 |
135698 | 135698 | 2020-05-11 | Crane | Texas | 48103 | 2 | 0 |
138688 | 138688 | 2020-05-12 | Crane | Texas | 48103 | 2 | 0 |
141684 | 141684 | 2020-05-13 | Crane | Texas | 48103 | 2 | 0 |
144681 | 144681 | 2020-05-14 | Crane | Texas | 48103 | 2 | 0 |
147683 | 147683 | 2020-05-15 | Crane | Texas | 48103 | 2 | 0 |
150691 | 150691 | 2020-05-16 | Crane | Texas | 48103 | 2 | 0 |
153702 | 153702 | 2020-05-17 | Crane | Texas | 48103 | 2 | 0 |
156719 | 156719 | 2020-05-18 | Crane | Texas | 48103 | 2 | 0 |
159741 | 159741 | 2020-05-19 | Crane | Texas | 48103 | 2 | 0 |
162768 | 162768 | 2020-05-20 | Crane | Texas | 48103 | 2 | 0 |
165797 | 165797 | 2020-05-21 | Crane | Texas | 48103 | 3 | 0 |
168833 | 168833 | 2020-05-22 | Crane | Texas | 48103 | 3 | 0 |
171872 | 171872 | 2020-05-23 | Crane | Texas | 48103 | 7 | 0 |
174915 | 174915 | 2020-05-24 | Crane | Texas | 48103 | 7 | 0 |
177959 | 177959 | 2020-05-25 | Crane | Texas | 48103 | 22 | 0 |
181002 | 181002 | 2020-05-26 | Crane | Texas | 48103 | 22 | 0 |
184052 | 184052 | 2020-05-27 | Crane | Texas | 48103 | 22 | 1 |
187109 | 187109 | 2020-05-28 | Crane | Texas | 48103 | 22 | 2 |
190173 | 190173 | 2020-05-29 | Crane | Texas | 48103 | 22 | 2 |
193238 | 193238 | 2020-05-30 | Crane | Texas | 48103 | 23 | 2 |
196308 | 196308 | 2020-05-31 | Crane | Texas | 48103 | 23 | 2 |
199381 | 199381 | 2020-06-01 | Crane | Texas | 48103 | 23 | 2 |
375718 | 375718 | 2020-07-27 | Crane | Texas | 48103 | 65 | 2 |
378934 | 378934 | 2020-07-28 | Crane | Texas | 48103 | 66 | 2 |
382151 | 382151 | 2020-07-29 | Crane | Texas | 48103 | 66 | 2 |
385369 | 385369 | 2020-07-30 | Crane | Texas | 48103 | 72 | 2 |
388586 | 388586 | 2020-07-31 | Crane | Texas | 48103 | 72 | 2 |
391803 | 391803 | 2020-08-01 | Crane | Texas | 48103 | 75 | 2 |
395019 | 395019 | 2020-08-02 | Crane | Texas | 48103 | 75 | 2 |
398235 | 398235 | 2020-08-03 | Crane | Texas | 48103 | 75 | 2 |
401451 | 401451 | 2020-08-04 | Crane | Texas | 48103 | 75 | 2 |
404669 | 404669 | 2020-08-05 | Crane | Texas | 48103 | 70 | 2 |
407889 | 407889 | 2020-08-06 | Crane | Texas | 48103 | 71 | 2 |
411108 | 411108 | 2020-08-07 | Crane | Texas | 48103 | 70 | 2 |
414328 | 414328 | 2020-08-08 | Crane | Texas | 48103 | 70 | 2 |
417549 | 417549 | 2020-08-09 | Crane | Texas | 48103 | 70 | 2 |
420770 | 420770 | 2020-08-10 | Crane | Texas | 48103 | 70 | 2 |
423991 | 423991 | 2020-08-11 | Crane | Texas | 48103 | 70 | 2 |
427215 | 427215 | 2020-08-12 | Crane | Texas | 48103 | 71 | 2 |
430442 | 430442 | 2020-08-13 | Crane | Texas | 48103 | 70 | 2 |
433667 | 433667 | 2020-08-14 | Crane | Texas | 48103 | 70 | 2 |
436893 | 436893 | 2020-08-15 | Crane | Texas | 48103 | 70 | 2 |
440119 | 440119 | 2020-08-16 | Crane | Texas | 48103 | 70 | 2 |
443345 | 443345 | 2020-08-17 | Crane | Texas | 48103 | 70 | 2 |
446572 | 446572 | 2020-08-18 | Crane | Texas | 48103 | 70 | 2 |
449800 | 449800 | 2020-08-19 | Crane | Texas | 48103 | 70 | 2 |
453028 | 453028 | 2020-08-20 | Crane | Texas | 48103 | 71 | 2 |
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);