ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Gibson" and fips = 47053 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
8051 | 8051 | 2020-03-22 | Gibson | Tennessee | 47053 | 1 | 0 |
9269 | 9269 | 2020-03-23 | Gibson | Tennessee | 47053 | 1 | 0 |
10598 | 10598 | 2020-03-24 | Gibson | Tennessee | 47053 | 2 | 0 |
12075 | 12075 | 2020-03-25 | Gibson | Tennessee | 47053 | 2 | 0 |
13699 | 13699 | 2020-03-26 | Gibson | Tennessee | 47053 | 2 | 0 |
15451 | 15451 | 2020-03-27 | Gibson | Tennessee | 47053 | 2 | 0 |
17312 | 17312 | 2020-03-28 | Gibson | Tennessee | 47053 | 2 | 0 |
19258 | 19258 | 2020-03-29 | Gibson | Tennessee | 47053 | 3 | 0 |
21312 | 21312 | 2020-03-30 | Gibson | Tennessee | 47053 | 5 | 0 |
23450 | 23450 | 2020-03-31 | Gibson | Tennessee | 47053 | 6 | 0 |
25649 | 25649 | 2020-04-01 | Gibson | Tennessee | 47053 | 6 | 0 |
27927 | 27927 | 2020-04-02 | Gibson | Tennessee | 47053 | 6 | 0 |
30262 | 30262 | 2020-04-03 | Gibson | Tennessee | 47053 | 7 | 0 |
32653 | 32653 | 2020-04-04 | Gibson | Tennessee | 47053 | 8 | 0 |
35089 | 35089 | 2020-04-05 | Gibson | Tennessee | 47053 | 11 | 0 |
37565 | 37565 | 2020-04-06 | Gibson | Tennessee | 47053 | 12 | 0 |
40088 | 40088 | 2020-04-07 | Gibson | Tennessee | 47053 | 13 | 0 |
42650 | 42650 | 2020-04-08 | Gibson | Tennessee | 47053 | 13 | 0 |
45237 | 45237 | 2020-04-09 | Gibson | Tennessee | 47053 | 16 | 0 |
47855 | 47855 | 2020-04-10 | Gibson | Tennessee | 47053 | 18 | 0 |
50513 | 50513 | 2020-04-11 | Gibson | Tennessee | 47053 | 19 | 0 |
53188 | 53188 | 2020-04-12 | Gibson | Tennessee | 47053 | 19 | 0 |
55874 | 55874 | 2020-04-13 | Gibson | Tennessee | 47053 | 20 | 0 |
58577 | 58577 | 2020-04-14 | Gibson | Tennessee | 47053 | 21 | 0 |
61292 | 61292 | 2020-04-15 | Gibson | Tennessee | 47053 | 24 | 0 |
64019 | 64019 | 2020-04-16 | Gibson | Tennessee | 47053 | 25 | 0 |
66765 | 66765 | 2020-04-17 | Gibson | Tennessee | 47053 | 27 | 0 |
69524 | 69524 | 2020-04-18 | Gibson | Tennessee | 47053 | 28 | 0 |
72291 | 72291 | 2020-04-19 | Gibson | Tennessee | 47053 | 31 | 0 |
75066 | 75066 | 2020-04-20 | Gibson | Tennessee | 47053 | 31 | 0 |
77848 | 77848 | 2020-04-21 | Gibson | Tennessee | 47053 | 32 | 0 |
83437 | 83437 | 2020-04-23 | Gibson | Tennessee | 47053 | 32 | 1 |
80638 | 80638 | 2020-04-22 | Gibson | Tennessee | 47053 | 33 | 1 |
86242 | 86242 | 2020-04-24 | Gibson | Tennessee | 47053 | 34 | 1 |
89057 | 89057 | 2020-04-25 | Gibson | Tennessee | 47053 | 35 | 1 |
91874 | 91874 | 2020-04-26 | Gibson | Tennessee | 47053 | 38 | 1 |
94702 | 94702 | 2020-04-27 | Gibson | Tennessee | 47053 | 41 | 1 |
97542 | 97542 | 2020-04-28 | Gibson | Tennessee | 47053 | 41 | 1 |
103245 | 103245 | 2020-04-30 | Gibson | Tennessee | 47053 | 43 | 1 |
100392 | 100392 | 2020-04-29 | Gibson | Tennessee | 47053 | 44 | 1 |
106108 | 106108 | 2020-05-01 | Gibson | Tennessee | 47053 | 45 | 1 |
108975 | 108975 | 2020-05-02 | Gibson | Tennessee | 47053 | 48 | 1 |
111849 | 111849 | 2020-05-03 | Gibson | Tennessee | 47053 | 50 | 1 |
120651 | 120651 | 2020-05-06 | Gibson | Tennessee | 47053 | 50 | 1 |
123629 | 123629 | 2020-05-07 | Gibson | Tennessee | 47053 | 52 | 1 |
126612 | 126612 | 2020-05-08 | Gibson | Tennessee | 47053 | 52 | 1 |
114731 | 114731 | 2020-05-04 | Gibson | Tennessee | 47053 | 53 | 1 |
117687 | 117687 | 2020-05-05 | Gibson | Tennessee | 47053 | 53 | 1 |
129601 | 129601 | 2020-05-09 | Gibson | Tennessee | 47053 | 53 | 1 |
132590 | 132590 | 2020-05-10 | Gibson | Tennessee | 47053 | 54 | 1 |
135581 | 135581 | 2020-05-11 | Gibson | Tennessee | 47053 | 56 | 1 |
138571 | 138571 | 2020-05-12 | Gibson | Tennessee | 47053 | 57 | 1 |
141567 | 141567 | 2020-05-13 | Gibson | Tennessee | 47053 | 57 | 1 |
144564 | 144564 | 2020-05-14 | Gibson | Tennessee | 47053 | 57 | 1 |
147565 | 147565 | 2020-05-15 | Gibson | Tennessee | 47053 | 57 | 1 |
150573 | 150573 | 2020-05-16 | Gibson | Tennessee | 47053 | 58 | 1 |
153584 | 153584 | 2020-05-17 | Gibson | Tennessee | 47053 | 58 | 1 |
156601 | 156601 | 2020-05-18 | Gibson | Tennessee | 47053 | 59 | 1 |
159622 | 159622 | 2020-05-19 | Gibson | Tennessee | 47053 | 59 | 1 |
162649 | 162649 | 2020-05-20 | Gibson | Tennessee | 47053 | 59 | 1 |
165678 | 165678 | 2020-05-21 | Gibson | Tennessee | 47053 | 59 | 1 |
168714 | 168714 | 2020-05-22 | Gibson | Tennessee | 47053 | 60 | 1 |
174796 | 174796 | 2020-05-24 | Gibson | Tennessee | 47053 | 60 | 1 |
177840 | 177840 | 2020-05-25 | Gibson | Tennessee | 47053 | 60 | 1 |
183933 | 183933 | 2020-05-27 | Gibson | Tennessee | 47053 | 60 | 1 |
171753 | 171753 | 2020-05-23 | Gibson | Tennessee | 47053 | 61 | 1 |
180883 | 180883 | 2020-05-26 | Gibson | Tennessee | 47053 | 61 | 1 |
186990 | 186990 | 2020-05-28 | Gibson | Tennessee | 47053 | 61 | 1 |
190054 | 190054 | 2020-05-29 | Gibson | Tennessee | 47053 | 62 | 1 |
202337 | 202337 | 2020-06-02 | Gibson | Tennessee | 47053 | 62 | 1 |
193119 | 193119 | 2020-05-30 | Gibson | Tennessee | 47053 | 63 | 1 |
196189 | 196189 | 2020-05-31 | Gibson | Tennessee | 47053 | 63 | 1 |
199262 | 199262 | 2020-06-01 | Gibson | Tennessee | 47053 | 63 | 1 |
205416 | 205416 | 2020-06-03 | Gibson | Tennessee | 47053 | 63 | 1 |
208498 | 208498 | 2020-06-04 | Gibson | Tennessee | 47053 | 63 | 1 |
211580 | 211580 | 2020-06-05 | Gibson | Tennessee | 47053 | 63 | 1 |
214667 | 214667 | 2020-06-06 | Gibson | Tennessee | 47053 | 63 | 1 |
217757 | 217757 | 2020-06-07 | Gibson | Tennessee | 47053 | 63 | 1 |
220849 | 220849 | 2020-06-08 | Gibson | Tennessee | 47053 | 64 | 1 |
223944 | 223944 | 2020-06-09 | Gibson | Tennessee | 47053 | 64 | 1 |
227044 | 227044 | 2020-06-10 | Gibson | Tennessee | 47053 | 64 | 1 |
230148 | 230148 | 2020-06-11 | Gibson | Tennessee | 47053 | 64 | 1 |
233253 | 233253 | 2020-06-12 | Gibson | Tennessee | 47053 | 68 | 1 |
236359 | 236359 | 2020-06-13 | Gibson | Tennessee | 47053 | 68 | 1 |
239467 | 239467 | 2020-06-14 | Gibson | Tennessee | 47053 | 68 | 1 |
242577 | 242577 | 2020-06-15 | Gibson | Tennessee | 47053 | 69 | 1 |
245689 | 245689 | 2020-06-16 | Gibson | Tennessee | 47053 | 69 | 1 |
248802 | 248802 | 2020-06-17 | Gibson | Tennessee | 47053 | 69 | 1 |
251917 | 251917 | 2020-06-18 | Gibson | Tennessee | 47053 | 70 | 1 |
255032 | 255032 | 2020-06-19 | Gibson | Tennessee | 47053 | 74 | 1 |
258158 | 258158 | 2020-06-20 | Gibson | Tennessee | 47053 | 75 | 1 |
261285 | 261285 | 2020-06-21 | Gibson | Tennessee | 47053 | 77 | 1 |
264413 | 264413 | 2020-06-22 | Gibson | Tennessee | 47053 | 77 | 1 |
267541 | 267541 | 2020-06-23 | Gibson | Tennessee | 47053 | 80 | 1 |
270675 | 270675 | 2020-06-24 | Gibson | Tennessee | 47053 | 80 | 1 |
273814 | 273814 | 2020-06-25 | Gibson | Tennessee | 47053 | 83 | 1 |
276961 | 276961 | 2020-06-26 | Gibson | Tennessee | 47053 | 84 | 1 |
280109 | 280109 | 2020-06-27 | Gibson | Tennessee | 47053 | 90 | 1 |
283255 | 283255 | 2020-06-28 | Gibson | Tennessee | 47053 | 90 | 1 |
286400 | 286400 | 2020-06-29 | Gibson | Tennessee | 47053 | 97 | 1 |
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);