participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,325 rows where station_code = "UK00BN" 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 |
---|---|---|---|---|---|
5573257 | 5573257 | 20241121041636_xYWe0 | UK00BN | 2024-11-22T14:19:18.566Z | 2024-11-22T14:19:22.478Z |
5573196 | 5573196 | 20241121040641_AB5Fx | UK00BN | 2024-11-22T14:19:15.199Z | 2024-11-22T14:19:22.468Z |
5573104 | 5573104 | 20241121035144_9m4Tq | UK00BN | 2024-11-22T14:19:09.871Z | 2024-11-22T14:19:22.450Z |
5572913 | 5572913 | 20241121032407_ZN3ZM | UK00BN | 2024-11-22T14:18:58.065Z | 2024-11-22T14:19:22.412Z |
5572841 | 5572841 | 20241121031508_gieeP | UK00BN | 2024-11-22T14:18:52.859Z | 2024-11-22T14:19:22.400Z |
5572779 | 5572779 | 20241121030911_2WXyC | UK00BN | 2024-11-22T14:18:49.030Z | 2024-11-22T14:19:22.390Z |
5572742 | 5572742 | 20241121030409_hjZiI | UK00BN | 2024-11-22T14:18:47.035Z | 2024-11-22T14:19:22.384Z |
5572707 | 5572707 | 20241121030055_mungx | UK00BN | 2024-11-22T14:18:44.900Z | 2024-11-22T14:19:22.378Z |
5572697 | 5572697 | 20241121025743_5c0Qm | UK00BN | 2024-11-22T14:18:42.679Z | 2024-11-22T14:19:22.375Z |
5572606 | 5572606 | 20241121024929_fjZqu | UK00BN | 2024-11-22T14:18:39.403Z | 2024-11-22T14:19:22.361Z |
5572548 | 5572548 | 20241121023528_a4MwP | UK00BN | 2024-11-22T14:18:35.469Z | 2024-11-22T14:19:22.349Z |
5572510 | 5572510 | 20241121023011_2Pf3v | UK00BN | 2024-11-22T14:18:31.175Z | 2024-11-22T14:19:22.341Z |
5572419 | 5572419 | 20241121022016_3yQoS | UK00BN | 2024-11-22T14:18:25.180Z | 2024-11-22T14:19:22.326Z |
5572211 | 5572211 | 20241121014825_JH2QQ | UK00BN | 2024-11-22T14:18:04.930Z | 2024-11-22T14:19:22.280Z |
5572173 | 5572173 | 20241121014307_bGVhU | UK00BN | 2024-11-22T14:18:03.184Z | 2024-11-22T14:19:22.273Z |
5572015 | 5572015 | 20241121012053_QKQVL | UK00BN | 2024-11-22T14:17:52.796Z | 2024-11-22T14:19:22.242Z |
5571999 | 5571999 | 20241121011632_a8n6M | UK00BN | 2024-11-22T14:17:51.252Z | 2024-11-22T14:19:22.238Z |
5571985 | 5571985 | 20241121011624_sga12 | UK00BN | 2024-11-22T14:17:50.809Z | 2024-11-22T14:19:22.236Z |
5571892 | 5571892 | 20241121010144_4D4Q1 | UK00BN | 2024-11-22T14:17:45.473Z | 2024-11-22T14:19:22.217Z |
5571882 | 5571882 | 20241121005946_JI1I8 | UK00BN | 2024-11-22T14:17:44.390Z | 2024-11-22T14:19:22.214Z |
5571858 | 5571858 | 20241121005702_Vd50H | UK00BN | 2024-11-22T14:17:43.092Z | 2024-11-22T14:19:22.209Z |
5571805 | 5571805 | 20241121004851_TRVwJ | UK00BN | 2024-11-22T14:17:40.410Z | 2024-11-22T14:19:22.198Z |
5571748 | 5571748 | 20241121004013_iBVHN | UK00BN | 2024-11-22T14:17:37.377Z | 2024-11-22T14:19:22.186Z |
5571610 | 5571610 | 20241121001628_Rm7IX | UK00BN | 2024-11-22T14:17:22.666Z | 2024-11-22T14:19:22.158Z |
5571600 | 5571600 | 20241121001511_3TGaF | UK00BN | 2024-11-22T14:17:21.773Z | 2024-11-22T14:19:22.156Z |
5571596 | 5571596 | 20241121001220_yxeHR | UK00BN | 2024-11-22T14:17:21.686Z | 2024-11-22T14:19:22.155Z |
5571548 | 5571548 | 20241121000553_c2A26 | UK00BN | 2024-11-22T14:17:15.687Z | 2024-11-22T14:19:22.147Z |
5571500 | 5571500 | 20241120235835_v5gs3 | UK00BN | 2024-11-22T14:17:11.734Z | 2024-11-22T14:19:22.138Z |
5571448 | 5571448 | 20241120234822_3zDwu | UK00BN | 2024-11-22T14:17:07.326Z | 2024-11-22T14:19:22.127Z |
5571288 | 5571288 | 20241120231627_OdvB0 | UK00BN | 2024-11-22T14:16:48.219Z | 2024-11-22T14:19:22.091Z |
5571198 | 5571198 | 20241120225042_jlPNH | UK00BN | 2024-11-22T14:16:36.503Z | 2024-11-22T14:19:22.061Z |
5571113 | 5571113 | 20241120222547_6I0vn | UK00BN | 2024-11-22T14:16:26.679Z | 2024-11-22T14:19:22.044Z |
5571087 | 5571087 | 20241120221924_RIjY8 | UK00BN | 2024-11-22T14:16:22.652Z | 2024-11-22T14:19:22.039Z |
5571026 | 5571026 | 20241120215932_u2DQx | UK00BN | 2024-11-22T14:16:19.214Z | 2024-11-22T14:19:22.025Z |
5570993 | 5570993 | 20241120215210_XZLe3 | UK00BN | 2024-11-22T14:16:16.794Z | 2024-11-22T14:19:22.019Z |
5570962 | 5570962 | 20241120214616_TWBpJ | UK00BN | 2024-11-22T14:16:14.447Z | 2024-11-22T14:19:22.014Z |
5570815 | 5570815 | 20241120210550_sJyum | UK00BN | 2024-11-22T14:16:06.934Z | 2024-11-22T14:19:21.986Z |
5570676 | 5570676 | 20241120204003_2IpSl | UK00BN | 2024-11-22T14:16:00.098Z | 2024-11-22T14:19:21.961Z |
5570665 | 5570665 | 20241120203728_AG5WC | UK00BN | 2024-11-22T14:15:59.778Z | 2024-11-22T14:19:21.960Z |
5570626 | 5570626 | 20241120203048_zCOLu | UK00BN | 2024-11-22T14:15:57.048Z | 2024-11-22T14:19:21.952Z |
5570531 | 5570531 | 20241120195640_oZys4 | UK00BN | 2024-11-22T14:15:41.056Z | 2024-11-22T14:19:21.932Z |
5570335 | 5570335 | 20241120191947_65Z31 | UK00BN | 2024-11-22T14:15:10.331Z | 2024-11-22T14:19:21.899Z |
5570263 | 5570263 | 20241120190936_QrZ3M | UK00BN | 2024-11-22T14:15:04.926Z | 2024-11-22T14:19:21.889Z |
5570235 | 5570235 | 20241120190727_ZBeAY | UK00BN | 2024-11-22T14:15:03.283Z | 2024-11-22T14:19:21.885Z |
5570171 | 5570171 | 20241120185542_Qm231 | UK00BN | 2024-11-22T14:14:57.023Z | 2024-11-22T14:19:21.875Z |
5570058 | 5570058 | 20241120183036_tcydt | UK00BN | 2024-11-22T14:14:47.732Z | 2024-11-22T14:19:21.853Z |
5566498 | 5566498 | 20241121062353_hNJMf | UK00BN | 2024-11-22T14:03:01.123Z | 2024-11-22T14:03:01.123Z |
5566467 | 5566467 | 20241121061639_X12AV | UK00BN | 2024-11-22T14:02:57.080Z | 2024-11-22T14:02:57.080Z |
5566429 | 5566429 | 20241121061119_eGqDS | UK00BN | 2024-11-22T14:02:53.394Z | 2024-11-22T14:02:53.394Z |
5566372 | 5566372 | 20241121060531_rABoX | UK00BN | 2024-11-22T14:02:36.304Z | 2024-11-22T14:02:36.304Z |
5566323 | 5566323 | 20241121060057_wuDMm | UK00BN | 2024-11-22T14:02:27.421Z | 2024-11-22T14:02:27.421Z |
5566288 | 5566288 | 20241121055518_jMCEU | UK00BN | 2024-11-22T14:02:22.023Z | 2024-11-22T14:02:22.023Z |
5566194 | 5566194 | 20241121054451_Urxar | UK00BN | 2024-11-22T14:02:10.814Z | 2024-11-22T14:02:10.814Z |
5565999 | 5565999 | 20241121051617_ckVY1 | UK00BN | 2024-11-22T14:01:33.522Z | 2024-11-22T14:01:33.522Z |
5565953 | 5565953 | 20241121051045_4Fd2I | UK00BN | 2024-11-22T14:01:28.568Z | 2024-11-22T14:01:28.568Z |
5565847 | 5565847 | 20241121045409_2Z7Th | UK00BN | 2024-11-22T14:01:07.765Z | 2024-11-22T14:01:07.765Z |
5565816 | 5565816 | 20241121045042_m51no | UK00BN | 2024-11-22T14:01:00.781Z | 2024-11-22T14:01:00.781Z |
5565801 | 5565801 | 20241121044843_iD5pr | UK00BN | 2024-11-22T14:00:59.227Z | 2024-11-22T14:00:59.227Z |
5565670 | 5565670 | 20241121043359_pW6zr | UK00BN | 2024-11-22T14:00:38.209Z | 2024-11-22T14:00:38.209Z |
5565629 | 5565629 | 20241121042758_x2m3j | UK00BN | 2024-11-22T14:00:27.926Z | 2024-11-22T14:00:27.926Z |
5565610 | 5565610 | 20241121042558_Bql5z | UK00BN | 2024-11-22T14:00:24.362Z | 2024-11-22T14:00:24.362Z |
5565565 | 5565565 | 20241121042305_32Jao | UK00BN | 2024-11-22T14:00:18.615Z | 2024-11-22T14:00:18.615Z |
5565436 | 5565436 | 20241120042555_wL9TV | UK00BN | 2024-11-21T14:18:49.247Z | 2024-11-22T14:21:47.179Z |
5565435 | 5565435 | 20241120042545_2k62R | UK00BN | 2024-11-21T14:18:49.054Z | 2024-11-22T14:21:47.104Z |
5565277 | 5565277 | 20241120041307_59M2Q | UK00BN | 2024-11-21T14:18:44.538Z | 2024-11-22T14:21:45.071Z |
5565199 | 5565199 | 20241120040226_x4j2I | UK00BN | 2024-11-21T14:18:40.081Z | 2024-11-22T14:21:43.724Z |
5564992 | 5564992 | 20241120034406_L0Fqn | UK00BN | 2024-11-21T14:18:18.235Z | 2024-11-22T14:21:40.164Z |
5564933 | 5564933 | 20241120033948_lwV99 | UK00BN | 2024-11-21T14:18:15.538Z | 2024-11-22T14:21:39.660Z |
5564916 | 5564916 | 20241120033855_TRHeI | UK00BN | 2024-11-21T14:18:14.996Z | 2024-11-22T14:21:39.520Z |
5564877 | 5564877 | 20241120033423_gAe5H | UK00BN | 2024-11-21T14:18:11.309Z | 2024-11-22T14:21:37.593Z |
5564854 | 5564854 | 20241120033131_XML8L | UK00BN | 2024-11-21T14:18:07.986Z | 2024-11-22T14:21:37.002Z |
5564852 | 5564852 | 20241120033105_e5wgs | UK00BN | 2024-11-21T14:18:07.919Z | 2024-11-22T14:21:36.997Z |
5564717 | 5564717 | 20241120032219_gHO4P | UK00BN | 2024-11-21T14:17:59.228Z | 2024-11-22T14:21:35.859Z |
5564609 | 5564609 | 20241120031316_3aE3a | UK00BN | 2024-11-21T14:17:52.935Z | 2024-11-22T14:21:34.228Z |
5564606 | 5564606 | 20241120031309_YhpJk | UK00BN | 2024-11-21T14:17:52.592Z | 2024-11-22T14:21:34.186Z |
5564532 | 5564532 | 20241120030713_WRWKR | UK00BN | 2024-11-21T14:17:47.002Z | 2024-11-22T14:21:33.345Z |
5564512 | 5564512 | 20241120030449_VROSs | UK00BN | 2024-11-21T14:17:44.436Z | 2024-11-22T14:21:32.919Z |
5564475 | 5564475 | 20241120025913_nSexN | UK00BN | 2024-11-21T14:17:39.629Z | 2024-11-22T14:21:32.609Z |
5564364 | 5564364 | 20241120024942_tMJuz | UK00BN | 2024-11-21T14:17:30.730Z | 2024-11-22T14:21:30.864Z |
5564314 | 5564314 | 20241120024736_r9Dr5 | UK00BN | 2024-11-21T14:17:26.839Z | 2024-11-22T14:21:30.410Z |
5564294 | 5564294 | 20241120024644_RjdeP | UK00BN | 2024-11-21T14:17:25.607Z | 2024-11-22T14:21:30.073Z |
5564186 | 5564186 | 20241120023646_g4qf3 | UK00BN | 2024-11-21T14:17:16.851Z | 2024-11-22T14:21:28.574Z |
5564099 | 5564099 | 20241120022833_sBY62 | UK00BN | 2024-11-21T14:17:08.831Z | 2024-11-22T14:21:26.907Z |
5563906 | 5563906 | 20241120021456_frYdJ | UK00BN | 2024-11-21T14:16:56.744Z | 2024-11-22T14:21:24.916Z |
5563858 | 5563858 | 20241120021035_o1ih9 | UK00BN | 2024-11-21T14:16:51.224Z | 2024-11-22T14:21:24.028Z |
5563832 | 5563832 | 20241120020908_3lBMU | UK00BN | 2024-11-21T14:16:47.312Z | 2024-11-22T14:21:23.625Z |
5563774 | 5563774 | 20241120020330_RMCuk | UK00BN | 2024-11-21T14:16:43.021Z | 2024-11-22T14:21:22.376Z |
5563763 | 5563763 | 20241120020256_KS2hF | UK00BN | 2024-11-21T14:16:41.866Z | 2024-11-22T14:21:22.271Z |
5563743 | 5563743 | 20241120020036_t0d4U | UK00BN | 2024-11-21T14:16:37.761Z | 2024-11-22T14:21:21.565Z |
5563655 | 5563655 | 20241120015512_PGPgi | UK00BN | 2024-11-21T14:16:31.715Z | 2024-11-22T14:21:20.324Z |
5563621 | 5563621 | 20241120015311_PueTR | UK00BN | 2024-11-21T14:16:29.767Z | 2024-11-22T14:21:20.148Z |
5563498 | 5563498 | 20241120013413_23rIe | UK00BN | 2024-11-21T14:16:11.006Z | 2024-11-22T14:21:16.785Z |
5563447 | 5563447 | 20241120013102_xXW1g | UK00BN | 2024-11-21T14:16:06.967Z | 2024-11-22T14:21:15.782Z |
5563435 | 5563435 | 20241120012944_m541u | UK00BN | 2024-11-21T14:16:06.396Z | 2024-11-22T14:21:15.557Z |
5563406 | 5563406 | 20241120012717_3L026 | UK00BN | 2024-11-21T14:16:02.870Z | 2024-11-22T14:21:14.979Z |
5563341 | 5563341 | 20241120011838_fKdwn | UK00BN | 2024-11-21T14:15:55.989Z | 2024-11-22T14:21:13.194Z |
5563330 | 5563330 | 20241120011705_nQ13M | UK00BN | 2024-11-21T14:15:54.572Z | 2024-11-22T14:21:13.101Z |
5563201 | 5563201 | 20241120010351_zx3Fn | UK00BN | 2024-11-21T14:15:40.250Z | 2024-11-22T14:21:10.672Z |
5563132 | 5563132 | 20241120005526_CAZr3 | UK00BN | 2024-11-21T14:15:37.681Z | 2024-11-22T14:21:09.902Z |
5563127 | 5563127 | 20241120005505_03M06 | UK00BN | 2024-11-21T14:15:37.548Z | 2024-11-22T14:21:09.898Z |
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);