participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "USL00G" 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 |
---|---|---|---|---|---|
5573254 | 5573254 | 20241121041630_1nbhw | USL00G | 2024-11-22T14:19:18.397Z | 2024-11-22T14:19:22.477Z |
5573169 | 5573169 | 20241121040146_U3Klz | USL00G | 2024-11-22T14:19:13.729Z | 2024-11-22T14:19:22.462Z |
5573087 | 5573087 | 20241121035011_8uhKN | USL00G | 2024-11-22T14:19:09.363Z | 2024-11-22T14:19:22.447Z |
5573063 | 5573063 | 20241121034654_Mt5Mb | USL00G | 2024-11-22T14:19:08.019Z | 2024-11-22T14:19:22.443Z |
5572903 | 5572903 | 20241121032348_plkJL | USL00G | 2024-11-22T14:18:57.882Z | 2024-11-22T14:19:22.411Z |
5572786 | 5572786 | 20241121030957_S9yhW | USL00G | 2024-11-22T14:18:49.463Z | 2024-11-22T14:19:22.391Z |
5572712 | 5572712 | 20241121030101_bZsqy | USL00G | 2024-11-22T14:18:45.169Z | 2024-11-22T14:19:22.378Z |
5572497 | 5572497 | 20241121022855_KeUC4 | USL00G | 2024-11-22T14:18:30.205Z | 2024-11-22T14:19:22.339Z |
5572485 | 5572485 | 20241121022730_7KKpm | USL00G | 2024-11-22T14:18:29.521Z | 2024-11-22T14:19:22.337Z |
5572146 | 5572146 | 20241121014102_Atjpg | USL00G | 2024-11-22T14:18:01.443Z | 2024-11-22T14:19:22.268Z |
5568391 | 5568391 | 20241121123827_x020p | USL00G | 2024-11-22T14:08:51.001Z | 2024-11-22T14:08:51.001Z |
5568299 | 5568299 | 20241121122042_rNu2p | USL00G | 2024-11-22T14:08:39.948Z | 2024-11-22T14:08:39.948Z |
5568279 | 5568279 | 20241121121714_kT6fP | USL00G | 2024-11-22T14:08:38.183Z | 2024-11-22T14:08:38.183Z |
5568149 | 5568149 | 20241121115552_HQKzr | USL00G | 2024-11-22T14:08:13.220Z | 2024-11-22T14:08:13.220Z |
5568033 | 5568033 | 20241121114230_Dn7LD | USL00G | 2024-11-22T14:07:58.669Z | 2024-11-22T14:07:58.669Z |
5567834 | 5567834 | 20241121111655_Wz4n0 | USL00G | 2024-11-22T14:07:21.756Z | 2024-11-22T14:07:21.756Z |
5567675 | 5567675 | 20241121105106_hgcba | USL00G | 2024-11-22T14:06:50.753Z | 2024-11-22T14:06:50.753Z |
5567541 | 5567541 | 20241121103315_hIjyG | USL00G | 2024-11-22T14:06:28.949Z | 2024-11-22T14:06:28.949Z |
5567536 | 5567536 | 20241121103222_6SynQ | USL00G | 2024-11-22T14:06:28.449Z | 2024-11-22T14:06:28.449Z |
5567496 | 5567496 | 20241121102843_WzvDV | USL00G | 2024-11-22T14:06:24.486Z | 2024-11-22T14:06:24.486Z |
5567448 | 5567448 | 20241121102044_bF79g | USL00G | 2024-11-22T14:06:18.090Z | 2024-11-22T14:06:18.090Z |
5567435 | 5567435 | 20241121101758_2BqXh | USL00G | 2024-11-22T14:06:16.381Z | 2024-11-22T14:06:16.381Z |
5567345 | 5567345 | 20241121100406_oH2UF | USL00G | 2024-11-22T14:05:57.032Z | 2024-11-22T14:05:57.032Z |
5567112 | 5567112 | 20241121092428_M1hOW | USL00G | 2024-11-22T14:05:22.187Z | 2024-11-22T14:05:22.187Z |
5567102 | 5567102 | 20241121092248_p9aT4 | USL00G | 2024-11-22T14:05:14.845Z | 2024-11-22T14:05:14.845Z |
5566989 | 5566989 | 20241121085359_xpoct | USL00G | 2024-11-22T14:04:49.696Z | 2024-11-22T14:04:49.696Z |
5566947 | 5566947 | 20241121084650_qBGyL | USL00G | 2024-11-22T14:04:41.693Z | 2024-11-22T14:04:41.693Z |
5566899 | 5566899 | 20241121082956_MwXke | USL00G | 2024-11-22T14:04:24.848Z | 2024-11-22T14:04:24.848Z |
5566862 | 5566862 | 20241121081925_9BGVW | USL00G | 2024-11-22T14:04:18.702Z | 2024-11-22T14:04:18.702Z |
5566855 | 5566855 | 20241121081702_MhLEm | USL00G | 2024-11-22T14:04:17.716Z | 2024-11-22T14:04:17.716Z |
5566760 | 5566760 | 20241121074055_E2036 | USL00G | 2024-11-22T14:03:52.696Z | 2024-11-22T14:03:52.696Z |
5566637 | 5566637 | 20241121070806_BzTZc | USL00G | 2024-11-22T14:03:31.203Z | 2024-11-22T14:03:31.203Z |
5566557 | 5566557 | 20241121063907_AH9X2 | USL00G | 2024-11-22T14:03:10.872Z | 2024-11-22T14:03:10.872Z |
5566537 | 5566537 | 20241121063126_MvH2K | USL00G | 2024-11-22T14:03:08.693Z | 2024-11-22T14:03:08.693Z |
5566514 | 5566514 | 20241121062632_kxdYM | USL00G | 2024-11-22T14:03:03.076Z | 2024-11-22T14:03:03.076Z |
5566501 | 5566501 | 20241121062429_yQOoc | USL00G | 2024-11-22T14:03:01.664Z | 2024-11-22T14:03:01.664Z |
5566394 | 5566394 | 20241121060639_t3L7a | USL00G | 2024-11-22T14:02:43.094Z | 2024-11-22T14:02:43.094Z |
5565644 | 5565644 | 20241121043053_5SUsM | USL00G | 2024-11-22T14:00:33.971Z | 2024-11-22T14:00:33.971Z |
5565513 | 5565513 | 20241121041830_BXG2W | USL00G | 2024-11-22T14:00:09.222Z | 2024-11-22T14:00:09.222Z |
5563986 | 5563986 | 20241120022047_FW0pE | USL00G | 2024-11-21T14:17:02.569Z | 2024-11-22T14:21:26.013Z |
5563902 | 5563902 | 20241120021455_HxBnx | USL00G | 2024-11-21T14:16:56.569Z | 2024-11-22T14:21:24.904Z |
5563848 | 5563848 | 20241120021019_KcLV2 | USL00G | 2024-11-21T14:16:49.771Z | 2024-11-22T14:21:23.944Z |
5563798 | 5563798 | 20241120020437_yUFAA | USL00G | 2024-11-21T14:16:44.188Z | 2024-11-22T14:21:23.389Z |
5560530 | 5560530 | 20241120130751_1OH2R | USL00G | 2024-11-21T14:09:02.599Z | 2024-11-22T14:19:21.680Z |
5560467 | 5560467 | 20241120125421_qknQj | USL00G | 2024-11-21T14:08:55.061Z | 2024-11-22T14:19:21.665Z |
5560446 | 5560446 | 20241120125257_fzNn2 | USL00G | 2024-11-21T14:08:52.973Z | 2024-11-22T14:19:21.661Z |
5560258 | 5560258 | 20241120122645_boJ5b | USL00G | 2024-11-21T14:08:25.657Z | 2024-11-22T14:19:21.623Z |
5560211 | 5560211 | 20241120121829_tKoQK | USL00G | 2024-11-21T14:08:17.301Z | 2024-11-22T14:19:21.613Z |
5560175 | 5560175 | 20241120121338_selLI | USL00G | 2024-11-21T14:08:11.538Z | 2024-11-22T14:19:21.604Z |
5560159 | 5560159 | 20241120120910_GkZZu | USL00G | 2024-11-21T14:08:09.232Z | 2024-11-22T14:19:21.599Z |
5559937 | 5559937 | 20241120113604_AIPQO | USL00G | 2024-11-21T14:07:36.707Z | 2024-11-22T14:19:21.553Z |
5559296 | 5559296 | 20241120095736_0NUSb | USL00G | 2024-11-21T14:05:52.941Z | 2024-11-22T14:19:21.410Z |
5559288 | 5559288 | 20241120095601_ji3YY | USL00G | 2024-11-21T14:05:51.494Z | 2024-11-22T14:19:21.408Z |
5559220 | 5559220 | 20241120093956_UpMxN | USL00G | 2024-11-21T14:05:38.374Z | 2024-11-22T14:19:21.389Z |
5558631 | 5558631 | 20241120071137_FYU8C | USL00G | 2024-11-21T14:03:53.263Z | 2024-11-22T14:19:21.267Z |
5558588 | 5558588 | 20241120064653_utnB7 | USL00G | 2024-11-21T14:03:45.723Z | 2024-11-22T14:19:21.257Z |
5557263 | 5557263 | 20241120043159_2W0kR | USL00G | 2024-11-21T14:00:18.650Z | 2024-11-22T14:19:21.040Z |
5557150 | 5557150 | 20241119041148_9P3Hr | USL00G | 2024-11-20T14:12:22.407Z | 2024-11-22T14:22:22.547Z |
5557051 | 5557051 | 20241119033224_Jk06m | USL00G | 2024-11-20T14:12:04.717Z | 2024-11-22T14:22:21.937Z |
5555313 | 5555313 | 20241119123902_UY5Lm | USL00G | 2024-11-20T14:05:09.624Z | 2024-11-22T14:20:03.642Z |
5555267 | 5555267 | 20241119122646_bXKnF | USL00G | 2024-11-20T14:05:03.221Z | 2024-11-22T14:20:02.580Z |
5555244 | 5555244 | 20241119122203_Rx0eN | USL00G | 2024-11-20T14:05:00.315Z | 2024-11-22T14:20:02.291Z |
5555192 | 5555192 | 20241119120752_PjmeW | USL00G | 2024-11-20T14:04:42.065Z | 2024-11-22T14:20:00.893Z |
5555053 | 5555053 | 20241119112754_WYJdP | USL00G | 2024-11-20T14:04:18.754Z | 2024-11-22T14:19:56.271Z |
5554922 | 5554922 | 20241119110416_8cjC2 | USL00G | 2024-11-20T14:03:48.777Z | 2024-11-22T14:19:54.035Z |
5554736 | 5554736 | 20241119102007_vChC7 | USL00G | 2024-11-20T14:03:09.827Z | 2024-11-22T14:19:50.361Z |
5554729 | 5554729 | 20241119101936_oB7Fl | USL00G | 2024-11-20T14:03:08.427Z | 2024-11-22T14:19:50.117Z |
5554664 | 5554664 | 20241119100207_2HqqY | USL00G | 2024-11-20T14:02:58.284Z | 2024-11-22T14:19:48.563Z |
5554601 | 5554601 | 20241119094657_F6OEw | USL00G | 2024-11-20T14:02:36.486Z | 2024-11-22T14:19:45.197Z |
5554588 | 5554588 | 20241119094243_HySlS | USL00G | 2024-11-20T14:02:33.267Z | 2024-11-22T14:19:44.588Z |
5554432 | 5554432 | 20241119085855_bWZ4Z | USL00G | 2024-11-20T14:02:02.613Z | 2024-11-22T14:19:40.618Z |
5554403 | 5554403 | 20241119084603_TDjo2 | USL00G | 2024-11-20T14:01:55.709Z | 2024-11-22T14:19:39.902Z |
5554380 | 5554380 | 20241119083756_KU49f | USL00G | 2024-11-20T14:01:49.295Z | 2024-11-22T14:19:38.836Z |
5554356 | 5554356 | 20241119082430_5HJJ1 | USL00G | 2024-11-20T14:01:45.147Z | 2024-11-22T14:19:38.300Z |
5554259 | 5554259 | 20241119073153_5m5yg | USL00G | 2024-11-20T14:01:15.746Z | 2024-11-22T14:19:34.391Z |
5554100 | 5554100 | 20241119060819_6wgcf | USL00G | 2024-11-20T14:00:44.216Z | 2024-11-22T14:19:29.685Z |
5553895 | 5553895 | 20241118044357_VuzYk | USL00G | 2024-11-19T14:11:32.392Z | 2024-11-22T14:22:57.150Z |
5553877 | 5553877 | 20241118043816_k84lx | USL00G | 2024-11-19T14:11:30.880Z | 2024-11-22T14:22:56.647Z |
5553856 | 5553856 | 20241118043329_snQsR | USL00G | 2024-11-19T14:11:30.258Z | 2024-11-22T14:22:56.571Z |
5553779 | 5553779 | 20241118041443_qiJ2R | USL00G | 2024-11-19T14:11:26.156Z | 2024-11-22T14:22:56.156Z |
5553227 | 5553227 | 20241118014428_Nmkf5 | USL00G | 2024-11-19T14:10:10.877Z | 2024-11-22T14:22:51.232Z |
5551016 | 5551016 | 20241118120914_i2H4u | USL00G | 2024-11-19T14:03:46.779Z | 2024-11-22T14:22:07.646Z |
5550575 | 5550575 | 20241118105025_qVIzt | USL00G | 2024-11-19T14:02:39.141Z | 2024-11-22T14:22:04.033Z |
5550258 | 5550258 | 20241118095449_deNf1 | USL00G | 2024-11-19T14:01:59.186Z | 2024-11-22T14:22:00.531Z |
5550230 | 5550230 | 20241118095003_HBDfQ | USL00G | 2024-11-19T14:01:51.340Z | 2024-11-22T14:22:00.076Z |
5550200 | 5550200 | 20241118094614_uvUgn | USL00G | 2024-11-19T14:01:45.199Z | 2024-11-22T14:21:59.611Z |
5550128 | 5550128 | 20241118093511_e8UO5 | USL00G | 2024-11-19T14:01:36.657Z | 2024-11-22T14:21:58.703Z |
5550034 | 5550034 | 20241118091459_VdO7v | USL00G | 2024-11-19T14:01:28.671Z | 2024-11-22T14:21:57.046Z |
5549987 | 5549987 | 20241118090206_e1ERQ | USL00G | 2024-11-19T14:01:24.577Z | 2024-11-22T14:21:56.412Z |
5549838 | 5549838 | 20241118075334_eEonI | USL00G | 2024-11-19T14:00:58.351Z | 2024-11-22T14:21:53.912Z |
5549827 | 5549827 | 20241118073015_hw2E5 | USL00G | 2024-11-19T14:00:57.189Z | 2024-11-22T14:21:53.855Z |
5549794 | 5549794 | 20241118064532_z6hni | USL00G | 2024-11-19T14:00:52.062Z | 2024-11-22T14:21:53.041Z |
5549707 | 5549707 | 20241118060541_mUmYD | USL00G | 2024-11-19T14:00:38.099Z | 2024-11-22T14:21:51.456Z |
5548916 | 5548916 | 20241117021433_16Frn | USL00G | 2024-11-18T14:10:26.093Z | 2024-11-22T14:23:16.824Z |
5546850 | 5546850 | 20241117130222_3bvLi | USL00G | 2024-11-18T14:04:21.283Z | 2024-11-22T14:22:35.003Z |
5546807 | 5546807 | 20241117124839_AEip6 | USL00G | 2024-11-18T14:04:16.088Z | 2024-11-22T14:22:34.726Z |
5546762 | 5546762 | 20241117123807_0M4iR | USL00G | 2024-11-18T14:04:11.542Z | 2024-11-22T14:22:34.526Z |
5546752 | 5546752 | 20241117123547_A9g7r | USL00G | 2024-11-18T14:04:09.910Z | 2024-11-22T14:22:34.428Z |
5546719 | 5546719 | 20241117122805_2IBoP | USL00G | 2024-11-18T14:03:55.733Z | 2024-11-22T14:22:34.141Z |
5546694 | 5546694 | 20241117121705_XSxO8 | USL00G | 2024-11-18T14:03:51.911Z | 2024-11-22T14:22:33.941Z |
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);