ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 28013 and state = "Mississippi" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
11555 | 11555 | 2020-03-25 | Calhoun | Mississippi | 28013 | 1 | 0 |
13147 | 13147 | 2020-03-26 | Calhoun | Mississippi | 28013 | 3 | 0 |
14863 | 14863 | 2020-03-27 | Calhoun | Mississippi | 28013 | 3 | 0 |
16685 | 16685 | 2020-03-28 | Calhoun | Mississippi | 28013 | 3 | 0 |
18605 | 18605 | 2020-03-29 | Calhoun | Mississippi | 28013 | 3 | 0 |
20629 | 20629 | 2020-03-30 | Calhoun | Mississippi | 28013 | 3 | 0 |
22746 | 22746 | 2020-03-31 | Calhoun | Mississippi | 28013 | 3 | 0 |
24929 | 24929 | 2020-04-01 | Calhoun | Mississippi | 28013 | 3 | 0 |
27183 | 27183 | 2020-04-02 | Calhoun | Mississippi | 28013 | 4 | 0 |
29502 | 29502 | 2020-04-03 | Calhoun | Mississippi | 28013 | 4 | 0 |
31882 | 31882 | 2020-04-04 | Calhoun | Mississippi | 28013 | 4 | 0 |
34309 | 34309 | 2020-04-05 | Calhoun | Mississippi | 28013 | 4 | 0 |
36771 | 36771 | 2020-04-06 | Calhoun | Mississippi | 28013 | 9 | 0 |
39282 | 39282 | 2020-04-07 | Calhoun | Mississippi | 28013 | 10 | 0 |
41836 | 41836 | 2020-04-08 | Calhoun | Mississippi | 28013 | 13 | 0 |
44412 | 44412 | 2020-04-09 | Calhoun | Mississippi | 28013 | 13 | 0 |
47021 | 47021 | 2020-04-10 | Calhoun | Mississippi | 28013 | 13 | 0 |
49667 | 49667 | 2020-04-11 | Calhoun | Mississippi | 28013 | 14 | 0 |
52340 | 52340 | 2020-04-12 | Calhoun | Mississippi | 28013 | 18 | 0 |
55022 | 55022 | 2020-04-13 | Calhoun | Mississippi | 28013 | 24 | 0 |
57720 | 57720 | 2020-04-14 | Calhoun | Mississippi | 28013 | 25 | 1 |
60431 | 60431 | 2020-04-15 | Calhoun | Mississippi | 28013 | 27 | 2 |
63153 | 63153 | 2020-04-16 | Calhoun | Mississippi | 28013 | 30 | 2 |
65893 | 65893 | 2020-04-17 | Calhoun | Mississippi | 28013 | 32 | 2 |
68645 | 68645 | 2020-04-18 | Calhoun | Mississippi | 28013 | 36 | 2 |
71411 | 71411 | 2020-04-19 | Calhoun | Mississippi | 28013 | 39 | 2 |
74184 | 74184 | 2020-04-20 | Calhoun | Mississippi | 28013 | 42 | 2 |
76965 | 76965 | 2020-04-21 | Calhoun | Mississippi | 28013 | 42 | 2 |
79750 | 79750 | 2020-04-22 | Calhoun | Mississippi | 28013 | 43 | 2 |
82546 | 82546 | 2020-04-23 | Calhoun | Mississippi | 28013 | 43 | 2 |
85350 | 85350 | 2020-04-24 | Calhoun | Mississippi | 28013 | 46 | 3 |
88160 | 88160 | 2020-04-25 | Calhoun | Mississippi | 28013 | 48 | 3 |
90976 | 90976 | 2020-04-26 | Calhoun | Mississippi | 28013 | 50 | 3 |
93797 | 93797 | 2020-04-27 | Calhoun | Mississippi | 28013 | 50 | 3 |
96633 | 96633 | 2020-04-28 | Calhoun | Mississippi | 28013 | 50 | 3 |
99479 | 99479 | 2020-04-29 | Calhoun | Mississippi | 28013 | 51 | 3 |
102331 | 102331 | 2020-04-30 | Calhoun | Mississippi | 28013 | 50 | 3 |
105192 | 105192 | 2020-05-01 | Calhoun | Mississippi | 28013 | 52 | 3 |
108057 | 108057 | 2020-05-02 | Calhoun | Mississippi | 28013 | 54 | 3 |
110928 | 110928 | 2020-05-03 | Calhoun | Mississippi | 28013 | 55 | 4 |
113807 | 113807 | 2020-05-04 | Calhoun | Mississippi | 28013 | 56 | 4 |
116689 | 116689 | 2020-05-05 | Calhoun | Mississippi | 28013 | 58 | 4 |
119649 | 119649 | 2020-05-06 | Calhoun | Mississippi | 28013 | 57 | 4 |
122623 | 122623 | 2020-05-07 | Calhoun | Mississippi | 28013 | 57 | 4 |
125605 | 125605 | 2020-05-08 | Calhoun | Mississippi | 28013 | 57 | 4 |
128592 | 128592 | 2020-05-09 | Calhoun | Mississippi | 28013 | 57 | 4 |
131582 | 131582 | 2020-05-10 | Calhoun | Mississippi | 28013 | 57 | 4 |
134573 | 134573 | 2020-05-11 | Calhoun | Mississippi | 28013 | 58 | 4 |
137563 | 137563 | 2020-05-12 | Calhoun | Mississippi | 28013 | 58 | 4 |
140557 | 140557 | 2020-05-13 | Calhoun | Mississippi | 28013 | 58 | 4 |
143552 | 143552 | 2020-05-14 | Calhoun | Mississippi | 28013 | 58 | 4 |
146552 | 146552 | 2020-05-15 | Calhoun | Mississippi | 28013 | 58 | 4 |
149557 | 149557 | 2020-05-16 | Calhoun | Mississippi | 28013 | 58 | 4 |
152568 | 152568 | 2020-05-17 | Calhoun | Mississippi | 28013 | 58 | 4 |
155582 | 155582 | 2020-05-18 | Calhoun | Mississippi | 28013 | 58 | 4 |
158600 | 158600 | 2020-05-19 | Calhoun | Mississippi | 28013 | 59 | 4 |
161626 | 161626 | 2020-05-20 | Calhoun | Mississippi | 28013 | 59 | 4 |
164655 | 164655 | 2020-05-21 | Calhoun | Mississippi | 28013 | 61 | 4 |
167691 | 167691 | 2020-05-22 | Calhoun | Mississippi | 28013 | 60 | 4 |
170729 | 170729 | 2020-05-23 | Calhoun | Mississippi | 28013 | 60 | 4 |
173771 | 173771 | 2020-05-24 | Calhoun | Mississippi | 28013 | 60 | 4 |
176814 | 176814 | 2020-05-25 | Calhoun | Mississippi | 28013 | 60 | 4 |
179858 | 179858 | 2020-05-26 | Calhoun | Mississippi | 28013 | 60 | 4 |
182904 | 182904 | 2020-05-27 | Calhoun | Mississippi | 28013 | 61 | 4 |
185960 | 185960 | 2020-05-28 | Calhoun | Mississippi | 28013 | 63 | 4 |
189018 | 189018 | 2020-05-29 | Calhoun | Mississippi | 28013 | 63 | 4 |
192082 | 192082 | 2020-05-30 | Calhoun | Mississippi | 28013 | 64 | 4 |
195150 | 195150 | 2020-05-31 | Calhoun | Mississippi | 28013 | 65 | 4 |
198221 | 198221 | 2020-06-01 | Calhoun | Mississippi | 28013 | 65 | 4 |
201294 | 201294 | 2020-06-02 | Calhoun | Mississippi | 28013 | 67 | 4 |
204371 | 204371 | 2020-06-03 | Calhoun | Mississippi | 28013 | 67 | 4 |
207452 | 207452 | 2020-06-04 | Calhoun | Mississippi | 28013 | 67 | 4 |
210533 | 210533 | 2020-06-05 | Calhoun | Mississippi | 28013 | 68 | 4 |
213617 | 213617 | 2020-06-06 | Calhoun | Mississippi | 28013 | 68 | 4 |
216705 | 216705 | 2020-06-07 | Calhoun | Mississippi | 28013 | 70 | 4 |
219797 | 219797 | 2020-06-08 | Calhoun | Mississippi | 28013 | 72 | 4 |
222892 | 222892 | 2020-06-09 | Calhoun | Mississippi | 28013 | 74 | 4 |
225990 | 225990 | 2020-06-10 | Calhoun | Mississippi | 28013 | 75 | 4 |
229092 | 229092 | 2020-06-11 | Calhoun | Mississippi | 28013 | 75 | 4 |
232196 | 232196 | 2020-06-12 | Calhoun | Mississippi | 28013 | 77 | 4 |
235302 | 235302 | 2020-06-13 | Calhoun | Mississippi | 28013 | 78 | 4 |
238409 | 238409 | 2020-06-14 | Calhoun | Mississippi | 28013 | 80 | 4 |
241518 | 241518 | 2020-06-15 | Calhoun | Mississippi | 28013 | 80 | 4 |
244629 | 244629 | 2020-06-16 | Calhoun | Mississippi | 28013 | 82 | 4 |
247742 | 247742 | 2020-06-17 | Calhoun | Mississippi | 28013 | 83 | 4 |
250854 | 250854 | 2020-06-18 | Calhoun | Mississippi | 28013 | 83 | 4 |
253969 | 253969 | 2020-06-19 | Calhoun | Mississippi | 28013 | 83 | 4 |
257089 | 257089 | 2020-06-20 | Calhoun | Mississippi | 28013 | 83 | 4 |
260215 | 260215 | 2020-06-21 | Calhoun | Mississippi | 28013 | 83 | 4 |
263344 | 263344 | 2020-06-22 | Calhoun | Mississippi | 28013 | 96 | 4 |
266470 | 266470 | 2020-06-23 | Calhoun | Mississippi | 28013 | 99 | 4 |
269603 | 269603 | 2020-06-24 | Calhoun | Mississippi | 28013 | 100 | 4 |
272740 | 272740 | 2020-06-25 | Calhoun | Mississippi | 28013 | 108 | 4 |
275883 | 275883 | 2020-06-26 | Calhoun | Mississippi | 28013 | 108 | 4 |
279031 | 279031 | 2020-06-27 | Calhoun | Mississippi | 28013 | 110 | 4 |
282179 | 282179 | 2020-06-28 | Calhoun | Mississippi | 28013 | 110 | 4 |
285324 | 285324 | 2020-06-29 | Calhoun | Mississippi | 28013 | 114 | 4 |
288474 | 288474 | 2020-06-30 | Calhoun | Mississippi | 28013 | 119 | 4 |
291625 | 291625 | 2020-07-01 | Calhoun | Mississippi | 28013 | 124 | 4 |
294779 | 294779 | 2020-07-02 | Calhoun | Mississippi | 28013 | 124 | 4 |
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);