participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,185 rows where station_code = "BE000S" 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 |
---|---|---|---|---|---|
5133264 | 5133264 | 20240916031522_UBSwd | BE000S | 2024-09-19T12:16:52.205Z | 2024-09-19T12:16:52.205Z |
5121598 | 5121598 | 20240914041024_2woyK | BE000S | 2024-09-18T12:10:58.859Z | 2024-09-19T12:20:02.183Z |
5121449 | 5121449 | 20240914040308_pK5Wv | BE000S | 2024-09-18T12:10:55.611Z | 2024-09-19T12:20:01.861Z |
5121345 | 5121345 | 20240914035837_amhuE | BE000S | 2024-09-18T12:10:54.639Z | 2024-09-19T12:20:01.667Z |
5121060 | 5121060 | 20240914034958_KX1oF | BE000S | 2024-09-18T12:10:50.382Z | 2024-09-19T12:20:01.275Z |
5121043 | 5121043 | 20240914034916_zQbj3 | BE000S | 2024-09-18T12:10:50.254Z | 2024-09-19T12:20:01.250Z |
5121030 | 5121030 | 20240914034849_zDqWC | BE000S | 2024-09-18T12:10:49.858Z | 2024-09-19T12:20:01.247Z |
5120984 | 5120984 | 20240914034307_vp0D5 | BE000S | 2024-09-18T12:10:49.000Z | 2024-09-19T12:20:01.083Z |
5120872 | 5120872 | 20240914033908_dn0TO | BE000S | 2024-09-18T12:10:48.326Z | 2024-09-19T12:20:00.990Z |
5120863 | 5120863 | 20240914033820_KUWGD | BE000S | 2024-09-18T12:10:48.093Z | 2024-09-19T12:20:00.977Z |
5120365 | 5120365 | 20240914031805_ygy9k | BE000S | 2024-09-18T12:10:38.524Z | 2024-09-19T12:20:00.069Z |
5120154 | 5120154 | 20240914030254_uI01w | BE000S | 2024-09-18T12:10:33.127Z | 2024-09-19T12:19:59.503Z |
5120151 | 5120151 | 20240914030254_J7tQv | BE000S | 2024-09-18T12:10:33.041Z | 2024-09-19T12:19:59.502Z |
5120020 | 5120020 | 20240914025722_PcJEe | BE000S | 2024-09-18T12:10:31.102Z | 2024-09-19T12:19:59.303Z |
5119995 | 5119995 | 20240914025613_NKcHL | BE000S | 2024-09-18T12:10:30.981Z | 2024-09-19T12:19:59.298Z |
5119784 | 5119784 | 20240914025006_o75sB | BE000S | 2024-09-18T12:10:27.131Z | 2024-09-19T12:19:58.950Z |
5119552 | 5119552 | 20240914023847_ALLsW | BE000S | 2024-09-18T12:10:22.287Z | 2024-09-19T12:19:58.535Z |
5119411 | 5119411 | 20240914023143_BcW4W | BE000S | 2024-09-18T12:10:20.841Z | 2024-09-19T12:19:58.123Z |
5119304 | 5119304 | 20240914022236_hUiEw | BE000S | 2024-09-18T12:10:19.628Z | 2024-09-19T12:19:57.658Z |
5119261 | 5119261 | 20240914021919_rxIxd | BE000S | 2024-09-18T12:10:18.940Z | 2024-09-19T12:19:57.517Z |
5119165 | 5119165 | 20240914021501_V5W2Z | BE000S | 2024-09-18T12:10:17.659Z | 2024-09-19T12:19:57.325Z |
5119090 | 5119090 | 20240914020836_ZNRaX | BE000S | 2024-09-18T12:10:15.710Z | 2024-09-19T12:19:57.039Z |
5117144 | 5117144 | 20240915040541_BfMCm | BE000S | 2024-09-18T12:07:33.849Z | 2024-09-19T12:19:13.579Z |
5116825 | 5116825 | 20240915034352_Eszy2 | BE000S | 2024-09-18T12:07:22.203Z | 2024-09-19T12:19:12.445Z |
5116724 | 5116724 | 20240915033738_066rv | BE000S | 2024-09-18T12:07:17.757Z | 2024-09-19T12:19:12.128Z |
5116680 | 5116680 | 20240915033617_t2WnM | BE000S | 2024-09-18T12:07:16.419Z | 2024-09-19T12:19:12.011Z |
5116382 | 5116382 | 20240915032406_y9EmQ | BE000S | 2024-09-18T12:07:00.494Z | 2024-09-19T12:19:10.776Z |
5116150 | 5116150 | 20240915031208_XxihI | BE000S | 2024-09-18T12:06:44.155Z | 2024-09-19T12:19:09.016Z |
5116147 | 5116147 | 20240915031202_13Yey | BE000S | 2024-09-18T12:06:43.946Z | 2024-09-19T12:19:08.984Z |
5116080 | 5116080 | 20240915030728_jgrym | BE000S | 2024-09-18T12:06:38.041Z | 2024-09-19T12:19:08.430Z |
5115458 | 5115458 | 20240915023930_xrJzS | BE000S | 2024-09-18T12:06:15.103Z | 2024-09-19T12:19:04.845Z |
5115174 | 5115174 | 20240915022420_XQyfW | BE000S | 2024-09-18T12:06:04.904Z | 2024-09-19T12:19:02.696Z |
5115117 | 5115117 | 20240915022110_a7Esi | BE000S | 2024-09-18T12:06:01.000Z | 2024-09-19T12:19:01.688Z |
5115103 | 5115103 | 20240915022025_UDeCm | BE000S | 2024-09-18T12:05:59.536Z | 2024-09-19T12:19:01.609Z |
5115064 | 5115064 | 20240915021638_adeLB | BE000S | 2024-09-18T12:05:55.309Z | 2024-09-19T12:19:01.328Z |
5114805 | 5114805 | 20240915020000_wvB83 | BE000S | 2024-09-18T12:05:35.335Z | 2024-09-19T12:19:00.045Z |
5114755 | 5114755 | 20240915015734_8d2Mt | BE000S | 2024-09-18T12:05:33.387Z | 2024-09-19T12:18:59.840Z |
5114709 | 5114709 | 20240915015606_GmgxC | BE000S | 2024-09-18T12:05:30.359Z | 2024-09-19T12:18:59.472Z |
5114578 | 5114578 | 20240915014947_gdmph | BE000S | 2024-09-18T12:05:22.517Z | 2024-09-19T12:18:58.970Z |
5114013 | 5114013 | 20240915012300_9lgcl | BE000S | 2024-09-18T12:04:58.355Z | 2024-09-19T12:18:55.269Z |
5113882 | 5113882 | 20240915011748_2SEr3 | BE000S | 2024-09-18T12:04:54.527Z | 2024-09-19T12:18:54.028Z |
5113664 | 5113664 | 20240915010441_jNcrg | BE000S | 2024-09-18T12:04:38.013Z | 2024-09-19T12:18:50.935Z |
5113574 | 5113574 | 20240915005852_RNtrB | BE000S | 2024-09-18T12:04:32.003Z | 2024-09-19T12:18:50.432Z |
5113542 | 5113542 | 20240915005713_LzVtZ | BE000S | 2024-09-18T12:04:27.606Z | 2024-09-19T12:18:50.158Z |
5113472 | 5113472 | 20240915005143_C0H5r | BE000S | 2024-09-18T12:04:22.132Z | 2024-09-19T12:18:49.501Z |
5113369 | 5113369 | 20240915004059_gJe92 | BE000S | 2024-09-18T12:04:10.373Z | 2024-09-19T12:18:48.638Z |
5113228 | 5113228 | 20240915003234_5wPlB | BE000S | 2024-09-18T12:04:03.884Z | 2024-09-19T12:18:48.067Z |
5113155 | 5113155 | 20240915002714_rTFDh | BE000S | 2024-09-18T12:03:59.515Z | 2024-09-19T12:18:47.630Z |
5113133 | 5113133 | 20240915002418_dezUN | BE000S | 2024-09-18T12:03:58.029Z | 2024-09-19T12:18:47.401Z |
5112766 | 5112766 | 20240914235234_rzWgt | BE000S | 2024-09-18T12:03:29.895Z | 2024-09-19T12:18:44.449Z |
5111287 | 5111287 | 20240914201858_183zE | BE000S | 2024-09-18T12:01:47.472Z | 2024-09-19T12:18:28.461Z |
5111226 | 5111226 | 20240914201255_zmN0h | BE000S | 2024-09-18T12:01:44.338Z | 2024-09-19T12:18:27.890Z |
5110908 | 5110908 | 20240914192508_5u6Hj | BE000S | 2024-09-18T12:01:11.050Z | 2024-09-19T12:18:24.679Z |
5110851 | 5110851 | 20240914191250_W3qZH | BE000S | 2024-09-18T12:01:05.552Z | 2024-09-19T12:18:24.259Z |
5110844 | 5110844 | 20240914190414_EYgXU | BE000S | 2024-09-18T12:01:04.723Z | 2024-09-19T12:18:24.200Z |
5110836 | 5110836 | 20240914190227_4zvH5 | BE000S | 2024-09-18T12:01:03.818Z | 2024-09-19T12:18:24.144Z |
5107432 | 5107432 | 20240913035710_1RVpG | BE000S | 2024-09-17T12:13:15.456Z | 2024-09-19T12:20:47.154Z |
5107269 | 5107269 | 20240913035012_Hw78w | BE000S | 2024-09-17T12:13:12.128Z | 2024-09-19T12:20:46.972Z |
5107015 | 5107015 | 20240913034213_rhSL3 | BE000S | 2024-09-17T12:13:08.022Z | 2024-09-19T12:20:46.777Z |
5106974 | 5106974 | 20240913034117_EFc2w | BE000S | 2024-09-17T12:13:05.980Z | 2024-09-19T12:20:46.692Z |
5106667 | 5106667 | 20240913033153_vdvis | BE000S | 2024-09-17T12:12:59.342Z | 2024-09-19T12:20:46.269Z |
5106381 | 5106381 | 20240913032253_cPBMZ | BE000S | 2024-09-17T12:12:51.931Z | 2024-09-19T12:20:46.019Z |
5106255 | 5106255 | 20240913031554_zuqIh | BE000S | 2024-09-17T12:12:45.551Z | 2024-09-19T12:20:45.684Z |
5106193 | 5106193 | 20240913031535_9NnnE | BE000S | 2024-09-17T12:12:44.792Z | 2024-09-19T12:20:45.625Z |
5106121 | 5106121 | 20240913031210_yCMrS | BE000S | 2024-09-17T12:12:42.615Z | 2024-09-19T12:20:45.506Z |
5106103 | 5106103 | 20240913031144_GR0PG | BE000S | 2024-09-17T12:12:42.401Z | 2024-09-19T12:20:45.496Z |
5106063 | 5106063 | 20240913030824_NgGIU | BE000S | 2024-09-17T12:12:40.557Z | 2024-09-19T12:20:45.409Z |
5105932 | 5105932 | 20240913030319_p2THx | BE000S | 2024-09-17T12:12:33.462Z | 2024-09-19T12:20:45.058Z |
5105819 | 5105819 | 20240913025946_XePUJ | BE000S | 2024-09-17T12:12:30.176Z | 2024-09-19T12:20:44.970Z |
5105768 | 5105768 | 20240913025726_16u4x | BE000S | 2024-09-17T12:12:28.743Z | 2024-09-19T12:20:44.873Z |
5105259 | 5105259 | 20240913024007_rRyxQ | BE000S | 2024-09-17T12:12:07.112Z | 2024-09-19T12:20:44.211Z |
5105107 | 5105107 | 20240913023118_mSHql | BE000S | 2024-09-17T12:11:55.661Z | 2024-09-19T12:20:43.681Z |
5105103 | 5105103 | 20240913023041_WI3xA | BE000S | 2024-09-17T12:11:54.702Z | 2024-09-19T12:20:43.511Z |
5105016 | 5105016 | 20240913022721_yiFq6 | BE000S | 2024-09-17T12:11:50.027Z | 2024-09-19T12:20:43.418Z |
5104580 | 5104580 | 20240913021545_nWnoy | BE000S | 2024-09-17T12:11:39.907Z | 2024-09-19T12:20:42.518Z |
5104524 | 5104524 | 20240913021410_moKsI | BE000S | 2024-09-17T12:11:37.948Z | 2024-09-19T12:20:41.621Z |
5104416 | 5104416 | 20240913020751_1LqQv | BE000S | 2024-09-17T12:11:35.075Z | 2024-09-19T12:20:41.463Z |
5104335 | 5104335 | 20240913020544_HdYKe | BE000S | 2024-09-17T12:11:33.642Z | 2024-09-19T12:20:41.417Z |
5104171 | 5104171 | 20240913015710_069k5 | BE000S | 2024-09-17T12:11:28.278Z | 2024-09-19T12:20:41.188Z |
5103861 | 5103861 | 20240913014227_WQFdh | BE000S | 2024-09-17T12:11:14.367Z | 2024-09-19T12:20:40.633Z |
5103594 | 5103594 | 20240913013343_0933s | BE000S | 2024-09-17T12:11:05.050Z | 2024-09-19T12:20:40.360Z |
5103487 | 5103487 | 20240913013131_NoK0e | BE000S | 2024-09-17T12:10:59.999Z | 2024-09-19T12:20:40.222Z |
5103073 | 5103073 | 20240914020006_Ji27p | BE000S | 2024-09-17T12:07:50.507Z | 2024-09-19T12:19:56.500Z |
5102886 | 5102886 | 20240914015153_MJM8w | BE000S | 2024-09-17T12:07:41.909Z | 2024-09-19T12:19:56.050Z |
5102768 | 5102768 | 20240914014257_oVkyx | BE000S | 2024-09-17T12:07:35.560Z | 2024-09-19T12:19:55.612Z |
5102658 | 5102658 | 20240914013538_92T9J | BE000S | 2024-09-17T12:07:29.585Z | 2024-09-19T12:19:55.314Z |
5102456 | 5102456 | 20240914012657_3GSI3 | BE000S | 2024-09-17T12:07:13.967Z | 2024-09-19T12:19:54.503Z |
5102453 | 5102453 | 20240914012646_jPIK5 | BE000S | 2024-09-17T12:07:13.398Z | 2024-09-19T12:19:54.480Z |
5102172 | 5102172 | 20240914011049_UeVDN | BE000S | 2024-09-17T12:06:53.240Z | 2024-09-19T12:19:52.718Z |
5101997 | 5101997 | 20240914005907_3Ajdi | BE000S | 2024-09-17T12:06:38.358Z | 2024-09-19T12:19:52.147Z |
5101872 | 5101872 | 20240914005329_m4KmN | BE000S | 2024-09-17T12:06:19.248Z | 2024-09-19T12:19:51.753Z |
5101838 | 5101838 | 20240914004942_JlZYU | BE000S | 2024-09-17T12:06:16.596Z | 2024-09-19T12:19:51.632Z |
5101568 | 5101568 | 20240914003548_IbtzG | BE000S | 2024-09-17T12:06:02.562Z | 2024-09-19T12:19:50.970Z |
5101457 | 5101457 | 20240914002706_7HBNT | BE000S | 2024-09-17T12:05:52.328Z | 2024-09-19T12:19:50.613Z |
5101416 | 5101416 | 20240914002604_VczWQ | BE000S | 2024-09-17T12:05:45.745Z | 2024-09-19T12:19:50.497Z |
5101339 | 5101339 | 20240914002126_PID9W | BE000S | 2024-09-17T12:05:37.140Z | 2024-09-19T12:19:50.330Z |
5101180 | 5101180 | 20240914000931_ztsGZ | BE000S | 2024-09-17T12:05:24.739Z | 2024-09-19T12:19:49.987Z |
5101130 | 5101130 | 20240914000554_6ChvX | BE000S | 2024-09-17T12:05:21.432Z | 2024-09-19T12:19:49.836Z |
5097951 | 5097951 | 20240913011006_caqMo | BE000S | 2024-09-16T12:17:17.124Z | 2024-09-19T12:20:39.216Z |
5097378 | 5097378 | 20240913004434_GiJBk | BE000S | 2024-09-16T12:17:11.795Z | 2024-09-19T12:20:38.457Z |
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);