ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 48027 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
1879 | 1879 | 2020-03-13 | Bell | Texas | 48027 | 1 | 0 |
2244 | 2244 | 2020-03-14 | Bell | Texas | 48027 | 1 | 0 |
2669 | 2669 | 2020-03-15 | Bell | Texas | 48027 | 1 | 0 |
3136 | 3136 | 2020-03-16 | Bell | Texas | 48027 | 1 | 0 |
3669 | 3669 | 2020-03-17 | Bell | Texas | 48027 | 1 | 0 |
4292 | 4292 | 2020-03-18 | Bell | Texas | 48027 | 1 | 0 |
5043 | 5043 | 2020-03-19 | Bell | Texas | 48027 | 1 | 0 |
5932 | 5932 | 2020-03-20 | Bell | Texas | 48027 | 2 | 0 |
6950 | 6950 | 2020-03-21 | Bell | Texas | 48027 | 8 | 0 |
8080 | 8080 | 2020-03-22 | Bell | Texas | 48027 | 8 | 0 |
9298 | 9298 | 2020-03-23 | Bell | Texas | 48027 | 8 | 0 |
10632 | 10632 | 2020-03-24 | Bell | Texas | 48027 | 8 | 0 |
12114 | 12114 | 2020-03-25 | Bell | Texas | 48027 | 18 | 0 |
13742 | 13742 | 2020-03-26 | Bell | Texas | 48027 | 20 | 1 |
15495 | 15495 | 2020-03-27 | Bell | Texas | 48027 | 25 | 1 |
17362 | 17362 | 2020-03-28 | Bell | Texas | 48027 | 28 | 1 |
19312 | 19312 | 2020-03-29 | Bell | Texas | 48027 | 28 | 1 |
21371 | 21371 | 2020-03-30 | Bell | Texas | 48027 | 28 | 1 |
23510 | 23510 | 2020-03-31 | Bell | Texas | 48027 | 36 | 1 |
25714 | 25714 | 2020-04-01 | Bell | Texas | 48027 | 44 | 1 |
27994 | 27994 | 2020-04-02 | Bell | Texas | 48027 | 46 | 1 |
30329 | 30329 | 2020-04-03 | Bell | Texas | 48027 | 51 | 1 |
32722 | 32722 | 2020-04-04 | Bell | Texas | 48027 | 51 | 1 |
35160 | 35160 | 2020-04-05 | Bell | Texas | 48027 | 58 | 1 |
37636 | 37636 | 2020-04-06 | Bell | Texas | 48027 | 68 | 2 |
40158 | 40158 | 2020-04-07 | Bell | Texas | 48027 | 68 | 2 |
42721 | 42721 | 2020-04-08 | Bell | Texas | 48027 | 74 | 2 |
45310 | 45310 | 2020-04-09 | Bell | Texas | 48027 | 84 | 3 |
47928 | 47928 | 2020-04-10 | Bell | Texas | 48027 | 84 | 3 |
50585 | 50585 | 2020-04-11 | Bell | Texas | 48027 | 91 | 3 |
53260 | 53260 | 2020-04-12 | Bell | Texas | 48027 | 101 | 3 |
55948 | 55948 | 2020-04-13 | Bell | Texas | 48027 | 101 | 3 |
58652 | 58652 | 2020-04-14 | Bell | Texas | 48027 | 107 | 3 |
61368 | 61368 | 2020-04-15 | Bell | Texas | 48027 | 110 | 3 |
64095 | 64095 | 2020-04-16 | Bell | Texas | 48027 | 115 | 3 |
66842 | 66842 | 2020-04-17 | Bell | Texas | 48027 | 124 | 3 |
69601 | 69601 | 2020-04-18 | Bell | Texas | 48027 | 126 | 3 |
72368 | 72368 | 2020-04-19 | Bell | Texas | 48027 | 126 | 3 |
75143 | 75143 | 2020-04-20 | Bell | Texas | 48027 | 126 | 3 |
77925 | 77925 | 2020-04-21 | Bell | Texas | 48027 | 135 | 3 |
80715 | 80715 | 2020-04-22 | Bell | Texas | 48027 | 145 | 3 |
83514 | 83514 | 2020-04-23 | Bell | Texas | 48027 | 153 | 3 |
86319 | 86319 | 2020-04-24 | Bell | Texas | 48027 | 161 | 3 |
89134 | 89134 | 2020-04-25 | Bell | Texas | 48027 | 165 | 3 |
91951 | 91951 | 2020-04-26 | Bell | Texas | 48027 | 165 | 3 |
94779 | 94779 | 2020-04-27 | Bell | Texas | 48027 | 165 | 3 |
97619 | 97619 | 2020-04-28 | Bell | Texas | 48027 | 173 | 3 |
100469 | 100469 | 2020-04-29 | Bell | Texas | 48027 | 180 | 3 |
103322 | 103322 | 2020-04-30 | Bell | Texas | 48027 | 189 | 3 |
106185 | 106185 | 2020-05-01 | Bell | Texas | 48027 | 189 | 3 |
109052 | 109052 | 2020-05-02 | Bell | Texas | 48027 | 193 | 3 |
111926 | 111926 | 2020-05-03 | Bell | Texas | 48027 | 194 | 3 |
114808 | 114808 | 2020-05-04 | Bell | Texas | 48027 | 194 | 3 |
117765 | 117765 | 2020-05-05 | Bell | Texas | 48027 | 210 | 3 |
120729 | 120729 | 2020-05-06 | Bell | Texas | 48027 | 210 | 3 |
123708 | 123708 | 2020-05-07 | Bell | Texas | 48027 | 213 | 3 |
126691 | 126691 | 2020-05-08 | Bell | Texas | 48027 | 218 | 3 |
129680 | 129680 | 2020-05-09 | Bell | Texas | 48027 | 220 | 3 |
132670 | 132670 | 2020-05-10 | Bell | Texas | 48027 | 220 | 3 |
135661 | 135661 | 2020-05-11 | Bell | Texas | 48027 | 220 | 3 |
138651 | 138651 | 2020-05-12 | Bell | Texas | 48027 | 223 | 3 |
141647 | 141647 | 2020-05-13 | Bell | Texas | 48027 | 231 | 3 |
144644 | 144644 | 2020-05-14 | Bell | Texas | 48027 | 237 | 3 |
147646 | 147646 | 2020-05-15 | Bell | Texas | 48027 | 242 | 3 |
150654 | 150654 | 2020-05-16 | Bell | Texas | 48027 | 248 | 3 |
153665 | 153665 | 2020-05-17 | Bell | Texas | 48027 | 248 | 3 |
156682 | 156682 | 2020-05-18 | Bell | Texas | 48027 | 248 | 3 |
159704 | 159704 | 2020-05-19 | Bell | Texas | 48027 | 260 | 3 |
162731 | 162731 | 2020-05-20 | Bell | Texas | 48027 | 267 | 3 |
165760 | 165760 | 2020-05-21 | Bell | Texas | 48027 | 282 | 3 |
168796 | 168796 | 2020-05-22 | Bell | Texas | 48027 | 282 | 3 |
171835 | 171835 | 2020-05-23 | Bell | Texas | 48027 | 298 | 3 |
174878 | 174878 | 2020-05-24 | Bell | Texas | 48027 | 298 | 3 |
177922 | 177922 | 2020-05-25 | Bell | Texas | 48027 | 298 | 3 |
180965 | 180965 | 2020-05-26 | Bell | Texas | 48027 | 309 | 3 |
184015 | 184015 | 2020-05-27 | Bell | Texas | 48027 | 329 | 3 |
187072 | 187072 | 2020-05-28 | Bell | Texas | 48027 | 335 | 3 |
190136 | 190136 | 2020-05-29 | Bell | Texas | 48027 | 345 | 3 |
193201 | 193201 | 2020-05-30 | Bell | Texas | 48027 | 356 | 4 |
196271 | 196271 | 2020-05-31 | Bell | Texas | 48027 | 362 | 4 |
199344 | 199344 | 2020-06-01 | Bell | Texas | 48027 | 378 | 4 |
202419 | 202419 | 2020-06-02 | Bell | Texas | 48027 | 391 | 4 |
205498 | 205498 | 2020-06-03 | Bell | Texas | 48027 | 411 | 5 |
208580 | 208580 | 2020-06-04 | Bell | Texas | 48027 | 423 | 5 |
211663 | 211663 | 2020-06-05 | Bell | Texas | 48027 | 432 | 5 |
214750 | 214750 | 2020-06-06 | Bell | Texas | 48027 | 446 | 5 |
217840 | 217840 | 2020-06-07 | Bell | Texas | 48027 | 446 | 5 |
220932 | 220932 | 2020-06-08 | Bell | Texas | 48027 | 446 | 5 |
224027 | 224027 | 2020-06-09 | Bell | Texas | 48027 | 476 | 6 |
227127 | 227127 | 2020-06-10 | Bell | Texas | 48027 | 507 | 6 |
230231 | 230231 | 2020-06-11 | Bell | Texas | 48027 | 530 | 6 |
233335 | 233335 | 2020-06-12 | Bell | Texas | 48027 | 574 | 6 |
236441 | 236441 | 2020-06-13 | Bell | Texas | 48027 | 605 | 6 |
239549 | 239549 | 2020-06-14 | Bell | Texas | 48027 | 629 | 6 |
242659 | 242659 | 2020-06-15 | Bell | Texas | 48027 | 629 | 7 |
245771 | 245771 | 2020-06-16 | Bell | Texas | 48027 | 651 | 7 |
248884 | 248884 | 2020-06-17 | Bell | Texas | 48027 | 672 | 9 |
251999 | 251999 | 2020-06-18 | Bell | Texas | 48027 | 722 | 9 |
255114 | 255114 | 2020-06-19 | Bell | Texas | 48027 | 769 | 10 |
258240 | 258240 | 2020-06-20 | Bell | Texas | 48027 | 818 | 10 |
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);