participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,653 rows where station_code = "CA000C" 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 |
---|---|---|---|---|---|
5130085 | 5130085 | 20240917085103_1Y8Zo | CA000C | 2024-09-19T12:12:33.294Z | 2024-09-19T12:12:33.294Z |
5129992 | 5129992 | 20240917073500_IHRPP | CA000C | 2024-09-19T12:12:23.958Z | 2024-09-19T12:12:23.958Z |
5129968 | 5129968 | 20240917070955_Vdnz3 | CA000C | 2024-09-19T12:12:21.146Z | 2024-09-19T12:12:21.146Z |
5128346 | 5128346 | 20240917012802_M4nTE | CA000C | 2024-09-19T12:10:28.305Z | 2024-09-19T12:10:28.305Z |
5123022 | 5123022 | 20240914084152_3fw2N | CA000C | 2024-09-18T12:11:38.446Z | 2024-09-19T12:20:07.348Z |
5122169 | 5122169 | 20240914044422_yHgxu | CA000C | 2024-09-18T12:11:08.230Z | 2024-09-19T12:20:02.903Z |
5119741 | 5119741 | 20240914024638_b9NyC | CA000C | 2024-09-18T12:10:25.451Z | 2024-09-19T12:19:58.840Z |
5118309 | 5118309 | 20240915091442_hT0SG | CA000C | 2024-09-18T12:08:36.978Z | 2024-09-19T12:19:21.992Z |
5117842 | 5117842 | 20240915072205_lIaEo | CA000C | 2024-09-18T12:08:02.835Z | 2024-09-19T12:19:18.482Z |
5108869 | 5108869 | 20240913075216_XpqLK | CA000C | 2024-09-17T12:14:12.809Z | 2024-09-19T12:20:50.970Z |
5108859 | 5108859 | 20240913074804_HZC66 | CA000C | 2024-09-17T12:14:11.035Z | 2024-09-19T12:20:50.955Z |
5108493 | 5108493 | 20240913055901_rrWj6 | CA000C | 2024-09-17T12:13:47.677Z | 2024-09-19T12:20:49.045Z |
5108141 | 5108141 | 20240913042630_DZOZI | CA000C | 2024-09-17T12:13:31.349Z | 2024-09-19T12:20:47.867Z |
5081293 | 5081293 | 20240911071522_Hnp2Y | CA000C | 2024-09-15T12:17:29.621Z | 2024-09-19T12:21:45.045Z |
5081215 | 5081215 | 20240911065753_Oa0J7 | CA000C | 2024-09-15T12:17:27.084Z | 2024-09-19T12:21:44.780Z |
5081133 | 5081133 | 20240911064038_W3dEt | CA000C | 2024-09-15T12:17:24.775Z | 2024-09-19T12:21:44.665Z |
5081052 | 5081052 | 20240911061442_35edX | CA000C | 2024-09-15T12:17:21.944Z | 2024-09-19T12:21:44.509Z |
5080626 | 5080626 | 20240911041359_ouY2w | CA000C | 2024-09-15T12:17:09.189Z | 2024-09-19T12:21:43.359Z |
5079614 | 5079614 | 20240911030615_LWloz | CA000C | 2024-09-15T12:16:30.614Z | 2024-09-19T12:21:42.505Z |
5077889 | 5077889 | 20240911012718_upPoj | CA000C | 2024-09-15T12:15:10.121Z | 2024-09-19T12:21:39.766Z |
5041439 | 5041439 | 20240906081613_qrOS7 | CA000C | 2024-09-12T12:16:41.517Z | 2024-09-14T12:23:13.504Z |
5041377 | 5041377 | 20240906080648_hvvga | CA000C | 2024-09-12T12:16:39.598Z | 2024-09-14T12:23:13.399Z |
5041370 | 5041370 | 20240906080544_9OS7Q | CA000C | 2024-09-12T12:16:39.459Z | 2024-09-14T12:23:13.392Z |
5025732 | 5025732 | 20240905010233_qGoo6 | CA000C | 2024-09-11T12:10:54.221Z | 2024-09-13T12:19:55.292Z |
5020149 | 5020149 | 20240905010233_8xF2f | CA000C | 2024-09-10T12:14:00.272Z | 2024-09-10T12:16:55.083Z |
5013187 | 5013187 | 20240903083148_5TExc | CA000C | 2024-09-09T12:18:29.448Z | 2024-09-11T12:21:20.141Z |
5013037 | 5013037 | 20240903081623_A7ceH | CA000C | 2024-09-09T12:18:25.121Z | 2024-09-11T12:21:19.692Z |
5012725 | 5012725 | 20240903072359_Ujiye | CA000C | 2024-09-09T12:18:12.983Z | 2024-09-11T12:21:18.668Z |
5003514 | 5003514 | 20240903090547_FBL6h | CA000C | 2024-09-09T12:01:48.684Z | 2024-09-12T12:18:57.204Z |
5003397 | 5003397 | 20240903084330_Zqowd | CA000C | 2024-09-09T12:01:41.585Z | 2024-09-12T12:18:56.392Z |
5002027 | 5002027 | 20240902073013_hGbOh | CA000C | 2024-09-08T12:17:07.596Z | 2024-09-10T12:19:35.926Z |
5001282 | 5001282 | 20240902041200_4LFFf | CA000C | 2024-09-08T12:16:18.095Z | 2024-09-10T12:19:32.713Z |
5001061 | 5001061 | 20240902032802_qAnDq | CA000C | 2024-09-08T12:16:08.063Z | 2024-09-10T12:19:31.383Z |
5000682 | 5000682 | 20240902023808_fh3ZH | CA000C | 2024-09-08T12:15:36.349Z | 2024-09-10T12:19:29.181Z |
5000578 | 5000578 | 20240902022539_ngHq5 | CA000C | 2024-09-08T12:15:29.683Z | 2024-09-10T12:19:28.050Z |
4999656 | 4999656 | 20240902004500_awBh8 | CA000C | 2024-09-08T12:14:39.993Z | 2024-09-10T12:19:21.691Z |
4999340 | 4999340 | 20240903061940_fu9I7 | CA000C | 2024-09-08T12:08:41.064Z | 2024-09-11T12:21:17.335Z |
4999120 | 4999120 | 20240903052636_U1d22 | CA000C | 2024-09-08T12:08:30.158Z | 2024-09-11T12:21:16.457Z |
4998615 | 4998615 | 20240903032351_WklNz | CA000C | 2024-09-08T12:07:55.294Z | 2024-09-11T12:21:13.890Z |
4998533 | 4998533 | 20240903031625_vHtdL | CA000C | 2024-09-08T12:07:47.403Z | 2024-09-11T12:21:13.425Z |
4998318 | 4998318 | 20240903024432_XE9br | CA000C | 2024-09-08T12:07:29.437Z | 2024-09-11T12:21:12.059Z |
4998257 | 4998257 | 20240903023536_rK9Qi | CA000C | 2024-09-08T12:07:26.308Z | 2024-09-11T12:21:11.734Z |
4998140 | 4998140 | 20240903021817_ZjKW3 | CA000C | 2024-09-08T12:07:18.820Z | 2024-09-11T12:21:11.152Z |
4997908 | 4997908 | 20240903014414_Ua136 | CA000C | 2024-09-08T12:06:56.864Z | 2024-09-11T12:21:09.855Z |
4992604 | 4992604 | 20240902082647_n5Tfn | CA000C | 2024-09-08T12:00:36.042Z | 2024-09-11T12:20:15.428Z |
4992498 | 4992498 | 20240902081213_rVJDU | CA000C | 2024-09-08T12:00:26.770Z | 2024-09-11T12:20:14.608Z |
4992312 | 4992312 | 20240902075031_j52Rk | CA000C | 2024-09-08T12:00:08.954Z | 2024-09-11T12:20:11.211Z |
4992230 | 4992230 | 20240901063704_c42Fn | CA000C | 2024-09-07T12:13:05.397Z | 2024-09-09T12:27:56.876Z |
4991736 | 4991736 | 20240901030745_81IB4 | CA000C | 2024-09-07T12:12:27.350Z | 2024-09-09T12:27:17.730Z |
4957271 | 4957271 | 20240811082703_PcKx4 | CA000C | 2024-09-03T12:21:01.881Z | 2024-09-06T12:31:12.589Z |
4957246 | 4957246 | 20240811082430_Kmp92 | CA000C | 2024-09-03T12:20:58.996Z | 2024-09-06T12:31:10.517Z |
4957056 | 4957056 | 20240811081050_2QYw2 | CA000C | 2024-09-03T12:20:48.043Z | 2024-09-06T12:31:00.139Z |
4956912 | 4956912 | 20240811080021_3FXu8 | CA000C | 2024-09-03T12:20:43.162Z | 2024-09-06T12:30:54.597Z |
4956681 | 4956681 | 20240811073959_SggKE | CA000C | 2024-09-03T12:20:35.362Z | 2024-09-06T12:30:43.373Z |
4956670 | 4956670 | 20240811073915_Wn9O3 | CA000C | 2024-09-03T12:20:35.044Z | 2024-09-06T12:30:43.031Z |
4956409 | 4956409 | 20240811071542_tHmOQ | CA000C | 2024-09-03T12:20:22.930Z | 2024-09-06T12:30:30.608Z |
4956351 | 4956351 | 20240811070944_a5eBa | CA000C | 2024-09-03T12:20:17.330Z | 2024-09-06T12:30:27.125Z |
4956214 | 4956214 | 20240811065649_Wl3sh | CA000C | 2024-09-03T12:20:04.888Z | 2024-09-06T12:30:21.334Z |
4955827 | 4955827 | 20240811060939_dCfrr | CA000C | 2024-09-03T12:19:28.681Z | 2024-09-06T12:30:00.629Z |
4955677 | 4955677 | 20240811054833_Vc42Y | CA000C | 2024-09-03T12:19:22.611Z | 2024-09-06T12:29:53.151Z |
4955619 | 4955619 | 20240811053825_XpxTt | CA000C | 2024-09-03T12:19:20.699Z | 2024-09-06T12:29:51.097Z |
4955604 | 4955604 | 20240811053554_uWPch | CA000C | 2024-09-03T12:19:20.332Z | 2024-09-06T12:29:50.593Z |
4955578 | 4955578 | 20240811053054_DixuI | CA000C | 2024-09-03T12:19:19.313Z | 2024-09-06T12:29:48.693Z |
4955496 | 4955496 | 20240811051604_GCzDg | CA000C | 2024-09-03T12:19:16.268Z | 2024-09-06T12:29:44.596Z |
4955373 | 4955373 | 20240811044627_lpzOY | CA000C | 2024-09-03T12:19:10.570Z | 2024-09-06T12:29:36.832Z |
4955272 | 4955272 | 20240811041827_VPrJ8 | CA000C | 2024-09-03T12:19:02.977Z | 2024-09-06T12:29:29.981Z |
4955234 | 4955234 | 20240811040555_3Ym9G | CA000C | 2024-09-03T12:18:58.911Z | 2024-09-06T12:29:27.051Z |
4955136 | 4955136 | 20240811034609_3I81W | CA000C | 2024-09-03T12:18:47.919Z | 2024-09-06T12:29:20.717Z |
4954173 | 4954173 | 20240811025343_yGBF2 | CA000C | 2024-09-03T12:18:08.914Z | 2024-09-06T12:28:52.320Z |
4953958 | 4953958 | 20240811024852_6mQgk | CA000C | 2024-09-03T12:18:04.553Z | 2024-09-06T12:28:43.916Z |
4953581 | 4953581 | 20240811024118_qTuQv | CA000C | 2024-09-03T12:17:49.507Z | 2024-09-06T12:28:31.709Z |
4953540 | 4953540 | 20240811024023_hWolR | CA000C | 2024-09-03T12:17:46.912Z | 2024-09-06T12:28:30.176Z |
4953318 | 4953318 | 20240811023616_BZ3LO | CA000C | 2024-09-03T12:17:34.237Z | 2024-09-06T12:28:23.464Z |
4952895 | 4952895 | 20240811022837_h6a4A | CA000C | 2024-09-03T12:17:08.539Z | 2024-09-06T12:28:12.024Z |
4885104 | 4885104 | 20240807075357_Ock2J | CA000C | 2024-08-20T12:16:15.521Z | 2024-08-27T12:16:54.353Z |
4884982 | 4884982 | 20240807072652_9ZS20 | CA000C | 2024-08-20T12:16:09.561Z | 2024-08-27T12:16:43.010Z |
4884899 | 4884899 | 20240807070230_jVtuD | CA000C | 2024-08-20T12:16:06.329Z | 2024-08-27T12:16:38.200Z |
4884845 | 4884845 | 20240807064132_hfK2w | CA000C | 2024-08-20T12:16:04.189Z | 2024-08-27T12:16:36.177Z |
4884787 | 4884787 | 20240807061724_ZyO7K | CA000C | 2024-08-20T12:16:01.339Z | 2024-08-27T12:16:33.250Z |
4884785 | 4884785 | 20240807061715_U9nRS | CA000C | 2024-08-20T12:16:01.265Z | 2024-08-27T12:16:33.175Z |
4884723 | 4884723 | 20240807053120_JiAYU | CA000C | 2024-08-20T12:15:58.050Z | 2024-08-27T12:16:30.644Z |
4884717 | 4884717 | 20240807052904_3edq3 | CA000C | 2024-08-20T12:15:57.773Z | 2024-08-27T12:16:30.352Z |
4884688 | 4884688 | 20240807051308_q3rSe | CA000C | 2024-08-20T12:15:56.209Z | 2024-08-27T12:16:28.900Z |
4884665 | 4884665 | 20240807045447_mwTRK | CA000C | 2024-08-20T12:15:54.863Z | 2024-08-27T12:16:27.792Z |
4868578 | 4868578 | 20240806064941_sy03o | CA000C | 2024-08-18T12:24:17.326Z | 2024-08-19T12:28:49.161Z |
4868214 | 4868214 | 20240806060944_2cp0W | CA000C | 2024-08-18T12:24:02.726Z | 2024-08-19T12:28:41.748Z |
4868138 | 4868138 | 20240806054752_nwe37 | CA000C | 2024-08-18T12:24:00.229Z | 2024-08-19T12:28:36.036Z |
4868122 | 4868122 | 20240806054632_44xSM | CA000C | 2024-08-18T12:23:59.604Z | 2024-08-19T12:28:34.236Z |
4867886 | 4867886 | 20240806043150_PelFG | CA000C | 2024-08-18T12:23:52.206Z | 2024-08-19T12:28:29.583Z |
4867844 | 4867844 | 20240806041626_Xu2bC | CA000C | 2024-08-18T12:23:50.782Z | 2024-08-19T12:28:28.322Z |
4867837 | 4867837 | 20240806041231_xWICW | CA000C | 2024-08-18T12:23:50.625Z | 2024-08-19T12:28:28.210Z |
4867825 | 4867825 | 20240806041026_PUxzW | CA000C | 2024-08-18T12:23:50.086Z | 2024-08-19T12:28:27.909Z |
4867816 | 4867816 | 20240806040847_P8NwB | CA000C | 2024-08-18T12:23:49.645Z | 2024-08-19T12:28:27.606Z |
4867810 | 4867810 | 20240806040614_B01kT | CA000C | 2024-08-18T12:23:48.644Z | 2024-08-19T12:28:27.371Z |
4858021 | 4858021 | 20240806074744_kOmhT | CA000C | 2024-08-18T12:00:20.119Z | 2024-08-27T12:00:29.990Z |
4857795 | 4857795 | 20240806031104_w2n3f | CA000C | 2024-08-17T12:23:04.921Z | 2024-08-19T12:28:23.391Z |
4857007 | 4857007 | 20240806020201_Apbx2 | CA000C | 2024-08-17T12:22:00.279Z | 2024-08-19T12:27:52.437Z |
4847816 | 4847816 | 20240805060705_EMn64 | CA000C | 2024-08-16T12:21:12.939Z | 2024-08-17T12:33:16.964Z |
4847619 | 4847619 | 20240805045723_LKQNH | CA000C | 2024-08-16T12:21:03.014Z | 2024-08-17T12:33:08.883Z |
4847560 | 4847560 | 20240805043315_77EIk | CA000C | 2024-08-16T12:21:00.774Z | 2024-08-17T12:33:06.611Z |
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);