ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 28139 sorted by county descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5629 | 5629 | 2020-03-20 | Tippah | Mississippi | 28139 | 3 | 0 |
6613 | 6613 | 2020-03-21 | Tippah | Mississippi | 28139 | 3 | 0 |
7701 | 7701 | 2020-03-22 | Tippah | Mississippi | 28139 | 7 | 0 |
8884 | 8884 | 2020-03-23 | Tippah | Mississippi | 28139 | 9 | 0 |
10182 | 10182 | 2020-03-24 | Tippah | Mississippi | 28139 | 11 | 0 |
11603 | 11603 | 2020-03-25 | Tippah | Mississippi | 28139 | 11 | 0 |
13197 | 13197 | 2020-03-26 | Tippah | Mississippi | 28139 | 14 | 0 |
14917 | 14917 | 2020-03-27 | Tippah | Mississippi | 28139 | 15 | 1 |
16741 | 16741 | 2020-03-28 | Tippah | Mississippi | 28139 | 18 | 2 |
18663 | 18663 | 2020-03-29 | Tippah | Mississippi | 28139 | 23 | 2 |
20687 | 20687 | 2020-03-30 | Tippah | Mississippi | 28139 | 23 | 2 |
22804 | 22804 | 2020-03-31 | Tippah | Mississippi | 28139 | 26 | 2 |
24988 | 24988 | 2020-04-01 | Tippah | Mississippi | 28139 | 28 | 2 |
27242 | 27242 | 2020-04-02 | Tippah | Mississippi | 28139 | 29 | 2 |
29561 | 29561 | 2020-04-03 | Tippah | Mississippi | 28139 | 30 | 3 |
31941 | 31941 | 2020-04-04 | Tippah | Mississippi | 28139 | 31 | 3 |
34369 | 34369 | 2020-04-05 | Tippah | Mississippi | 28139 | 35 | 3 |
36832 | 36832 | 2020-04-06 | Tippah | Mississippi | 28139 | 36 | 3 |
39343 | 39343 | 2020-04-07 | Tippah | Mississippi | 28139 | 36 | 3 |
41897 | 41897 | 2020-04-08 | Tippah | Mississippi | 28139 | 37 | 4 |
44474 | 44474 | 2020-04-09 | Tippah | Mississippi | 28139 | 41 | 6 |
47083 | 47083 | 2020-04-10 | Tippah | Mississippi | 28139 | 42 | 6 |
49729 | 49729 | 2020-04-11 | Tippah | Mississippi | 28139 | 43 | 6 |
52402 | 52402 | 2020-04-12 | Tippah | Mississippi | 28139 | 43 | 6 |
55084 | 55084 | 2020-04-13 | Tippah | Mississippi | 28139 | 44 | 6 |
57782 | 57782 | 2020-04-14 | Tippah | Mississippi | 28139 | 45 | 6 |
60493 | 60493 | 2020-04-15 | Tippah | Mississippi | 28139 | 45 | 6 |
63215 | 63215 | 2020-04-16 | Tippah | Mississippi | 28139 | 45 | 6 |
65955 | 65955 | 2020-04-17 | Tippah | Mississippi | 28139 | 45 | 6 |
68707 | 68707 | 2020-04-18 | Tippah | Mississippi | 28139 | 46 | 7 |
71473 | 71473 | 2020-04-19 | Tippah | Mississippi | 28139 | 47 | 7 |
74246 | 74246 | 2020-04-20 | Tippah | Mississippi | 28139 | 47 | 7 |
77027 | 77027 | 2020-04-21 | Tippah | Mississippi | 28139 | 49 | 7 |
79812 | 79812 | 2020-04-22 | Tippah | Mississippi | 28139 | 49 | 7 |
82608 | 82608 | 2020-04-23 | Tippah | Mississippi | 28139 | 49 | 7 |
85412 | 85412 | 2020-04-24 | Tippah | Mississippi | 28139 | 50 | 7 |
88222 | 88222 | 2020-04-25 | Tippah | Mississippi | 28139 | 51 | 7 |
91038 | 91038 | 2020-04-26 | Tippah | Mississippi | 28139 | 52 | 7 |
93859 | 93859 | 2020-04-27 | Tippah | Mississippi | 28139 | 52 | 7 |
96695 | 96695 | 2020-04-28 | Tippah | Mississippi | 28139 | 53 | 7 |
99541 | 99541 | 2020-04-29 | Tippah | Mississippi | 28139 | 53 | 7 |
102393 | 102393 | 2020-04-30 | Tippah | Mississippi | 28139 | 54 | 7 |
105254 | 105254 | 2020-05-01 | Tippah | Mississippi | 28139 | 56 | 10 |
108119 | 108119 | 2020-05-02 | Tippah | Mississippi | 28139 | 56 | 10 |
110990 | 110990 | 2020-05-03 | Tippah | Mississippi | 28139 | 57 | 10 |
113869 | 113869 | 2020-05-04 | Tippah | Mississippi | 28139 | 58 | 10 |
116751 | 116751 | 2020-05-05 | Tippah | Mississippi | 28139 | 58 | 10 |
119711 | 119711 | 2020-05-06 | Tippah | Mississippi | 28139 | 61 | 10 |
122685 | 122685 | 2020-05-07 | Tippah | Mississippi | 28139 | 61 | 10 |
125667 | 125667 | 2020-05-08 | Tippah | Mississippi | 28139 | 63 | 10 |
128654 | 128654 | 2020-05-09 | Tippah | Mississippi | 28139 | 65 | 11 |
131644 | 131644 | 2020-05-10 | Tippah | Mississippi | 28139 | 65 | 11 |
134635 | 134635 | 2020-05-11 | Tippah | Mississippi | 28139 | 66 | 11 |
137625 | 137625 | 2020-05-12 | Tippah | Mississippi | 28139 | 66 | 11 |
140619 | 140619 | 2020-05-13 | Tippah | Mississippi | 28139 | 66 | 11 |
143614 | 143614 | 2020-05-14 | Tippah | Mississippi | 28139 | 66 | 11 |
146614 | 146614 | 2020-05-15 | Tippah | Mississippi | 28139 | 67 | 11 |
149619 | 149619 | 2020-05-16 | Tippah | Mississippi | 28139 | 69 | 11 |
152630 | 152630 | 2020-05-17 | Tippah | Mississippi | 28139 | 69 | 11 |
155644 | 155644 | 2020-05-18 | Tippah | Mississippi | 28139 | 69 | 11 |
158662 | 158662 | 2020-05-19 | Tippah | Mississippi | 28139 | 69 | 11 |
161688 | 161688 | 2020-05-20 | Tippah | Mississippi | 28139 | 69 | 11 |
164717 | 164717 | 2020-05-21 | Tippah | Mississippi | 28139 | 69 | 11 |
167753 | 167753 | 2020-05-22 | Tippah | Mississippi | 28139 | 69 | 11 |
170791 | 170791 | 2020-05-23 | Tippah | Mississippi | 28139 | 69 | 11 |
173833 | 173833 | 2020-05-24 | Tippah | Mississippi | 28139 | 70 | 11 |
176876 | 176876 | 2020-05-25 | Tippah | Mississippi | 28139 | 70 | 11 |
179920 | 179920 | 2020-05-26 | Tippah | Mississippi | 28139 | 71 | 11 |
182966 | 182966 | 2020-05-27 | Tippah | Mississippi | 28139 | 71 | 11 |
186022 | 186022 | 2020-05-28 | Tippah | Mississippi | 28139 | 71 | 11 |
189080 | 189080 | 2020-05-29 | Tippah | Mississippi | 28139 | 71 | 11 |
192144 | 192144 | 2020-05-30 | Tippah | Mississippi | 28139 | 73 | 11 |
195212 | 195212 | 2020-05-31 | Tippah | Mississippi | 28139 | 73 | 11 |
198283 | 198283 | 2020-06-01 | Tippah | Mississippi | 28139 | 73 | 11 |
201356 | 201356 | 2020-06-02 | Tippah | Mississippi | 28139 | 76 | 11 |
204433 | 204433 | 2020-06-03 | Tippah | Mississippi | 28139 | 76 | 11 |
207514 | 207514 | 2020-06-04 | Tippah | Mississippi | 28139 | 76 | 11 |
210595 | 210595 | 2020-06-05 | Tippah | Mississippi | 28139 | 76 | 11 |
213679 | 213679 | 2020-06-06 | Tippah | Mississippi | 28139 | 79 | 11 |
216767 | 216767 | 2020-06-07 | Tippah | Mississippi | 28139 | 80 | 11 |
219859 | 219859 | 2020-06-08 | Tippah | Mississippi | 28139 | 84 | 11 |
222954 | 222954 | 2020-06-09 | Tippah | Mississippi | 28139 | 87 | 11 |
226052 | 226052 | 2020-06-10 | Tippah | Mississippi | 28139 | 90 | 11 |
229154 | 229154 | 2020-06-11 | Tippah | Mississippi | 28139 | 90 | 11 |
232258 | 232258 | 2020-06-12 | Tippah | Mississippi | 28139 | 92 | 11 |
235364 | 235364 | 2020-06-13 | Tippah | Mississippi | 28139 | 93 | 11 |
238471 | 238471 | 2020-06-14 | Tippah | Mississippi | 28139 | 93 | 11 |
241580 | 241580 | 2020-06-15 | Tippah | Mississippi | 28139 | 94 | 11 |
244691 | 244691 | 2020-06-16 | Tippah | Mississippi | 28139 | 95 | 11 |
247804 | 247804 | 2020-06-17 | Tippah | Mississippi | 28139 | 100 | 11 |
250916 | 250916 | 2020-06-18 | Tippah | Mississippi | 28139 | 100 | 11 |
254031 | 254031 | 2020-06-19 | Tippah | Mississippi | 28139 | 100 | 11 |
257151 | 257151 | 2020-06-20 | Tippah | Mississippi | 28139 | 100 | 11 |
260277 | 260277 | 2020-06-21 | Tippah | Mississippi | 28139 | 100 | 11 |
263406 | 263406 | 2020-06-22 | Tippah | Mississippi | 28139 | 106 | 11 |
266532 | 266532 | 2020-06-23 | Tippah | Mississippi | 28139 | 107 | 11 |
269665 | 269665 | 2020-06-24 | Tippah | Mississippi | 28139 | 109 | 11 |
272803 | 272803 | 2020-06-25 | Tippah | Mississippi | 28139 | 115 | 11 |
275946 | 275946 | 2020-06-26 | Tippah | Mississippi | 28139 | 116 | 11 |
279094 | 279094 | 2020-06-27 | Tippah | Mississippi | 28139 | 116 | 11 |
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);