participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,668 rows where station_code = "USL010" 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 |
---|---|---|---|---|---|
5083042 | 5083042 | 20240911115058_VR66c | USL010 | 2024-09-15T12:18:34.298Z | 2024-09-19T12:21:49.162Z |
5081622 | 5081622 | 20240911081016_9eZyD | USL010 | 2024-09-15T12:17:38.940Z | 2024-09-19T12:21:45.873Z |
5081600 | 5081600 | 20240911080707_h1a3v | USL010 | 2024-09-15T12:17:38.626Z | 2024-09-19T12:21:45.838Z |
5067854 | 5067854 | 20240910102029_MyQjK | USL010 | 2024-09-14T12:19:00.657Z | 2024-09-18T12:15:24.976Z |
5067803 | 5067803 | 20240910101248_Teyda | USL010 | 2024-09-14T12:18:59.109Z | 2024-09-18T12:15:24.918Z |
5067596 | 5067596 | 20240910094905_3fVx9 | USL010 | 2024-09-14T12:18:50.396Z | 2024-09-18T12:15:24.519Z |
5067575 | 5067575 | 20240910094614_nY16p | USL010 | 2024-09-14T12:18:49.456Z | 2024-09-18T12:15:24.446Z |
5066798 | 5066798 | 20240910081827_FeiwA | USL010 | 2024-09-14T12:18:12.754Z | 2024-09-18T12:15:22.760Z |
5066314 | 5066314 | 20240910071123_tzq8b | USL010 | 2024-09-14T12:17:49.906Z | 2024-09-18T12:15:21.594Z |
5065701 | 5065701 | 20240910051545_PsAlP | USL010 | 2024-09-14T12:17:19.525Z | 2024-09-18T12:15:20.180Z |
5056735 | 5056735 | 20240908111647_RF2wg | USL010 | 2024-09-13T12:17:38.674Z | 2024-09-16T12:21:26.983Z |
5056536 | 5056536 | 20240908103921_h9rhb | USL010 | 2024-09-13T12:17:34.793Z | 2024-09-16T12:21:25.794Z |
5056490 | 5056490 | 20240908103409_4G2AS | USL010 | 2024-09-13T12:17:33.803Z | 2024-09-16T12:21:25.620Z |
5056391 | 5056391 | 20240908102134_DS5jy | USL010 | 2024-09-13T12:17:31.190Z | 2024-09-16T12:21:24.836Z |
5055817 | 5055817 | 20240908090635_uytTj | USL010 | 2024-09-13T12:17:22.518Z | 2024-09-16T12:21:22.121Z |
5049727 | 5049727 | 20240909113143_KmWuX | USL010 | 2024-09-13T12:12:24.212Z | 2024-09-17T12:19:11.315Z |
5048154 | 5048154 | 20240909071232_n1SlQ | USL010 | 2024-09-13T12:10:18.136Z | 2024-09-17T12:19:05.958Z |
5047595 | 5047595 | 20240909045423_26Yhg | USL010 | 2024-09-13T12:09:27.054Z | 2024-09-17T12:19:03.645Z |
5043516 | 5043516 | 20240907111831_Fb0yZ | USL010 | 2024-09-12T12:17:35.336Z | 2024-09-15T12:21:41.948Z |
5043475 | 5043475 | 20240907111256_zEeiZ | USL010 | 2024-09-12T12:17:34.432Z | 2024-09-15T12:21:41.806Z |
5043450 | 5043450 | 20240907110803_qqbCA | USL010 | 2024-09-12T12:17:34.101Z | 2024-09-15T12:21:41.714Z |
5042183 | 5042183 | 20240906100650_wa807 | USL010 | 2024-09-12T12:16:56.773Z | 2024-09-14T12:23:16.376Z |
5042147 | 5042147 | 20240906100256_dh37y | USL010 | 2024-09-12T12:16:56.169Z | 2024-09-14T12:23:16.167Z |
5041960 | 5041960 | 20240906093231_mTYd7 | USL010 | 2024-09-12T12:16:53.342Z | 2024-09-14T12:23:15.543Z |
5041302 | 5041302 | 20240906075325_RZ3kE | USL010 | 2024-09-12T12:16:38.020Z | 2024-09-14T12:23:12.591Z |
5040926 | 5040926 | 20240906062843_8cdqP | USL010 | 2024-09-12T12:16:28.426Z | 2024-09-14T12:23:11.014Z |
5035567 | 5035567 | 20240907095142_l2s8N | USL010 | 2024-09-12T12:12:13.362Z | 2024-09-15T12:21:40.000Z |
5034697 | 5034697 | 20240907074503_4weyt | USL010 | 2024-09-12T12:11:12.732Z | 2024-09-15T12:21:35.564Z |
5029830 | 5029830 | 20240906113453_VPqoF | USL010 | 2024-09-12T12:00:36.366Z | 2024-09-15T12:21:17.332Z |
5029726 | 5029726 | 20240906111722_2mS3O | USL010 | 2024-09-12T12:00:25.350Z | 2024-09-15T12:21:16.973Z |
5015554 | 5015554 | 20240904115155_u31ia | USL010 | 2024-09-10T12:06:23.325Z | 2024-09-13T12:19:44.282Z |
5012040 | 5012040 | 20240904083157_LQBO8 | USL010 | 2024-09-09T12:10:18.965Z | 2024-09-12T12:19:34.574Z |
5004694 | 5004694 | 20240903120910_mXLP2 | USL010 | 2024-09-09T12:02:55.140Z | 2024-09-12T12:19:03.535Z |
5003935 | 5003935 | 20240903101642_KX2bZ | USL010 | 2024-09-09T12:02:13.395Z | 2024-09-12T12:19:00.188Z |
5002681 | 5002681 | 20240904103143_NuP3Y | USL010 | 2024-09-09T12:00:55.856Z | 2024-09-13T12:19:41.749Z |
5002286 | 5002286 | 20240904093218_4OH2n | USL010 | 2024-09-09T12:00:22.520Z | 2024-09-13T12:19:40.227Z |
4998444 | 4998444 | 20240903030441_Bdon3 | USL010 | 2024-09-08T12:07:38.601Z | 2024-09-11T12:21:12.800Z |
4993726 | 4993726 | 20240902111708_FuwzZ | USL010 | 2024-09-08T12:01:50.303Z | 2024-09-11T12:20:26.259Z |
4993522 | 4993522 | 20240902104816_hlz1m | USL010 | 2024-09-08T12:01:39.240Z | 2024-09-11T12:20:24.737Z |
4992846 | 4992846 | 20240902090416_A30H5 | USL010 | 2024-09-08T12:00:55.105Z | 2024-09-11T12:20:17.834Z |
4991689 | 4991689 | 20240901025850_382aq | USL010 | 2024-09-07T12:12:23.971Z | 2024-09-09T12:27:15.757Z |
4905648 | 4905648 | 20240809111108_2pvzi | USL010 | 2024-08-29T12:00:44.547Z | 2024-09-02T12:16:54.791Z |
4893685 | 4893685 | 20240809102937_ZtOFC | USL010 | 2024-08-28T12:11:38.266Z | 2024-08-30T12:23:06.912Z |
4893602 | 4893602 | 20240809101441_nFJ76 | USL010 | 2024-08-28T12:11:34.621Z | 2024-08-30T12:23:03.093Z |
4860594 | 4860594 | 20240806104850_NR22g | USL010 | 2024-08-18T12:02:58.778Z | 2024-08-27T12:02:53.810Z |
4818275 | 4818275 | 20240804085909_DLJLe | USL010 | 2024-08-14T12:02:25.056Z | 2024-08-17T12:24:31.322Z |
4818108 | 4818108 | 20240804083458_wbTIC | USL010 | 2024-08-14T12:02:02.767Z | 2024-08-17T12:24:15.710Z |
4818024 | 4818024 | 20240804081946_szMix | USL010 | 2024-08-14T12:01:48.592Z | 2024-08-17T12:24:09.243Z |
4818008 | 4818008 | 20240804081717_ZyTxb | USL010 | 2024-08-14T12:01:47.168Z | 2024-08-17T12:24:08.519Z |
4817930 | 4817930 | 20240804080731_BbZ5W | USL010 | 2024-08-14T12:01:33.674Z | 2024-08-17T12:24:02.009Z |
4817908 | 4817908 | 20240804080218_El5S3 | USL010 | 2024-08-14T12:01:31.013Z | 2024-08-17T12:24:00.319Z |
4808459 | 4808459 | 20240803110246_DThAs | USL010 | 2024-08-13T12:05:31.293Z | 2024-08-15T12:19:07.073Z |
4807428 | 4807428 | 20240803095845_AnW3m | USL010 | 2024-08-13T12:03:15.454Z | 2024-08-15T12:18:28.744Z |
4797733 | 4797733 | 20240803071455_2TXLs | USL010 | 2024-08-12T12:01:28.551Z | 2024-08-15T12:17:19.356Z |
4797388 | 4797388 | 20240803051646_H6PWa | USL010 | 2024-08-12T12:00:24.161Z | 2024-08-15T12:17:08.262Z |
4481892 | 4481892 | 20240618102409_B36ba | USL010 | 2024-06-20T12:01:39.598Z | 2024-06-27T12:11:13.769Z |
4472883 | 4472883 | 20240616094057_ioOhN | USL010 | 2024-06-18T12:03:04.689Z | 2024-06-24T12:11:14.560Z |
4472856 | 4472856 | 20240616092528_K2zoX | USL010 | 2024-06-18T12:03:01.584Z | 2024-06-24T12:11:13.832Z |
4472515 | 4472515 | 20240616074934_AXm65 | USL010 | 2024-06-18T12:02:22.122Z | 2024-06-24T12:11:09.220Z |
4472197 | 4472197 | 20240616062409_fdJUB | USL010 | 2024-06-18T12:01:47.080Z | 2024-06-24T12:11:05.242Z |
4465667 | 4465667 | 20240615111334_s5OUr | USL010 | 2024-06-16T12:04:46.538Z | 2024-06-23T12:12:12.976Z |
4465660 | 4465660 | 20240615110512_8yHMe | USL010 | 2024-06-16T12:04:46.123Z | 2024-06-23T12:12:12.765Z |
4465629 | 4465629 | 20240615105110_YJY23 | USL010 | 2024-06-16T12:04:44.186Z | 2024-06-23T12:12:12.154Z |
4465581 | 4465581 | 20240615103703_DJ8cM | USL010 | 2024-06-16T12:04:41.134Z | 2024-06-23T12:12:11.371Z |
4465424 | 4465424 | 20240615095444_Lmz8h | USL010 | 2024-06-16T12:04:27.484Z | 2024-06-23T12:12:09.242Z |
4465358 | 4465358 | 20240615093131_Y56dx | USL010 | 2024-06-16T12:04:16.959Z | 2024-06-23T12:12:07.791Z |
4465337 | 4465337 | 20240615092416_4PWLq | USL010 | 2024-06-16T12:04:11.913Z | 2024-06-23T12:12:07.147Z |
4465280 | 4465280 | 20240615090712_pDJCd | USL010 | 2024-06-16T12:04:04.667Z | 2024-06-23T12:12:05.805Z |
4465168 | 4465168 | 20240615083854_fTSFI | USL010 | 2024-06-16T12:03:54.341Z | 2024-06-23T12:12:03.367Z |
4465065 | 4465065 | 20240615081842_Gorja | USL010 | 2024-06-16T12:03:45.525Z | 2024-06-23T12:12:01.068Z |
4464876 | 4464876 | 20240615073858_E2K7z | USL010 | 2024-06-16T12:03:17.190Z | 2024-06-23T12:11:56.601Z |
4457836 | 4457836 | 20240613100631_BQF8q | USL010 | 2024-06-14T12:03:29.638Z | 2024-06-21T12:11:43.402Z |
4450679 | 4450679 | 20240612100410_sJ2Bz | USL010 | 2024-06-13T12:03:00.501Z | 2024-06-20T12:12:01.146Z |
4450599 | 4450599 | 20240612093610_dOW3M | USL010 | 2024-06-13T12:02:55.496Z | 2024-06-20T12:11:59.676Z |
4450449 | 4450449 | 20240612085118_Nxts0 | USL010 | 2024-06-13T12:02:44.418Z | 2024-06-20T12:11:59.038Z |
4450436 | 4450436 | 20240612084822_Ff2Hv | USL010 | 2024-06-13T12:02:43.840Z | 2024-06-20T12:11:59.031Z |
4447324 | 4447324 | 20240611111258_ran56 | USL010 | 2024-06-12T12:04:01.359Z | 2024-06-19T12:13:43.795Z |
4447044 | 4447044 | 20240611100616_SVIQc | USL010 | 2024-06-12T12:03:40.871Z | 2024-06-19T12:13:40.228Z |
4446981 | 4446981 | 20240611094038_fzG5q | USL010 | 2024-06-12T12:03:36.370Z | 2024-06-19T12:13:39.832Z |
4446825 | 4446825 | 20240611084812_bmdS2 | USL010 | 2024-06-12T12:03:25.411Z | 2024-06-19T12:13:37.676Z |
4446823 | 4446823 | 20240611084742_zD6k0 | USL010 | 2024-06-12T12:03:25.179Z | 2024-06-19T12:13:37.663Z |
4446691 | 4446691 | 20240611075218_wy7HE | USL010 | 2024-06-12T12:03:12.943Z | 2024-06-19T12:13:36.491Z |
4443120 | 4443120 | 20240610100226_3fK8O | USL010 | 2024-06-11T12:03:13.445Z | 2024-06-18T12:11:10.659Z |
4443037 | 4443037 | 20240610093657_yvdsk | USL010 | 2024-06-11T12:03:07.489Z | 2024-06-18T12:11:10.277Z |
4440727 | 4440727 | 20240608102818_wvxbK | USL010 | 2024-06-10T12:03:58.637Z | 2024-06-16T12:14:18.462Z |
4440483 | 4440483 | 20240608092059_VLl1y | USL010 | 2024-06-10T12:03:51.332Z | 2024-06-16T12:14:17.409Z |
4430029 | 4430029 | 20240606091421_2Xp9O | USL010 | 2024-06-08T12:09:52.471Z | 2024-06-14T12:08:29.141Z |
4424407 | 4424407 | 20240605112158_hv5gZ | USL010 | 2024-06-07T12:12:20.751Z | 2024-06-13T12:08:37.914Z |
4424106 | 4424106 | 20240605103354_6qkaf | USL010 | 2024-06-07T12:12:03.340Z | 2024-06-13T12:08:37.541Z |
4424069 | 4424069 | 20240605102958_hzv0G | USL010 | 2024-06-07T12:12:01.436Z | 2024-06-13T12:08:37.494Z |
4423896 | 4423896 | 20240605095401_8WsDY | USL010 | 2024-06-07T12:11:51.238Z | 2024-06-13T12:08:37.159Z |
4423660 | 4423660 | 20240605090706_63P1H | USL010 | 2024-06-07T12:11:36.548Z | 2024-06-13T12:08:36.827Z |
4407742 | 4407742 | 20240602080829_V7Bwk | USL010 | 2024-06-04T12:10:02.000Z | 2024-06-10T12:06:49.161Z |
4407564 | 4407564 | 20240602065035_LYzt3 | USL010 | 2024-06-04T12:09:49.971Z | 2024-06-10T12:06:48.784Z |
4403479 | 4403479 | 20240601080242_FPbZ3 | USL010 | 2024-06-03T12:11:46.798Z | 2024-06-09T12:06:03.975Z |
4403326 | 4403326 | 20240601065033_eQltg | USL010 | 2024-06-03T12:11:31.892Z | 2024-06-09T12:06:03.529Z |
4403093 | 4403093 | 20240601050636_71SGH | USL010 | 2024-06-03T12:10:57.474Z | 2024-06-09T12:06:02.709Z |
4398557 | 4398557 | 20240601103452_27hiP | USL010 | 2024-06-03T12:01:34.565Z | 2024-06-10T12:06:44.101Z |
4398374 | 4398374 | 20240601094917_B0VaX | USL010 | 2024-06-03T12:01:03.920Z | 2024-06-10T12:06:43.611Z |
4398257 | 4398257 | 20240601091444_0lrdm | USL010 | 2024-06-03T12:00:41.188Z | 2024-06-10T12:06:43.366Z |
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);