participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "US000H" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
4522526 | 4522526 | 20240629080254_FqHQz | US000H | 2024-06-30T12:05:35.862Z | 2024-07-07T12:13:51.534Z |
4522207 | 4522207 | 20240629054148_22K8m | US000H | 2024-06-30T12:05:21.382Z | 2024-07-07T12:13:50.511Z |
4522183 | 4522183 | 20240629052020_EAPBE | US000H | 2024-06-30T12:05:20.330Z | 2024-07-07T12:13:50.476Z |
4522178 | 4522178 | 20240629051438_dc3A2 | US000H | 2024-06-30T12:05:20.162Z | 2024-07-07T12:13:50.435Z |
4522136 | 4522136 | 20240629044711_8FJul | US000H | 2024-06-30T12:05:18.789Z | 2024-07-07T12:13:50.314Z |
4522098 | 4522098 | 20240629041233_hy6F2 | US000H | 2024-06-30T12:05:17.235Z | 2024-07-07T12:13:50.212Z |
4502195 | 4502195 | 20240625095422_zSucf | US000H | 2024-06-26T12:06:33.423Z | 2024-07-03T12:13:24.061Z |
4502193 | 4502193 | 20240625095236_ufjf1 | US000H | 2024-06-26T12:06:33.226Z | 2024-07-03T12:13:24.032Z |
4502189 | 4502189 | 20240625095041_E8wSF | US000H | 2024-06-26T12:06:32.829Z | 2024-07-03T12:13:23.990Z |
4486625 | 4486625 | 20240619103506_oPaQo | US000H | 2024-06-21T12:02:42.378Z | 2024-06-28T12:09:29.480Z |
4486604 | 4486604 | 20240619102916_IhD9Y | US000H | 2024-06-21T12:02:41.180Z | 2024-06-28T12:09:29.356Z |
4486571 | 4486571 | 20240619102055_KpPqM | US000H | 2024-06-21T12:02:38.891Z | 2024-06-28T12:09:29.197Z |
4486548 | 4486548 | 20240619101535_NqgOR | US000H | 2024-06-21T12:02:37.570Z | 2024-06-28T12:09:29.081Z |
4486427 | 4486427 | 20240619094724_DldVJ | US000H | 2024-06-21T12:02:29.600Z | 2024-06-28T12:09:28.572Z |
4486410 | 4486410 | 20240619094058_sKm1g | US000H | 2024-06-21T12:02:28.016Z | 2024-06-28T12:09:28.494Z |
4486403 | 4486403 | 20240619094048_ESQm2 | US000H | 2024-06-21T12:02:27.788Z | 2024-06-28T12:09:28.474Z |
4486400 | 4486400 | 20240619094042_fhpGC | US000H | 2024-06-21T12:02:27.580Z | 2024-06-28T12:09:28.460Z |
4486350 | 4486350 | 20240619093043_h2xep | US000H | 2024-06-21T12:02:24.063Z | 2024-06-28T12:09:28.172Z |
4486341 | 4486341 | 20240619092734_cfEbI | US000H | 2024-06-21T12:02:23.595Z | 2024-06-28T12:09:28.131Z |
4486265 | 4486265 | 20240619090336_zz4Zx | US000H | 2024-06-21T12:02:16.461Z | 2024-06-28T12:09:27.843Z |
4486129 | 4486129 | 20240619082220_3u4br | US000H | 2024-06-21T12:02:00.791Z | 2024-06-28T12:09:27.217Z |
4486107 | 4486107 | 20240619081652_15kxa | US000H | 2024-06-21T12:01:59.101Z | 2024-06-28T12:09:27.109Z |
4486099 | 4486099 | 20240619081402_StJGR | US000H | 2024-06-21T12:01:58.362Z | 2024-06-28T12:09:27.085Z |
4486087 | 4486087 | 20240619081055_MOucb | US000H | 2024-06-21T12:01:57.143Z | 2024-06-28T12:09:27.010Z |
4486059 | 4486059 | 20240619075414_chMrI | US000H | 2024-06-21T12:01:54.888Z | 2024-06-28T12:09:26.828Z |
4486030 | 4486030 | 20240619073531_spAAb | US000H | 2024-06-21T12:01:51.977Z | 2024-06-28T12:09:26.610Z |
4485923 | 4485923 | 20240619064447_EG8LC | US000H | 2024-06-21T12:01:42.501Z | 2024-06-28T12:09:26.017Z |
4485814 | 4485814 | 20240619054613_UYAjl | US000H | 2024-06-21T12:01:25.965Z | 2024-06-28T12:09:25.306Z |
4485800 | 4485800 | 20240619054031_TqYSs | US000H | 2024-06-21T12:01:22.271Z | 2024-06-28T12:09:25.212Z |
4485686 | 4485686 | 20240620105557_wR0Gm | US000H | 2024-06-21T12:01:09.205Z | 2024-06-29T12:13:23.317Z |
4485664 | 4485664 | 20240620105226_HHvZq | US000H | 2024-06-21T12:01:07.744Z | 2024-06-29T12:13:22.997Z |
4485617 | 4485617 | 20240620103329_BRgMT | US000H | 2024-06-21T12:01:03.535Z | 2024-06-29T12:13:22.610Z |
4485595 | 4485595 | 20240620102456_z73S6 | US000H | 2024-06-21T12:01:01.110Z | 2024-06-29T12:13:22.492Z |
4485592 | 4485592 | 20240620102249_Qr4s3 | US000H | 2024-06-21T12:01:00.835Z | 2024-06-29T12:13:22.465Z |
4485565 | 4485565 | 20240620101740_XNgTR | US000H | 2024-06-21T12:00:58.748Z | 2024-06-29T12:13:22.369Z |
4485562 | 4485562 | 20240620101420_mYeaE | US000H | 2024-06-21T12:00:58.534Z | 2024-06-29T12:13:22.355Z |
4485544 | 4485544 | 20240620100801_oNRJa | US000H | 2024-06-21T12:00:56.910Z | 2024-06-29T12:13:22.247Z |
4485161 | 4485161 | 20240620064229_T87o4 | US000H | 2024-06-21T12:00:17.111Z | 2024-06-29T12:13:18.435Z |
4482057 | 4482057 | 20240618105418_X8d9Z | US000H | 2024-06-20T12:01:52.612Z | 2024-06-27T12:11:14.779Z |
4482038 | 4482038 | 20240618105150_sGv7q | US000H | 2024-06-20T12:01:51.585Z | 2024-06-27T12:11:14.669Z |
4481972 | 4481972 | 20240618103901_DBRHu | US000H | 2024-06-20T12:01:46.609Z | 2024-06-27T12:11:14.315Z |
4481894 | 4481894 | 20240618102458_A2CbN | US000H | 2024-06-20T12:01:40.096Z | 2024-06-27T12:11:13.807Z |
4481867 | 4481867 | 20240618101918_axTLL | US000H | 2024-06-20T12:01:34.180Z | 2024-06-27T12:11:13.604Z |
4481837 | 4481837 | 20240618101444_MzsQz | US000H | 2024-06-20T12:01:31.378Z | 2024-06-27T12:11:13.370Z |
4481826 | 4481826 | 20240618101350_4ZKwd | US000H | 2024-06-20T12:01:30.592Z | 2024-06-27T12:11:13.315Z |
4481753 | 4481753 | 20240618095317_XpuZu | US000H | 2024-06-20T12:01:23.585Z | 2024-06-27T12:11:11.377Z |
4481663 | 4481663 | 20240618093345_h2OTH | US000H | 2024-06-20T12:01:12.380Z | 2024-06-27T12:11:10.740Z |
4481606 | 4481606 | 20240618092320_cRQae | US000H | 2024-06-20T12:01:07.635Z | 2024-06-27T12:11:09.610Z |
4481440 | 4481440 | 20240618083816_CU1tT | US000H | 2024-06-20T12:00:54.523Z | 2024-06-27T12:11:07.465Z |
4481428 | 4481428 | 20240618083448_92B5y | US000H | 2024-06-20T12:00:53.930Z | 2024-06-27T12:11:07.429Z |
4481404 | 4481404 | 20240618082932_AUhNp | US000H | 2024-06-20T12:00:52.255Z | 2024-06-27T12:11:06.862Z |
4481384 | 4481384 | 20240618082103_87eH8 | US000H | 2024-06-20T12:00:50.739Z | 2024-06-27T12:11:06.691Z |
4481255 | 4481255 | 20240618071529_pQADh | US000H | 2024-06-20T12:00:37.260Z | 2024-06-27T12:11:04.201Z |
4481240 | 4481240 | 20240618070231_B5iTM | US000H | 2024-06-20T12:00:35.523Z | 2024-06-27T12:11:03.833Z |
4481211 | 4481211 | 20240618064909_bc3oz | US000H | 2024-06-20T12:00:28.903Z | 2024-06-27T12:11:03.491Z |
4481166 | 4481166 | 20240618062138_Ma2eS | US000H | 2024-06-20T12:00:24.823Z | 2024-06-27T12:11:01.950Z |
4481149 | 4481149 | 20240618055911_0BgGe | US000H | 2024-06-20T12:00:23.156Z | 2024-06-27T12:11:01.444Z |
4481062 | 4481062 | 20240618044413_uuYix | US000H | 2024-06-20T12:00:14.325Z | 2024-06-27T12:11:00.084Z |
4481050 | 4481050 | 20240618035842_bFdZ5 | US000H | 2024-06-20T12:00:12.170Z | 2024-06-27T12:10:59.919Z |
4476112 | 4476112 | 20240617102006_5e6Pv | US000H | 2024-06-19T12:03:05.033Z | 2024-06-26T12:14:17.036Z |
4476077 | 4476077 | 20240617101018_B9Lyr | US000H | 2024-06-19T12:03:02.489Z | 2024-06-26T12:14:16.824Z |
4476063 | 4476063 | 20240617100213_widio | US000H | 2024-06-19T12:03:01.573Z | 2024-06-26T12:14:16.378Z |
4476050 | 4476050 | 20240617095956_i1Of4 | US000H | 2024-06-19T12:03:00.148Z | 2024-06-26T12:14:16.113Z |
4476007 | 4476007 | 20240617094354_YJ7pZ | US000H | 2024-06-19T12:02:56.642Z | 2024-06-26T12:14:15.583Z |
4476002 | 4476002 | 20240617094251_LqKih | US000H | 2024-06-19T12:02:56.326Z | 2024-06-26T12:14:15.564Z |
4475975 | 4475975 | 20240617093723_5J1Z4 | US000H | 2024-06-19T12:02:54.159Z | 2024-06-26T12:14:15.294Z |
4475943 | 4475943 | 20240617092909_WQZiU | US000H | 2024-06-19T12:02:51.914Z | 2024-06-26T12:14:15.180Z |
4475940 | 4475940 | 20240617092648_fbXPr | US000H | 2024-06-19T12:02:51.609Z | 2024-06-26T12:14:15.161Z |
4475870 | 4475870 | 20240617091019_RUzW0 | US000H | 2024-06-19T12:02:36.416Z | 2024-06-26T12:14:14.603Z |
4475814 | 4475814 | 20240617085631_YL2Pe | US000H | 2024-06-19T12:02:30.398Z | 2024-06-26T12:14:14.208Z |
4475804 | 4475804 | 20240617085446_o8163 | US000H | 2024-06-19T12:02:29.855Z | 2024-06-26T12:14:14.145Z |
4475734 | 4475734 | 20240617083437_RdzgN | US000H | 2024-06-19T12:02:23.242Z | 2024-06-26T12:14:13.732Z |
4475619 | 4475619 | 20240617080628_OmicR | US000H | 2024-06-19T12:02:11.113Z | 2024-06-26T12:14:12.929Z |
4475573 | 4475573 | 20240617074509_DAKyG | US000H | 2024-06-19T12:02:07.976Z | 2024-06-26T12:14:12.695Z |
4475549 | 4475549 | 20240617073557_HUKgV | US000H | 2024-06-19T12:02:06.258Z | 2024-06-26T12:14:12.597Z |
4475456 | 4475456 | 20240617070722_AolQa | US000H | 2024-06-19T12:01:51.047Z | 2024-06-26T12:14:12.076Z |
4475408 | 4475408 | 20240617064422_hyOVE | US000H | 2024-06-19T12:01:45.335Z | 2024-06-26T12:14:11.699Z |
4475406 | 4475406 | 20240617064321_Ffqcp | US000H | 2024-06-19T12:01:44.895Z | 2024-06-26T12:14:11.678Z |
4475397 | 4475397 | 20240617063913_PXoya | US000H | 2024-06-19T12:01:43.917Z | 2024-06-26T12:14:11.600Z |
4475392 | 4475392 | 20240617063851_22PSP | US000H | 2024-06-19T12:01:43.271Z | 2024-06-26T12:14:11.556Z |
4475389 | 4475389 | 20240617063511_IQR5z | US000H | 2024-06-19T12:01:42.924Z | 2024-06-26T12:14:11.546Z |
4475346 | 4475346 | 20240617055542_KvMal | US000H | 2024-06-19T12:01:38.054Z | 2024-06-26T12:14:10.061Z |
4475341 | 4475341 | 20240617055457_22bUy | US000H | 2024-06-19T12:01:37.432Z | 2024-06-26T12:14:09.996Z |
4475279 | 4475279 | 20240617044706_yG28x | US000H | 2024-06-19T12:01:28.307Z | 2024-06-26T12:14:09.436Z |
4475252 | 4475252 | 20240617042353_28qjA | US000H | 2024-06-19T12:01:22.018Z | 2024-06-26T12:14:09.040Z |
4473118 | 4473118 | 20240616103907_7UDc9 | US000H | 2024-06-18T12:03:25.621Z | 2024-06-24T12:11:19.708Z |
4473036 | 4473036 | 20240616102020_Cp8j5 | US000H | 2024-06-18T12:03:17.835Z | 2024-06-24T12:11:18.132Z |
4473027 | 4473027 | 20240616101828_8RGXi | US000H | 2024-06-18T12:03:17.201Z | 2024-06-24T12:11:18.055Z |
4472971 | 4472971 | 20240616100538_BnfEN | US000H | 2024-06-18T12:03:12.426Z | 2024-06-24T12:11:16.928Z |
4472964 | 4472964 | 20240616100515_lA1aV | US000H | 2024-06-18T12:03:11.747Z | 2024-06-24T12:11:16.841Z |
4472956 | 4472956 | 20240616100327_KiIkD | US000H | 2024-06-18T12:03:11.060Z | 2024-06-24T12:11:16.809Z |
4472953 | 4472953 | 20240616100314_d2DlX | US000H | 2024-06-18T12:03:10.784Z | 2024-06-24T12:11:16.752Z |
4472851 | 4472851 | 20240616092423_ZSbNz | US000H | 2024-06-18T12:03:00.955Z | 2024-06-24T12:11:13.789Z |
4472628 | 4472628 | 20240616082556_Z5a1k | US000H | 2024-06-18T12:02:34.639Z | 2024-06-24T12:11:10.431Z |
4472611 | 4472611 | 20240616082119_wnXM8 | US000H | 2024-06-18T12:02:32.749Z | 2024-06-24T12:11:10.179Z |
4472458 | 4472458 | 20240616073825_pGq12 | US000H | 2024-06-18T12:02:15.911Z | 2024-06-24T12:11:08.703Z |
4472390 | 4472390 | 20240616071343_VXNv7 | US000H | 2024-06-18T12:02:07.398Z | 2024-06-24T12:11:08.005Z |
4471974 | 4471974 | 20240616044919_cYEQv | US000H | 2024-06-18T12:01:18.193Z | 2024-06-24T12:11:01.541Z |
4471946 | 4471946 | 20240616044018_q5L1g | US000H | 2024-06-18T12:01:16.169Z | 2024-06-24T12:11:01.357Z |
4465583 | 4465583 | 20240615103719_VP2Dr | US000H | 2024-06-16T12:04:41.456Z | 2024-06-23T12:12:11.436Z |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE participating_station ( meteor_unique_trajectory_identifier text NOT NULL, station_code text NOT NULL, created_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), updated_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier), FOREIGN KEY (station_code) REFERENCES station (code), UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE ); CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier); CREATE INDEX participating_station_created_at_index ON participating_station (created_at); CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);