participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "BG0003" 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 |
---|---|---|---|---|---|
5565208 | 5565208 | 20241120040401_3FJ7C | BG0003 | 2024-11-21T14:18:41.085Z | 2024-11-22T14:21:43.928Z |
5565125 | 5565125 | 20241120035419_4rCc1 | BG0003 | 2024-11-21T14:18:32.786Z | 2024-11-22T14:21:42.028Z |
5565068 | 5565068 | 20241120034921_hK42O | BG0003 | 2024-11-21T14:18:27.854Z | 2024-11-22T14:21:40.876Z |
5563924 | 5563924 | 20241120021552_a1c8D | BG0003 | 2024-11-21T14:16:59.098Z | 2024-11-22T14:21:25.501Z |
5561183 | 5561183 | 20241119185407_UbX9V | BG0003 | 2024-11-21T14:12:34.063Z | 2024-11-22T14:20:24.768Z |
5561061 | 5561061 | 20241119174144_nlvyG | BG0003 | 2024-11-21T14:12:17.152Z | 2024-11-22T14:20:17.544Z |
5557154 | 5557154 | 20241119041214_3OmW2 | BG0003 | 2024-11-20T14:12:22.948Z | 2024-11-22T14:22:22.595Z |
5557120 | 5557120 | 20241119040144_C5f20 | BG0003 | 2024-11-20T14:12:19.573Z | 2024-11-22T14:22:22.363Z |
5557083 | 5557083 | 20241119034835_lvUb5 | BG0003 | 2024-11-20T14:12:14.123Z | 2024-11-22T14:22:22.120Z |
5557063 | 5557063 | 20241119034142_jOK9y | BG0003 | 2024-11-20T14:12:08.725Z | 2024-11-22T14:22:21.998Z |
5557040 | 5557040 | 20241119033053_n83nl | BG0003 | 2024-11-20T14:12:03.755Z | 2024-11-22T14:22:21.886Z |
5557032 | 5557032 | 20241119033005_p5eUP | BG0003 | 2024-11-20T14:12:03.010Z | 2024-11-22T14:22:21.824Z |
5557013 | 5557013 | 20241119032309_CSmWN | BG0003 | 2024-11-20T14:12:00.111Z | 2024-11-22T14:22:21.689Z |
5557007 | 5557007 | 20241119032134_pyDXn | BG0003 | 2024-11-20T14:11:58.853Z | 2024-11-22T14:22:21.634Z |
5556981 | 5556981 | 20241119031604_XaPfO | BG0003 | 2024-11-20T14:11:54.173Z | 2024-11-22T14:22:21.445Z |
5556939 | 5556939 | 20241119025809_owinR | BG0003 | 2024-11-20T14:11:43.404Z | 2024-11-22T14:22:21.078Z |
5556926 | 5556926 | 20241119025559_M2Fft | BG0003 | 2024-11-20T14:11:41.906Z | 2024-11-22T14:22:20.869Z |
5556903 | 5556903 | 20241119024501_ZMT6d | BG0003 | 2024-11-20T14:11:40.146Z | 2024-11-22T14:22:20.779Z |
5556896 | 5556896 | 20241119024111_GeLwv | BG0003 | 2024-11-20T14:11:38.453Z | 2024-11-22T14:22:20.699Z |
5556884 | 5556884 | 20241119023639_s4pcV | BG0003 | 2024-11-20T14:11:37.180Z | 2024-11-22T14:22:20.635Z |
5556873 | 5556873 | 20241119022514_A51kL | BG0003 | 2024-11-20T14:11:36.074Z | 2024-11-22T14:22:20.525Z |
5556848 | 5556848 | 20241119021806_MPYar | BG0003 | 2024-11-20T14:11:33.923Z | 2024-11-22T14:22:20.377Z |
5556805 | 5556805 | 20241119015912_9FmIV | BG0003 | 2024-11-20T14:11:30.185Z | 2024-11-22T14:22:20.108Z |
5556768 | 5556768 | 20241119014625_eru3b | BG0003 | 2024-11-20T14:11:26.594Z | 2024-11-22T14:22:19.815Z |
5556758 | 5556758 | 20241119014541_IjaET | BG0003 | 2024-11-20T14:11:25.915Z | 2024-11-22T14:22:19.755Z |
5556747 | 5556747 | 20241119014221_wEDY7 | BG0003 | 2024-11-20T14:11:25.012Z | 2024-11-22T14:22:19.671Z |
5556708 | 5556708 | 20241119012411_atfSk | BG0003 | 2024-11-20T14:11:20.582Z | 2024-11-22T14:22:19.368Z |
5556668 | 5556668 | 20241119005532_LYNtR | BG0003 | 2024-11-20T14:11:08.869Z | 2024-11-22T14:22:19.200Z |
5556651 | 5556651 | 20241119004649_OTPD5 | BG0003 | 2024-11-20T14:11:04.270Z | 2024-11-22T14:22:19.058Z |
5556627 | 5556627 | 20241119002221_6vVwg | BG0003 | 2024-11-20T14:10:57.459Z | 2024-11-22T14:22:18.862Z |
5556620 | 5556620 | 20241119002029_jeb5X | BG0003 | 2024-11-20T14:10:55.098Z | 2024-11-22T14:22:18.808Z |
5556591 | 5556591 | 20241118234755_3ryku | BG0003 | 2024-11-20T14:10:48.216Z | 2024-11-22T14:22:18.595Z |
5556585 | 5556585 | 20241118234420_UJ6Ds | BG0003 | 2024-11-20T14:10:47.578Z | 2024-11-22T14:22:18.568Z |
5556549 | 5556549 | 20241118232144_OgOzK | BG0003 | 2024-11-20T14:10:42.476Z | 2024-11-22T14:22:18.181Z |
5556534 | 5556534 | 20241118231314_bz5n9 | BG0003 | 2024-11-20T14:10:41.490Z | 2024-11-22T14:22:18.145Z |
5556523 | 5556523 | 20241118225723_vj1P2 | BG0003 | 2024-11-20T14:10:40.610Z | 2024-11-22T14:22:18.097Z |
5556511 | 5556511 | 20241118224614_dyILA | BG0003 | 2024-11-20T14:10:39.070Z | 2024-11-22T14:22:17.933Z |
5556506 | 5556506 | 20241118224549_mF5pN | BG0003 | 2024-11-20T14:10:38.699Z | 2024-11-22T14:22:17.927Z |
5556499 | 5556499 | 20241118223318_jJIoU | BG0003 | 2024-11-20T14:10:37.546Z | 2024-11-22T14:22:17.817Z |
5556496 | 5556496 | 20241118222658_nQr2E | BG0003 | 2024-11-20T14:10:37.392Z | 2024-11-22T14:22:17.796Z |
5556490 | 5556490 | 20241118222105_fg5m7 | BG0003 | 2024-11-20T14:10:36.754Z | 2024-11-22T14:22:17.739Z |
5556453 | 5556453 | 20241118215647_23bDf | BG0003 | 2024-11-20T14:10:33.060Z | 2024-11-22T14:22:17.468Z |
5556419 | 5556419 | 20241118212011_l2792 | BG0003 | 2024-11-20T14:10:28.196Z | 2024-11-22T14:22:17.310Z |
5556404 | 5556404 | 20241118210239_dApIm | BG0003 | 2024-11-20T14:10:25.781Z | 2024-11-22T14:22:17.132Z |
5556391 | 5556391 | 20241118204831_NDzgI | BG0003 | 2024-11-20T14:10:23.685Z | 2024-11-22T14:22:16.940Z |
5556387 | 5556387 | 20241118203946_Bprth | BG0003 | 2024-11-20T14:10:22.766Z | 2024-11-22T14:22:16.837Z |
5556380 | 5556380 | 20241118202647_YAfqu | BG0003 | 2024-11-20T14:10:20.004Z | 2024-11-22T14:22:16.735Z |
5556356 | 5556356 | 20241118194003_IewT9 | BG0003 | 2024-11-20T14:10:03.375Z | 2024-11-22T14:22:16.079Z |
5556325 | 5556325 | 20241118185117_3t9D2 | BG0003 | 2024-11-20T14:09:56.699Z | 2024-11-22T14:22:15.444Z |
5556288 | 5556288 | 20241118174904_jbL60 | BG0003 | 2024-11-20T14:09:47.419Z | 2024-11-22T14:22:14.572Z |
5556253 | 5556253 | 20241118164856_a4dZD | BG0003 | 2024-11-20T14:09:39.322Z | 2024-11-22T14:22:13.490Z |
5553776 | 5553776 | 20241118041440_ajNoA | BG0003 | 2024-11-19T14:11:25.977Z | 2024-11-22T14:22:56.139Z |
5553703 | 5553703 | 20241118035416_WiGOA | BG0003 | 2024-11-19T14:11:18.433Z | 2024-11-22T14:22:55.432Z |
5553628 | 5553628 | 20241118033701_usFn2 | BG0003 | 2024-11-19T14:11:06.281Z | 2024-11-22T14:22:54.895Z |
5553569 | 5553569 | 20241118032139_tjVp6 | BG0003 | 2024-11-19T14:10:55.445Z | 2024-11-22T14:22:54.328Z |
5553544 | 5553544 | 20241118031448_dwksT | BG0003 | 2024-11-19T14:10:49.070Z | 2024-11-22T14:22:54.097Z |
5553517 | 5553517 | 20241118030538_ht5q9 | BG0003 | 2024-11-19T14:10:45.493Z | 2024-11-22T14:22:53.941Z |
5553438 | 5553438 | 20241118023818_A5gyH | BG0003 | 2024-11-19T14:10:35.134Z | 2024-11-22T14:22:53.273Z |
5553380 | 5553380 | 20241118021613_2BP4M | BG0003 | 2024-11-19T14:10:25.845Z | 2024-11-22T14:22:52.534Z |
5553337 | 5553337 | 20241118020711_Zae3R | BG0003 | 2024-11-19T14:10:20.229Z | 2024-11-22T14:22:52.361Z |
5553297 | 5553297 | 20241118020007_tN2N1 | BG0003 | 2024-11-19T14:10:15.460Z | 2024-11-22T14:22:51.755Z |
5553246 | 5553246 | 20241118014706_KEdnR | BG0003 | 2024-11-19T14:10:12.337Z | 2024-11-22T14:22:51.428Z |
5553172 | 5553172 | 20241118011800_8J36L | BG0003 | 2024-11-19T14:10:07.842Z | 2024-11-22T14:22:50.950Z |
5553164 | 5553164 | 20241118011201_njNcb | BG0003 | 2024-11-19T14:10:07.331Z | 2024-11-22T14:22:50.934Z |
5553160 | 5553160 | 20241118011042_3VZDh | BG0003 | 2024-11-19T14:10:07.089Z | 2024-11-22T14:22:50.890Z |
5553122 | 5553122 | 20241118005422_VsRpy | BG0003 | 2024-11-19T14:10:04.689Z | 2024-11-22T14:22:50.698Z |
5553085 | 5553085 | 20241118003920_DTsAz | BG0003 | 2024-11-19T14:10:02.225Z | 2024-11-22T14:22:50.392Z |
5553068 | 5553068 | 20241118003621_SubgP | BG0003 | 2024-11-19T14:10:01.260Z | 2024-11-22T14:22:50.319Z |
5553043 | 5553043 | 20241118002841_8TuAd | BG0003 | 2024-11-19T14:09:58.891Z | 2024-11-22T14:22:49.992Z |
5553039 | 5553039 | 20241118002600_6siit | BG0003 | 2024-11-19T14:09:58.516Z | 2024-11-22T14:22:49.973Z |
5552980 | 5552980 | 20241117235357_D3kIN | BG0003 | 2024-11-19T14:09:54.686Z | 2024-11-22T14:22:49.676Z |
5552960 | 5552960 | 20241117234610_3jqYO | BG0003 | 2024-11-19T14:09:53.475Z | 2024-11-22T14:22:49.474Z |
5552954 | 5552954 | 20241117234058_7tOd9 | BG0003 | 2024-11-19T14:09:53.204Z | 2024-11-22T14:22:49.427Z |
5552952 | 5552952 | 20241117234010_WtzJb | BG0003 | 2024-11-19T14:09:53.042Z | 2024-11-22T14:22:49.406Z |
5552946 | 5552946 | 20241117233810_MflSP | BG0003 | 2024-11-19T14:09:52.569Z | 2024-11-22T14:22:49.398Z |
5552932 | 5552932 | 20241117232945_SQlBf | BG0003 | 2024-11-19T14:09:50.613Z | 2024-11-22T14:22:49.270Z |
5552792 | 5552792 | 20241117215814_n62xH | BG0003 | 2024-11-19T14:09:14.920Z | 2024-11-22T14:22:47.131Z |
5552768 | 5552768 | 20241117211736_hNU3G | BG0003 | 2024-11-19T14:09:09.302Z | 2024-11-22T14:22:46.530Z |
5552766 | 5552766 | 20241117211658_N4sik | BG0003 | 2024-11-19T14:09:09.081Z | 2024-11-22T14:22:46.516Z |
5552737 | 5552737 | 20241117210335_ynV7o | BG0003 | 2024-11-19T14:09:04.463Z | 2024-11-22T14:22:46.189Z |
5552726 | 5552726 | 20241117205111_d1JkQ | BG0003 | 2024-11-19T14:09:02.557Z | 2024-11-22T14:22:45.984Z |
5552722 | 5552722 | 20241117204703_qy8vE | BG0003 | 2024-11-19T14:09:02.061Z | 2024-11-22T14:22:45.946Z |
5552668 | 5552668 | 20241117195643_w3mGO | BG0003 | 2024-11-19T14:08:53.090Z | 2024-11-22T14:22:44.905Z |
5552601 | 5552601 | 20241117190929_QxC8n | BG0003 | 2024-11-19T14:08:44.562Z | 2024-11-22T14:22:42.734Z |
5552524 | 5552524 | 20241117181631_OuXnt | BG0003 | 2024-11-19T14:08:27.504Z | 2024-11-22T14:22:41.320Z |
5552512 | 5552512 | 20241117181106_6NHy7 | BG0003 | 2024-11-19T14:08:23.723Z | 2024-11-22T14:22:41.132Z |
5552498 | 5552498 | 20241117174501_ordLe | BG0003 | 2024-11-19T14:08:16.757Z | 2024-11-22T14:22:40.739Z |
5552476 | 5552476 | 20241117165719_4uTNG | BG0003 | 2024-11-19T14:08:07.063Z | 2024-11-22T14:22:40.114Z |
5552472 | 5552472 | 20241117164645_pHyZb | BG0003 | 2024-11-19T14:08:05.562Z | 2024-11-22T14:22:40.017Z |
5552456 | 5552456 | 20241117161257_DH3Tx | BG0003 | 2024-11-19T14:08:03.101Z | 2024-11-22T14:22:39.629Z |
5549176 | 5549176 | 20241117033720_ZGQZB | BG0003 | 2024-11-18T14:11:13.597Z | 2024-11-22T14:23:19.168Z |
5549149 | 5549149 | 20241117032752_KaErb | BG0003 | 2024-11-18T14:11:08.887Z | 2024-11-22T14:23:18.953Z |
5549071 | 5549071 | 20241117025809_JZRyj | BG0003 | 2024-11-18T14:10:49.090Z | 2024-11-22T14:23:17.784Z |
5549055 | 5549055 | 20241117025338_eTx4L | BG0003 | 2024-11-18T14:10:47.308Z | 2024-11-22T14:23:17.734Z |
5549034 | 5549034 | 20241117024613_PCzlW | BG0003 | 2024-11-18T14:10:44.378Z | 2024-11-22T14:23:17.644Z |
5549017 | 5549017 | 20241117024428_jnCyD | BG0003 | 2024-11-18T14:10:40.274Z | 2024-11-22T14:23:17.558Z |
5548994 | 5548994 | 20241117023853_f6MQZ | BG0003 | 2024-11-18T14:10:36.772Z | 2024-11-22T14:23:17.448Z |
5548988 | 5548988 | 20241117023514_A4s8I | BG0003 | 2024-11-18T14:10:35.745Z | 2024-11-22T14:23:17.425Z |
5548972 | 5548972 | 20241117023318_4e92C | BG0003 | 2024-11-18T14:10:34.287Z | 2024-11-22T14:23:17.366Z |
5548952 | 5548952 | 20241117022733_doSSb | BG0003 | 2024-11-18T14:10:32.450Z | 2024-11-22T14:23:17.272Z |
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);