ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Ray" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501166 | 2501166 | 2022-05-13 | Ray | Missouri | 29177 | 5221 | 94 |
2497908 | 2497908 | 2022-05-12 | Ray | Missouri | 29177 | 5204 | 94 |
2494650 | 2494650 | 2022-05-11 | Ray | Missouri | 29177 | 5204 | 94 |
2491392 | 2491392 | 2022-05-10 | Ray | Missouri | 29177 | 5204 | 94 |
2488134 | 2488134 | 2022-05-09 | Ray | Missouri | 29177 | 5204 | 94 |
2484877 | 2484877 | 2022-05-08 | Ray | Missouri | 29177 | 5204 | 94 |
2481619 | 2481619 | 2022-05-07 | Ray | Missouri | 29177 | 5204 | 94 |
2478361 | 2478361 | 2022-05-06 | Ray | Missouri | 29177 | 5204 | 94 |
2475103 | 2475103 | 2022-05-05 | Ray | Missouri | 29177 | 5181 | 93 |
2471846 | 2471846 | 2022-05-04 | Ray | Missouri | 29177 | 5147 | 93 |
2468590 | 2468590 | 2022-05-03 | Ray | Missouri | 29177 | 5147 | 93 |
2465334 | 2465334 | 2022-05-02 | Ray | Missouri | 29177 | 5147 | 93 |
2462079 | 2462079 | 2022-05-01 | Ray | Missouri | 29177 | 5147 | 93 |
2458823 | 2458823 | 2022-04-30 | Ray | Missouri | 29177 | 5147 | 93 |
2455567 | 2455567 | 2022-04-29 | Ray | Missouri | 29177 | 5147 | 93 |
2452311 | 2452311 | 2022-04-28 | Ray | Missouri | 29177 | 5147 | 93 |
2449055 | 2449055 | 2022-04-27 | Ray | Missouri | 29177 | 5147 | 93 |
2445798 | 2445798 | 2022-04-26 | Ray | Missouri | 29177 | 5147 | 93 |
2442543 | 2442543 | 2022-04-25 | Ray | Missouri | 29177 | 5147 | 93 |
2439287 | 2439287 | 2022-04-24 | Ray | Missouri | 29177 | 5147 | 93 |
2436031 | 2436031 | 2022-04-23 | Ray | Missouri | 29177 | 5147 | 93 |
2432775 | 2432775 | 2022-04-22 | Ray | Missouri | 29177 | 5147 | 93 |
2429519 | 2429519 | 2022-04-21 | Ray | Missouri | 29177 | 5147 | 93 |
2426263 | 2426263 | 2022-04-20 | Ray | Missouri | 29177 | 5147 | 93 |
2423007 | 2423007 | 2022-04-19 | Ray | Missouri | 29177 | 5147 | 93 |
2419750 | 2419750 | 2022-04-18 | Ray | Missouri | 29177 | 5147 | 93 |
2416495 | 2416495 | 2022-04-17 | Ray | Missouri | 29177 | 5147 | 93 |
2413239 | 2413239 | 2022-04-16 | Ray | Missouri | 29177 | 5147 | 93 |
2409983 | 2409983 | 2022-04-15 | Ray | Missouri | 29177 | 5147 | 93 |
2406727 | 2406727 | 2022-04-14 | Ray | Missouri | 29177 | 5147 | 93 |
2403471 | 2403471 | 2022-04-13 | Ray | Missouri | 29177 | 5147 | 93 |
2400216 | 2400216 | 2022-04-12 | Ray | Missouri | 29177 | 5147 | 93 |
2396961 | 2396961 | 2022-04-11 | Ray | Missouri | 29177 | 5147 | 93 |
2393706 | 2393706 | 2022-04-10 | Ray | Missouri | 29177 | 5147 | 93 |
2390450 | 2390450 | 2022-04-09 | Ray | Missouri | 29177 | 5147 | 93 |
2387194 | 2387194 | 2022-04-08 | Ray | Missouri | 29177 | 5147 | 93 |
2383939 | 2383939 | 2022-04-07 | Ray | Missouri | 29177 | 5147 | 93 |
2380684 | 2380684 | 2022-04-06 | Ray | Missouri | 29177 | 5147 | 93 |
2377429 | 2377429 | 2022-04-05 | Ray | Missouri | 29177 | 5147 | 93 |
2374176 | 2374176 | 2022-04-04 | Ray | Missouri | 29177 | 5147 | 93 |
2370924 | 2370924 | 2022-04-03 | Ray | Missouri | 29177 | 5147 | 93 |
2367671 | 2367671 | 2022-04-02 | Ray | Missouri | 29177 | 5147 | 93 |
2364418 | 2364418 | 2022-04-01 | Ray | Missouri | 29177 | 5147 | 93 |
2361164 | 2361164 | 2022-03-31 | Ray | Missouri | 29177 | 5147 | 93 |
2357910 | 2357910 | 2022-03-30 | Ray | Missouri | 29177 | 5147 | 93 |
2354657 | 2354657 | 2022-03-29 | Ray | Missouri | 29177 | 5144 | 93 |
2351404 | 2351404 | 2022-03-28 | Ray | Missouri | 29177 | 5144 | 93 |
2348152 | 2348152 | 2022-03-27 | Ray | Missouri | 29177 | 5143 | 93 |
2344899 | 2344899 | 2022-03-26 | Ray | Missouri | 29177 | 5143 | 93 |
2341646 | 2341646 | 2022-03-25 | Ray | Missouri | 29177 | 5143 | 93 |
2338393 | 2338393 | 2022-03-24 | Ray | Missouri | 29177 | 5141 | 93 |
2335139 | 2335139 | 2022-03-23 | Ray | Missouri | 29177 | 5139 | 93 |
2331885 | 2331885 | 2022-03-22 | Ray | Missouri | 29177 | 5139 | 93 |
2328632 | 2328632 | 2022-03-21 | Ray | Missouri | 29177 | 5135 | 90 |
2325380 | 2325380 | 2022-03-20 | Ray | Missouri | 29177 | 5136 | 90 |
2322126 | 2322126 | 2022-03-19 | Ray | Missouri | 29177 | 5136 | 90 |
2318872 | 2318872 | 2022-03-18 | Ray | Missouri | 29177 | 5136 | 90 |
2315619 | 2315619 | 2022-03-17 | Ray | Missouri | 29177 | 5135 | 90 |
2312366 | 2312366 | 2022-03-16 | Ray | Missouri | 29177 | 5135 | 90 |
2309113 | 2309113 | 2022-03-15 | Ray | Missouri | 29177 | 5134 | 90 |
2305861 | 2305861 | 2022-03-14 | Ray | Missouri | 29177 | 5134 | 89 |
2302610 | 2302610 | 2022-03-13 | Ray | Missouri | 29177 | 5132 | 89 |
2299358 | 2299358 | 2022-03-12 | Ray | Missouri | 29177 | 5132 | 89 |
2296106 | 2296106 | 2022-03-11 | Ray | Missouri | 29177 | 5132 | 89 |
2292854 | 2292854 | 2022-03-10 | Ray | Missouri | 29177 | 5132 | 89 |
2289602 | 2289602 | 2022-03-09 | Ray | Missouri | 29177 | 5129 | 89 |
2286350 | 2286350 | 2022-03-08 | Ray | Missouri | 29177 | 5128 | 89 |
2283098 | 2283098 | 2022-03-07 | Ray | Missouri | 29177 | 5127 | 87 |
2279845 | 2279845 | 2022-03-06 | Ray | Missouri | 29177 | 5125 | 89 |
2276592 | 2276592 | 2022-03-05 | Ray | Missouri | 29177 | 5125 | 89 |
2273339 | 2273339 | 2022-03-04 | Ray | Missouri | 29177 | 5125 | 89 |
2270087 | 2270087 | 2022-03-03 | Ray | Missouri | 29177 | 5124 | 90 |
2266834 | 2266834 | 2022-03-02 | Ray | Missouri | 29177 | 5120 | 90 |
2263583 | 2263583 | 2022-03-01 | Ray | Missouri | 29177 | 5111 | 90 |
2260332 | 2260332 | 2022-02-28 | Ray | Missouri | 29177 | 5104 | 89 |
2257081 | 2257081 | 2022-02-27 | Ray | Missouri | 29177 | 5082 | 89 |
2253830 | 2253830 | 2022-02-26 | Ray | Missouri | 29177 | 5082 | 89 |
2250579 | 2250579 | 2022-02-25 | Ray | Missouri | 29177 | 5082 | 89 |
2247328 | 2247328 | 2022-02-24 | Ray | Missouri | 29177 | 5077 | 89 |
2244077 | 2244077 | 2022-02-23 | Ray | Missouri | 29177 | 5071 | 88 |
2240826 | 2240826 | 2022-02-22 | Ray | Missouri | 29177 | 5062 | 88 |
2237575 | 2237575 | 2022-02-21 | Ray | Missouri | 29177 | 5053 | 88 |
2234324 | 2234324 | 2022-02-20 | Ray | Missouri | 29177 | 5053 | 88 |
2231073 | 2231073 | 2022-02-19 | Ray | Missouri | 29177 | 5053 | 88 |
2227822 | 2227822 | 2022-02-18 | Ray | Missouri | 29177 | 5053 | 88 |
2224571 | 2224571 | 2022-02-17 | Ray | Missouri | 29177 | 5053 | 88 |
2221320 | 2221320 | 2022-02-16 | Ray | Missouri | 29177 | 5040 | 88 |
2218069 | 2218069 | 2022-02-15 | Ray | Missouri | 29177 | 5025 | 88 |
2214818 | 2214818 | 2022-02-14 | Ray | Missouri | 29177 | 5019 | 87 |
2211566 | 2211566 | 2022-02-13 | Ray | Missouri | 29177 | 4990 | 87 |
2208313 | 2208313 | 2022-02-12 | Ray | Missouri | 29177 | 4990 | 87 |
2205060 | 2205060 | 2022-02-11 | Ray | Missouri | 29177 | 4990 | 87 |
2201807 | 2201807 | 2022-02-10 | Ray | Missouri | 29177 | 4990 | 87 |
2198553 | 2198553 | 2022-02-09 | Ray | Missouri | 29177 | 4960 | 87 |
2195299 | 2195299 | 2022-02-08 | Ray | Missouri | 29177 | 4933 | 87 |
2192045 | 2192045 | 2022-02-07 | Ray | Missouri | 29177 | 4927 | 84 |
2188792 | 2188792 | 2022-02-06 | Ray | Missouri | 29177 | 4922 | 84 |
2185539 | 2185539 | 2022-02-05 | Ray | Missouri | 29177 | 4916 | 84 |
2182287 | 2182287 | 2022-02-04 | Ray | Missouri | 29177 | 4905 | 84 |
2179035 | 2179035 | 2022-02-03 | Ray | Missouri | 29177 | 4871 | 83 |
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);