participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
11,468 rows where station_code = "BE000B" 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 |
---|---|---|---|---|---|
5133092 | 5133092 | 20240916025115_WayEh | BE000B | 2024-09-19T12:16:44.130Z | 2024-09-19T12:16:44.130Z |
5132711 | 5132711 | 20240916020109_Ts3FA | BE000B | 2024-09-19T12:16:29.109Z | 2024-09-19T12:16:29.109Z |
5127157 | 5127157 | 20240916203434_vsR8C | BE000B | 2024-09-19T12:08:20.220Z | 2024-09-19T12:08:20.220Z |
5125695 | 5125695 | 20240918032137_XiIto | BE000B | 2024-09-19T12:03:54.156Z | 2024-09-19T12:06:42.070Z |
5125238 | 5125238 | 20240918012932_Sd38K | BE000B | 2024-09-19T12:02:33.976Z | 2024-09-19T12:06:41.997Z |
5125153 | 5125153 | 20240918003333_OmqOT | BE000B | 2024-09-19T12:02:24.484Z | 2024-09-19T12:06:41.983Z |
5125020 | 5125020 | 20240917233305_5PT2n | BE000B | 2024-09-19T12:01:57.125Z | 2024-09-19T12:06:41.962Z |
5121790 | 5121790 | 20240914041439_BclDK | BE000B | 2024-09-18T12:11:01.417Z | 2024-09-19T12:20:02.369Z |
5121216 | 5121216 | 20240914035531_r1VaK | BE000B | 2024-09-18T12:10:52.438Z | 2024-09-19T12:20:01.494Z |
5121019 | 5121019 | 20240914034805_CtkNG | BE000B | 2024-09-18T12:10:49.452Z | 2024-09-19T12:20:01.161Z |
5120880 | 5120880 | 20240914034021_0GOMo | BE000B | 2024-09-18T12:10:48.389Z | 2024-09-19T12:20:00.995Z |
5120772 | 5120772 | 20240914033522_Iae8b | BE000B | 2024-09-18T12:10:46.656Z | 2024-09-19T12:20:00.856Z |
5120555 | 5120555 | 20240914032801_Gq8pV | BE000B | 2024-09-18T12:10:43.124Z | 2024-09-19T12:20:00.565Z |
5120146 | 5120146 | 20240914030215_vgsMX | BE000B | 2024-09-18T12:10:32.974Z | 2024-09-19T12:19:59.499Z |
5120056 | 5120056 | 20240914025821_3O2iZ | BE000B | 2024-09-18T12:10:31.620Z | 2024-09-19T12:19:59.363Z |
5119957 | 5119957 | 20240914025447_y4ee4 | BE000B | 2024-09-18T12:10:29.962Z | 2024-09-19T12:19:59.194Z |
5119757 | 5119757 | 20240914024809_4lyde | BE000B | 2024-09-18T12:10:25.871Z | 2024-09-19T12:19:58.884Z |
5119648 | 5119648 | 20240914024200_FDIBL | BE000B | 2024-09-18T12:10:22.886Z | 2024-09-19T12:19:58.645Z |
5119535 | 5119535 | 20240914023837_UfZw2 | BE000B | 2024-09-18T12:10:22.187Z | 2024-09-19T12:19:58.485Z |
5119458 | 5119458 | 20240914023600_2u6WP | BE000B | 2024-09-18T12:10:21.526Z | 2024-09-19T12:19:58.286Z |
5119368 | 5119368 | 20240914022955_aPR5h | BE000B | 2024-09-18T12:10:20.652Z | 2024-09-19T12:19:58.099Z |
5119330 | 5119330 | 20240914022430_7TtkH | BE000B | 2024-09-18T12:10:20.097Z | 2024-09-19T12:19:57.979Z |
5119234 | 5119234 | 20240914021832_IPZrP | BE000B | 2024-09-18T12:10:18.773Z | 2024-09-19T12:19:57.474Z |
5119148 | 5119148 | 20240914021347_8OpnT | BE000B | 2024-09-18T12:10:16.762Z | 2024-09-19T12:19:57.242Z |
5117336 | 5117336 | 20240915041928_38V2e | BE000B | 2024-09-18T12:07:38.064Z | 2024-09-19T12:19:14.339Z |
5117273 | 5117273 | 20240915041611_3DJeO | BE000B | 2024-09-18T12:07:36.714Z | 2024-09-19T12:19:14.077Z |
5117108 | 5117108 | 20240915040324_9is9q | BE000B | 2024-09-18T12:07:32.969Z | 2024-09-19T12:19:13.432Z |
5117042 | 5117042 | 20240915035814_CY30F | BE000B | 2024-09-18T12:07:30.917Z | 2024-09-19T12:19:13.191Z |
5116739 | 5116739 | 20240915033819_nYvn5 | BE000B | 2024-09-18T12:07:18.368Z | 2024-09-19T12:19:12.181Z |
5116728 | 5116728 | 20240915033743_DLNH3 | BE000B | 2024-09-18T12:07:17.888Z | 2024-09-19T12:19:12.157Z |
5116654 | 5116654 | 20240915033422_KaH04 | BE000B | 2024-09-18T12:07:14.904Z | 2024-09-19T12:19:11.859Z |
5116641 | 5116641 | 20240915033408_cQhJ8 | BE000B | 2024-09-18T12:07:14.386Z | 2024-09-19T12:19:11.822Z |
5116475 | 5116475 | 20240915032817_TRmlT | BE000B | 2024-09-18T12:07:05.338Z | 2024-09-19T12:19:11.292Z |
5116129 | 5116129 | 20240915031015_glnIT | BE000B | 2024-09-18T12:06:42.036Z | 2024-09-19T12:19:08.799Z |
5116118 | 5116118 | 20240915030933_0WgNj | BE000B | 2024-09-18T12:06:41.187Z | 2024-09-19T12:19:08.791Z |
5116003 | 5116003 | 20240915030316_33M1f | BE000B | 2024-09-18T12:06:33.897Z | 2024-09-19T12:19:08.153Z |
5115874 | 5115874 | 20240915025750_tvoiv | BE000B | 2024-09-18T12:06:30.510Z | 2024-09-19T12:19:07.685Z |
5115707 | 5115707 | 20240915025025_RPLyx | BE000B | 2024-09-18T12:06:21.677Z | 2024-09-19T12:19:06.481Z |
5115632 | 5115632 | 20240915024646_wH3WO | BE000B | 2024-09-18T12:06:19.919Z | 2024-09-19T12:19:05.848Z |
5115445 | 5115445 | 20240915023908_2Lzv1 | BE000B | 2024-09-18T12:06:14.761Z | 2024-09-19T12:19:04.821Z |
5115105 | 5115105 | 20240915022026_sK1DC | BE000B | 2024-09-18T12:05:59.852Z | 2024-09-19T12:19:01.623Z |
5115070 | 5115070 | 20240915021703_UVT0U | BE000B | 2024-09-18T12:05:55.990Z | 2024-09-19T12:19:01.447Z |
5114986 | 5114986 | 20240915021258_JeGl2 | BE000B | 2024-09-18T12:05:49.625Z | 2024-09-19T12:19:01.058Z |
5114974 | 5114974 | 20240915021249_oqYtA | BE000B | 2024-09-18T12:05:48.451Z | 2024-09-19T12:19:00.937Z |
5114954 | 5114954 | 20240915020951_Us3hh | BE000B | 2024-09-18T12:05:45.911Z | 2024-09-19T12:19:00.818Z |
5114698 | 5114698 | 20240915015523_OwM1a | BE000B | 2024-09-18T12:05:29.966Z | 2024-09-19T12:18:59.403Z |
5114612 | 5114612 | 20240915015225_PAl02 | BE000B | 2024-09-18T12:05:25.858Z | 2024-09-19T12:18:59.081Z |
5114582 | 5114582 | 20240915015105_XYGtF | BE000B | 2024-09-18T12:05:23.110Z | 2024-09-19T12:18:58.992Z |
5114574 | 5114574 | 20240915014946_Y4rGe | BE000B | 2024-09-18T12:05:22.406Z | 2024-09-19T12:18:58.947Z |
5114513 | 5114513 | 20240915014526_hjs1e | BE000B | 2024-09-18T12:05:20.156Z | 2024-09-19T12:18:58.609Z |
5114463 | 5114463 | 20240915014321_NIXXE | BE000B | 2024-09-18T12:05:19.044Z | 2024-09-19T12:18:58.420Z |
5114440 | 5114440 | 20240915014238_uLU3a | BE000B | 2024-09-18T12:05:16.925Z | 2024-09-19T12:18:58.199Z |
5114369 | 5114369 | 20240915014039_Bk7ss | BE000B | 2024-09-18T12:05:13.928Z | 2024-09-19T12:18:57.913Z |
5114160 | 5114160 | 20240915012958_O0xMI | BE000B | 2024-09-18T12:05:04.769Z | 2024-09-19T12:18:56.562Z |
5114140 | 5114140 | 20240915012915_BAzt9 | BE000B | 2024-09-18T12:05:04.132Z | 2024-09-19T12:18:56.405Z |
5113650 | 5113650 | 20240915010258_5vMGz | BE000B | 2024-09-18T12:04:36.642Z | 2024-09-19T12:18:50.876Z |
5113488 | 5113488 | 20240915005300_BZ1U2 | BE000B | 2024-09-18T12:04:24.104Z | 2024-09-19T12:18:49.696Z |
5113483 | 5113483 | 20240915005231_NhduE | BE000B | 2024-09-18T12:04:23.049Z | 2024-09-19T12:18:49.628Z |
5113468 | 5113468 | 20240915005142_pH99t | BE000B | 2024-09-18T12:04:21.879Z | 2024-09-19T12:18:49.484Z |
5113464 | 5113464 | 20240915005136_m1uP7 | BE000B | 2024-09-18T12:04:21.160Z | 2024-09-19T12:18:49.449Z |
5113384 | 5113384 | 20240915004408_m02o8 | BE000B | 2024-09-18T12:04:12.032Z | 2024-09-19T12:18:48.782Z |
5113353 | 5113353 | 20240915003928_6K3G8 | BE000B | 2024-09-18T12:04:09.826Z | 2024-09-19T12:18:48.597Z |
5112450 | 5112450 | 20240914231706_QKode | BE000B | 2024-09-18T12:03:07.792Z | 2024-09-19T12:18:41.046Z |
5112314 | 5112314 | 20240914225731_ShpCT | BE000B | 2024-09-18T12:02:59.778Z | 2024-09-19T12:18:40.509Z |
5112309 | 5112309 | 20240914225544_53fBu | BE000B | 2024-09-18T12:02:59.278Z | 2024-09-19T12:18:40.476Z |
5112210 | 5112210 | 20240914223637_gboVA | BE000B | 2024-09-18T12:02:53.458Z | 2024-09-19T12:18:39.404Z |
5112132 | 5112132 | 20240914222427_IC7cE | BE000B | 2024-09-18T12:02:49.417Z | 2024-09-19T12:18:38.624Z |
5111919 | 5111919 | 20240914214238_Ps1ut | BE000B | 2024-09-18T12:02:31.113Z | 2024-09-19T12:18:35.291Z |
5111528 | 5111528 | 20240914204443_1i0n6 | BE000B | 2024-09-18T12:02:01.203Z | 2024-09-19T12:18:31.071Z |
5111134 | 5111134 | 20240914200412_kV9Et | BE000B | 2024-09-18T12:01:38.969Z | 2024-09-19T12:18:26.918Z |
5111113 | 5111113 | 20240914195916_xAK3G | BE000B | 2024-09-18T12:01:34.553Z | 2024-09-19T12:18:26.782Z |
5107817 | 5107817 | 20240913041144_1s6ON | BE000B | 2024-09-17T12:13:24.220Z | 2024-09-19T12:20:47.577Z |
5107812 | 5107812 | 20240913041111_ppxsb | BE000B | 2024-09-17T12:13:24.052Z | 2024-09-19T12:20:47.566Z |
5107318 | 5107318 | 20240913035244_r9TG4 | BE000B | 2024-09-17T12:13:13.233Z | 2024-09-19T12:20:47.002Z |
5107102 | 5107102 | 20240913034502_w3gxO | BE000B | 2024-09-17T12:13:09.360Z | 2024-09-19T12:20:46.842Z |
5107097 | 5107097 | 20240913034451_fS67p | BE000B | 2024-09-17T12:13:09.139Z | 2024-09-19T12:20:46.824Z |
5106803 | 5106803 | 20240913033538_U5EMJ | BE000B | 2024-09-17T12:13:02.037Z | 2024-09-19T12:20:46.442Z |
5106199 | 5106199 | 20240913031545_gJPIb | BE000B | 2024-09-17T12:12:44.960Z | 2024-09-19T12:20:45.635Z |
5106151 | 5106151 | 20240913031244_lBNaS | BE000B | 2024-09-17T12:12:43.436Z | 2024-09-19T12:20:45.546Z |
5105886 | 5105886 | 20240913030157_6ggA8 | BE000B | 2024-09-17T12:12:31.548Z | 2024-09-19T12:20:45.019Z |
5105694 | 5105694 | 20240913025508_UrweF | BE000B | 2024-09-17T12:12:26.709Z | 2024-09-19T12:20:44.801Z |
5105571 | 5105571 | 20240913025150_4cLx3 | BE000B | 2024-09-17T12:12:21.804Z | 2024-09-19T12:20:44.670Z |
5105306 | 5105306 | 20240913024136_GZ2H1 | BE000B | 2024-09-17T12:12:09.274Z | 2024-09-19T12:20:44.284Z |
5105298 | 5105298 | 20240913024123_tmqH0 | BE000B | 2024-09-17T12:12:08.804Z | 2024-09-19T12:20:44.265Z |
5105189 | 5105189 | 20240913023720_AH0tJ | BE000B | 2024-09-17T12:12:02.316Z | 2024-09-19T12:20:44.109Z |
5104839 | 5104839 | 20240913022156_n3Bko | BE000B | 2024-09-17T12:11:45.409Z | 2024-09-19T12:20:43.058Z |
5104557 | 5104557 | 20240913021513_Xr6d8 | BE000B | 2024-09-17T12:11:39.403Z | 2024-09-19T12:20:41.701Z |
5104476 | 5104476 | 20240913021049_dMpWi | BE000B | 2024-09-17T12:11:36.325Z | 2024-09-19T12:20:41.513Z |
5104473 | 5104473 | 20240913021041_R7VwA | BE000B | 2024-09-17T12:11:36.213Z | 2024-09-19T12:20:41.507Z |
5104328 | 5104328 | 20240913020517_GnkGQ | BE000B | 2024-09-17T12:11:33.296Z | 2024-09-19T12:20:41.365Z |
5104125 | 5104125 | 20240913015333_N8ycM | BE000B | 2024-09-17T12:11:26.325Z | 2024-09-19T12:20:41.045Z |
5103921 | 5103921 | 20240913014410_zSz3m | BE000B | 2024-09-17T12:11:17.608Z | 2024-09-19T12:20:40.673Z |
5103802 | 5103802 | 20240913014047_z3EeP | BE000B | 2024-09-17T12:11:11.587Z | 2024-09-19T12:20:40.579Z |
5103463 | 5103463 | 20240913013101_XK3yS | BE000B | 2024-09-17T12:10:58.532Z | 2024-09-19T12:20:40.189Z |
5102848 | 5102848 | 20240914014913_zCzsG | BE000B | 2024-09-17T12:07:40.104Z | 2024-09-19T12:19:55.909Z |
5102783 | 5102783 | 20240914014426_I5h5o | BE000B | 2024-09-17T12:07:36.365Z | 2024-09-19T12:19:55.643Z |
5102354 | 5102354 | 20240914012147_mYCQK | BE000B | 2024-09-17T12:07:04.446Z | 2024-09-19T12:19:53.881Z |
5102305 | 5102305 | 20240914011715_phYkN | BE000B | 2024-09-17T12:06:59.603Z | 2024-09-19T12:19:53.399Z |
5102264 | 5102264 | 20240914011348_ekvUo | BE000B | 2024-09-17T12:06:56.602Z | 2024-09-19T12:19:53.129Z |
5102066 | 5102066 | 20240914010421_OxR74 | BE000B | 2024-09-17T12:06:45.796Z | 2024-09-19T12:19:52.356Z |
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);