participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,533 rows where station_code = "UK008Z" 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 |
---|---|---|---|---|---|
5571260 | 5571260 | 20241120230842_qNyJT | UK008Z | 2024-11-22T14:16:45.113Z | 2024-11-22T14:19:22.081Z |
5571258 | 5571258 | 20241120230835_kXvco | UK008Z | 2024-11-22T14:16:44.450Z | 2024-11-22T14:19:22.080Z |
5570730 | 5570730 | 20241120204731_31a2z | UK008Z | 2024-11-22T14:16:02.506Z | 2024-11-22T14:19:21.970Z |
5570689 | 5570689 | 20241120204336_A9KKY | UK008Z | 2024-11-22T14:16:00.965Z | 2024-11-22T14:19:21.964Z |
5570455 | 5570455 | 20241120194151_vRrRX | UK008Z | 2024-11-22T14:15:28.531Z | 2024-11-22T14:19:21.920Z |
5570314 | 5570314 | 20241120191833_h3p83 | UK008Z | 2024-11-22T14:15:08.303Z | 2024-11-22T14:19:21.896Z |
5570304 | 5570304 | 20241120191436_UXP33 | UK008Z | 2024-11-22T14:15:06.879Z | 2024-11-22T14:19:21.895Z |
5570231 | 5570231 | 20241120190712_EgvNG | UK008Z | 2024-11-22T14:15:03.083Z | 2024-11-22T14:19:21.884Z |
5569965 | 5569965 | 20241120181252_wgUEs | UK008Z | 2024-11-22T14:14:41.383Z | 2024-11-22T14:19:21.839Z |
5569828 | 5569828 | 20241120174053_GVuAj | UK008Z | 2024-11-22T14:14:19.051Z | 2024-11-22T14:19:21.813Z |
5565176 | 5565176 | 20241120040001_TCqiU | UK008Z | 2024-11-21T14:18:38.710Z | 2024-11-22T14:21:43.349Z |
5565048 | 5565048 | 20241120034550_0jLfJ | UK008Z | 2024-11-21T14:18:23.852Z | 2024-11-22T14:21:40.522Z |
5564966 | 5564966 | 20241120034319_g8Mpt | UK008Z | 2024-11-21T14:18:16.915Z | 2024-11-22T14:21:39.823Z |
5564874 | 5564874 | 20241120033422_EfZ2s | UK008Z | 2024-11-21T14:18:11.104Z | 2024-11-22T14:21:37.590Z |
5564729 | 5564729 | 20241120032248_oaWEQ | UK008Z | 2024-11-21T14:17:59.949Z | 2024-11-22T14:21:35.969Z |
5564585 | 5564585 | 20241120031110_K2FlQ | UK008Z | 2024-11-21T14:17:51.453Z | 2024-11-22T14:21:33.749Z |
5564342 | 5564342 | 20241120024857_Ikkgk | UK008Z | 2024-11-21T14:17:27.919Z | 2024-11-22T14:21:30.543Z |
5563851 | 5563851 | 20241120021030_7rI0O | UK008Z | 2024-11-21T14:16:50.529Z | 2024-11-22T14:21:23.951Z |
5563801 | 5563801 | 20241120020533_UvS0M | UK008Z | 2024-11-21T14:16:44.310Z | 2024-11-22T14:21:23.411Z |
5563711 | 5563711 | 20241120015854_QQUUo | UK008Z | 2024-11-21T14:16:35.482Z | 2024-11-22T14:21:21.264Z |
5563508 | 5563508 | 20241120013633_emzfm | UK008Z | 2024-11-21T14:16:12.957Z | 2024-11-22T14:21:17.013Z |
5563053 | 5563053 | 20241120004522_Wk2Sg | UK008Z | 2024-11-21T14:15:33.648Z | 2024-11-22T14:21:08.839Z |
5562958 | 5562958 | 20241120003444_63lcx | UK008Z | 2024-11-21T14:15:30.142Z | 2024-11-22T14:21:06.999Z |
5562918 | 5562918 | 20241120002719_KY207 | UK008Z | 2024-11-21T14:15:27.456Z | 2024-11-22T14:21:06.094Z |
5562900 | 5562900 | 20241120002604_cHhCR | UK008Z | 2024-11-21T14:15:26.758Z | 2024-11-22T14:21:05.918Z |
5561922 | 5561922 | 20241119222907_8lLq2 | UK008Z | 2024-11-21T14:14:14.267Z | 2024-11-22T14:20:49.539Z |
5561846 | 5561846 | 20241119221720_fzxhe | UK008Z | 2024-11-21T14:14:09.786Z | 2024-11-22T14:20:47.693Z |
5558313 | 5558313 | 20241120055510_xP2up | UK008Z | 2024-11-21T14:03:00.222Z | 2024-11-22T14:19:21.209Z |
5558295 | 5558295 | 20241120055230_KurMu | UK008Z | 2024-11-21T14:02:57.378Z | 2024-11-22T14:19:21.206Z |
5558040 | 5558040 | 20241120053312_7tY71 | UK008Z | 2024-11-21T14:02:22.035Z | 2024-11-22T14:19:21.167Z |
5558010 | 5558010 | 20241120053132_9OUiu | UK008Z | 2024-11-21T14:02:17.739Z | 2024-11-22T14:19:21.162Z |
5558002 | 5558002 | 20241120053011_aq0rH | UK008Z | 2024-11-21T14:02:15.424Z | 2024-11-22T14:19:21.160Z |
5557952 | 5557952 | 20241120052520_4ibXp | UK008Z | 2024-11-21T14:02:08.173Z | 2024-11-22T14:19:21.151Z |
5557919 | 5557919 | 20241120052321_bISGd | UK008Z | 2024-11-21T14:02:03.422Z | 2024-11-22T14:19:21.146Z |
5557672 | 5557672 | 20241120050434_anSjM | UK008Z | 2024-11-21T14:01:28.394Z | 2024-11-22T14:19:21.108Z |
5557604 | 5557604 | 20241120050042_Ay2hF | UK008Z | 2024-11-21T14:01:21.449Z | 2024-11-22T14:19:21.099Z |
5557563 | 5557563 | 20241120045728_5Pvs1 | UK008Z | 2024-11-21T14:01:11.370Z | 2024-11-22T14:19:21.091Z |
5557360 | 5557360 | 20241120044040_s1rMx | UK008Z | 2024-11-21T14:00:36.422Z | 2024-11-22T14:19:21.057Z |
5529923 | 5529923 | 20241112012243_mZeto | UK008Z | 2024-11-13T14:13:23.710Z | 2024-11-20T14:25:51.036Z |
5529806 | 5529806 | 20241112010552_JN3Ab | UK008Z | 2024-11-13T14:13:12.372Z | 2024-11-20T14:25:48.449Z |
5529274 | 5529274 | 20241111235706_FM2mS | UK008Z | 2024-11-13T14:12:18.372Z | 2024-11-20T14:25:42.510Z |
5528457 | 5528457 | 20241111205808_jScNt | UK008Z | 2024-11-13T14:10:43.156Z | 2024-11-20T14:25:30.802Z |
5528201 | 5528201 | 20241111195316_1sy1m | UK008Z | 2024-11-13T14:10:14.919Z | 2024-11-20T14:25:26.535Z |
5527832 | 5527832 | 20241111184101_2Xtn8 | UK008Z | 2024-11-13T14:09:24.304Z | 2024-11-20T14:25:21.926Z |
5527672 | 5527672 | 20241111180652_LpY71 | UK008Z | 2024-11-13T14:08:53.174Z | 2024-11-20T14:25:17.409Z |
5524152 | 5524152 | 20241111032011_rE32B | UK008Z | 2024-11-12T14:16:37.995Z | 2024-11-19T14:22:17.594Z |
5524143 | 5524143 | 20241111031930_0yTzc | UK008Z | 2024-11-12T14:16:36.212Z | 2024-11-19T14:22:17.546Z |
5454075 | 5454075 | 20241031033955_aVdUJ | UK008Z | 2024-11-02T12:22:50.161Z | 2024-11-08T14:23:20.305Z |
5454031 | 5454031 | 20241031033303_zTspj | UK008Z | 2024-11-02T12:22:48.965Z | 2024-11-08T14:23:20.055Z |
5451681 | 5451681 | 20241101004510_NJfFw | UK008Z | 2024-11-02T12:17:49.663Z | 2024-11-09T14:24:24.970Z |
5451070 | 5451070 | 20241031223233_Xq4j0 | UK008Z | 2024-11-02T12:16:33.799Z | 2024-11-09T14:24:21.352Z |
5450758 | 5450758 | 20241031205031_gRTLz | UK008Z | 2024-11-02T12:15:50.908Z | 2024-11-09T14:24:17.838Z |
5450033 | 5450033 | 20241031173926_dGBpS | UK008Z | 2024-11-02T12:14:10.923Z | 2024-11-09T14:24:13.370Z |
5422992 | 5422992 | 20241027014118_O5AmZ | UK008Z | 2024-10-30T12:22:39.753Z | 2024-11-04T14:28:55.773Z |
5418773 | 5418773 | 20241027215459_4uyx4 | UK008Z | 2024-10-30T12:16:09.346Z | 2024-11-05T14:27:11.144Z |
5418759 | 5418759 | 20241027215303_h2J2B | UK008Z | 2024-10-30T12:16:07.922Z | 2024-11-05T14:27:11.103Z |
5410143 | 5410143 | 20241027045526_BQ6Hg | UK008Z | 2024-10-29T12:17:48.871Z | 2024-11-04T14:29:03.885Z |
5410135 | 5410135 | 20241027045515_aAX2y | UK008Z | 2024-10-29T12:17:48.559Z | 2024-11-04T14:29:03.870Z |
5409470 | 5409470 | 20241027041941_r3FCy | UK008Z | 2024-10-29T12:17:25.250Z | 2024-11-04T14:29:01.835Z |
5408444 | 5408444 | 20241027032714_qyRNA | UK008Z | 2024-10-29T12:16:29.653Z | 2024-11-04T14:28:59.408Z |
5408437 | 5408437 | 20241027032703_wAzT2 | UK008Z | 2024-10-29T12:16:29.472Z | 2024-11-04T14:28:59.405Z |
5408225 | 5408225 | 20241027031714_m04iw | UK008Z | 2024-10-29T12:16:17.952Z | 2024-11-04T14:28:59.010Z |
5407448 | 5407448 | 20241027023705_f6jLH | UK008Z | 2024-10-29T12:15:24.945Z | 2024-11-04T14:28:57.582Z |
5407225 | 5407225 | 20241027022652_ycZun | UK008Z | 2024-10-29T12:15:17.835Z | 2024-11-04T14:28:57.252Z |
5407147 | 5407147 | 20241027022401_ZXtfd | UK008Z | 2024-10-29T12:15:14.780Z | 2024-11-04T14:28:57.106Z |
5407090 | 5407090 | 20241027022148_6zXmV | UK008Z | 2024-10-29T12:15:12.001Z | 2024-11-04T14:28:56.842Z |
5406845 | 5406845 | 20241027020329_OCJ0I | UK008Z | 2024-10-29T12:14:49.454Z | 2024-11-04T14:28:56.509Z |
5406540 | 5406540 | 20241027014252_swiOo | UK008Z | 2024-10-29T12:14:18.548Z | 2024-11-04T14:28:55.842Z |
5405789 | 5405789 | 20241027005815_YoI2P | UK008Z | 2024-10-29T12:13:17.657Z | 2024-11-04T14:28:54.245Z |
5405185 | 5405185 | 20241027002058_8IYXN | UK008Z | 2024-10-29T12:12:39.932Z | 2024-11-04T14:28:52.762Z |
5404830 | 5404830 | 20241026235503_CWsjM | UK008Z | 2024-10-29T12:12:00.240Z | 2024-11-04T14:28:52.170Z |
5404527 | 5404527 | 20241026233423_43tt7 | UK008Z | 2024-10-29T12:11:40.873Z | 2024-11-04T14:28:51.294Z |
5403951 | 5403951 | 20241026224815_POq5j | UK008Z | 2024-10-29T12:10:36.195Z | 2024-11-04T14:28:50.071Z |
5403866 | 5403866 | 20241026224015_yrRpu | UK008Z | 2024-10-29T12:10:22.823Z | 2024-11-04T14:28:49.894Z |
5403150 | 5403150 | 20241026212355_WraZH | UK008Z | 2024-10-29T12:09:06.268Z | 2024-11-04T14:28:47.868Z |
5399502 | 5399502 | 20241026042902_PL2t4 | UK008Z | 2024-10-28T12:20:01.173Z | 2024-11-03T14:27:39.878Z |
5395478 | 5395478 | 20241025224544_spQGa | UK008Z | 2024-10-28T12:16:18.556Z | 2024-11-03T14:27:25.615Z |
5394852 | 5394852 | 20241025213424_LgrI0 | UK008Z | 2024-10-28T12:15:32.548Z | 2024-11-03T14:27:22.902Z |
5394605 | 5394605 | 20241025205638_ARALt | UK008Z | 2024-10-28T12:15:04.083Z | 2024-11-03T14:27:21.858Z |
5385514 | 5385514 | 20241024225552_yzjFF | UK008Z | 2024-10-27T12:19:00.872Z | 2024-11-02T12:28:29.890Z |
5385454 | 5385454 | 20241024224736_qp2ua | UK008Z | 2024-10-27T12:18:56.994Z | 2024-11-02T12:28:29.846Z |
5385140 | 5385140 | 20241024215630_6xG5Q | UK008Z | 2024-10-27T12:18:28.271Z | 2024-11-02T12:28:29.206Z |
5385076 | 5385076 | 20241024214738_4LkN2 | UK008Z | 2024-10-27T12:18:19.922Z | 2024-11-02T12:28:29.037Z |
5383507 | 5383507 | 20241024182659_E8IQ5 | UK008Z | 2024-10-27T12:15:37.742Z | 2024-11-02T12:28:25.687Z |
5377254 | 5377254 | 20241024044136_Q1f4S | UK008Z | 2024-10-26T12:22:32.092Z | 2024-11-01T12:27:02.338Z |
5377133 | 5377133 | 20241024043446_836up | UK008Z | 2024-10-26T12:22:27.830Z | 2024-11-01T12:27:02.206Z |
5376860 | 5376860 | 20241024041943_Opfto | UK008Z | 2024-10-26T12:22:15.016Z | 2024-11-01T12:27:01.900Z |
5376604 | 5376604 | 20241024040413_7iJTp | UK008Z | 2024-10-26T12:22:06.038Z | 2024-11-01T12:27:01.615Z |
5376478 | 5376478 | 20241024035710_r837A | UK008Z | 2024-10-26T12:22:02.893Z | 2024-11-01T12:27:01.567Z |
5376391 | 5376391 | 20241024035317_RM1us | UK008Z | 2024-10-26T12:22:00.248Z | 2024-11-01T12:27:01.521Z |
5375836 | 5375836 | 20241024033227_oXfbx | UK008Z | 2024-10-26T12:21:41.470Z | 2024-11-01T12:27:01.217Z |
5375593 | 5375593 | 20241024032058_rcN78 | UK008Z | 2024-10-26T12:21:32.575Z | 2024-11-01T12:27:01.102Z |
5375094 | 5375094 | 20241024025719_AhrcU | UK008Z | 2024-10-26T12:21:12.682Z | 2024-11-01T12:27:00.285Z |
5374969 | 5374969 | 20241024025113_J1y2I | UK008Z | 2024-10-26T12:21:08.538Z | 2024-11-01T12:27:00.073Z |
5373296 | 5373296 | 20241024013211_1eNlx | UK008Z | 2024-10-26T12:20:04.636Z | 2024-11-01T12:26:58.213Z |
5373200 | 5373200 | 20241024012739_mDsVN | UK008Z | 2024-10-26T12:20:01.690Z | 2024-11-01T12:26:58.163Z |
5372336 | 5372336 | 20241024004442_YrCCd | UK008Z | 2024-10-26T12:19:20.999Z | 2024-11-01T12:26:57.406Z |
5372149 | 5372149 | 20241024003525_8q2qL | UK008Z | 2024-10-26T12:19:11.368Z | 2024-11-01T12:26:57.162Z |
5371906 | 5371906 | 20241024002232_UR2dy | UK008Z | 2024-10-26T12:18:56.339Z | 2024-11-01T12:26:56.986Z |
5366203 | 5366203 | 20241024000917_JrCzY | UK008Z | 2024-10-25T12:18:19.175Z | 2024-11-01T12:26:56.794Z |
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);