participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "USL008" 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 |
---|---|---|---|---|---|
5573253 | 5573253 | 20241121041630_1nbhw | USL008 | 2024-11-22T14:19:18.397Z | 2024-11-22T14:19:22.477Z |
5573218 | 5573218 | 20241121040906_ZoEzs | USL008 | 2024-11-22T14:19:16.133Z | 2024-11-22T14:19:22.471Z |
5573180 | 5573180 | 20241121040432_lIPS2 | USL008 | 2024-11-22T14:19:14.547Z | 2024-11-22T14:19:22.464Z |
5573168 | 5573168 | 20241121040146_U3Klz | USL008 | 2024-11-22T14:19:13.729Z | 2024-11-22T14:19:22.462Z |
5573062 | 5573062 | 20241121034654_Mt5Mb | USL008 | 2024-11-22T14:19:08.018Z | 2024-11-22T14:19:22.443Z |
5572900 | 5572900 | 20241121032348_plkJL | USL008 | 2024-11-22T14:18:57.882Z | 2024-11-22T14:19:22.411Z |
5572710 | 5572710 | 20241121030101_bZsqy | USL008 | 2024-11-22T14:18:45.169Z | 2024-11-22T14:19:22.378Z |
5572484 | 5572484 | 20241121022730_7KKpm | USL008 | 2024-11-22T14:18:29.521Z | 2024-11-22T14:19:22.337Z |
5568554 | 5568554 | 20241121125836_F7tWO | USL008 | 2024-11-22T14:09:19.829Z | 2024-11-22T14:09:19.829Z |
5568432 | 5568432 | 20241121124815_0e2In | USL008 | 2024-11-22T14:08:57.184Z | 2024-11-22T14:08:57.184Z |
5568390 | 5568390 | 20241121123827_x020p | USL008 | 2024-11-22T14:08:51.001Z | 2024-11-22T14:08:51.001Z |
5567882 | 5567882 | 20241121112111_aUqoc | USL008 | 2024-11-22T14:07:29.356Z | 2024-11-22T14:07:29.356Z |
5567703 | 5567703 | 20241121105359_nLzw5 | USL008 | 2024-11-22T14:07:04.810Z | 2024-11-22T14:07:04.810Z |
5567672 | 5567672 | 20241121105106_hgcba | USL008 | 2024-11-22T14:06:50.753Z | 2024-11-22T14:06:50.753Z |
5567535 | 5567535 | 20241121103222_6SynQ | USL008 | 2024-11-22T14:06:28.449Z | 2024-11-22T14:06:28.449Z |
5567479 | 5567479 | 20241121102613_0NB2Q | USL008 | 2024-11-22T14:06:22.335Z | 2024-11-22T14:06:22.335Z |
5567434 | 5567434 | 20241121101758_2BqXh | USL008 | 2024-11-22T14:06:16.381Z | 2024-11-22T14:06:16.381Z |
5567412 | 5567412 | 20241121101414_bZm6E | USL008 | 2024-11-22T14:06:12.709Z | 2024-11-22T14:06:12.709Z |
5567327 | 5567327 | 20241121100255_Q41Uy | USL008 | 2024-11-22T14:05:53.438Z | 2024-11-22T14:05:53.438Z |
5567111 | 5567111 | 20241121092428_M1hOW | USL008 | 2024-11-22T14:05:22.187Z | 2024-11-22T14:05:22.187Z |
5567071 | 5567071 | 20241121090941_k5Yt3 | USL008 | 2024-11-22T14:05:03.245Z | 2024-11-22T14:05:03.245Z |
5566986 | 5566986 | 20241121085359_xpoct | USL008 | 2024-11-22T14:04:49.696Z | 2024-11-22T14:04:49.696Z |
5566945 | 5566945 | 20241121084650_qBGyL | USL008 | 2024-11-22T14:04:41.693Z | 2024-11-22T14:04:41.693Z |
5566937 | 5566937 | 20241121084515_4Gtd9 | USL008 | 2024-11-22T14:04:35.784Z | 2024-11-22T14:04:35.784Z |
5566898 | 5566898 | 20241121082956_MwXke | USL008 | 2024-11-22T14:04:24.848Z | 2024-11-22T14:04:24.848Z |
5566857 | 5566857 | 20241121081711_tKn9U | USL008 | 2024-11-22T14:04:18.096Z | 2024-11-22T14:04:18.096Z |
5566846 | 5566846 | 20241121081347_JZ6Rk | USL008 | 2024-11-22T14:04:16.498Z | 2024-11-22T14:04:16.498Z |
5566839 | 5566839 | 20241121080923_PTkuM | USL008 | 2024-11-22T14:04:14.625Z | 2024-11-22T14:04:14.625Z |
5566806 | 5566806 | 20241121075801_xXci2 | USL008 | 2024-11-22T14:04:08.899Z | 2024-11-22T14:04:08.899Z |
5566635 | 5566635 | 20241121070806_BzTZc | USL008 | 2024-11-22T14:03:31.203Z | 2024-11-22T14:03:31.203Z |
5566614 | 5566614 | 20241121070443_aJtMJ | USL008 | 2024-11-22T14:03:28.000Z | 2024-11-22T14:03:28.000Z |
5566500 | 5566500 | 20241121062429_yQOoc | USL008 | 2024-11-22T14:03:01.664Z | 2024-11-22T14:03:01.664Z |
5566409 | 5566409 | 20241121061034_V2CMl | USL008 | 2024-11-22T14:02:51.402Z | 2024-11-22T14:02:51.402Z |
5566391 | 5566391 | 20241121060639_t3L7a | USL008 | 2024-11-22T14:02:43.094Z | 2024-11-22T14:02:43.094Z |
5566241 | 5566241 | 20241121055235_z7zgQ | USL008 | 2024-11-22T14:02:17.398Z | 2024-11-22T14:02:17.398Z |
5565844 | 5565844 | 20241121045401_ue1D1 | USL008 | 2024-11-22T14:01:05.814Z | 2024-11-22T14:01:05.814Z |
5565830 | 5565830 | 20241121045157_3GB05 | USL008 | 2024-11-22T14:01:02.890Z | 2024-11-22T14:01:02.890Z |
5565771 | 5565771 | 20241121044358_3idQU | USL008 | 2024-11-22T14:00:54.548Z | 2024-11-22T14:00:54.548Z |
5565651 | 5565651 | 20241121043154_9mWaG | USL008 | 2024-11-22T14:00:35.839Z | 2024-11-22T14:00:35.839Z |
5565643 | 5565643 | 20241121043053_5SUsM | USL008 | 2024-11-22T14:00:33.971Z | 2024-11-22T14:00:33.971Z |
5565512 | 5565512 | 20241121041830_BXG2W | USL008 | 2024-11-22T14:00:09.200Z | 2024-11-22T14:00:09.200Z |
5565464 | 5565464 | 20241120042832_wscEX | USL008 | 2024-11-21T14:18:50.051Z | 2024-11-22T14:21:47.402Z |
5565202 | 5565202 | 20241120040300_HNVP2 | USL008 | 2024-11-21T14:18:40.515Z | 2024-11-22T14:21:43.776Z |
5564598 | 5564598 | 20241120031231_dkg38 | USL008 | 2024-11-21T14:17:52.398Z | 2024-11-22T14:21:33.960Z |
5564028 | 5564028 | 20241120022445_KrUQ4 | USL008 | 2024-11-21T14:17:05.453Z | 2024-11-22T14:21:26.598Z |
5563847 | 5563847 | 20241120021019_KcLV2 | USL008 | 2024-11-21T14:16:49.771Z | 2024-11-22T14:21:23.944Z |
5563796 | 5563796 | 20241120020437_yUFAA | USL008 | 2024-11-21T14:16:44.188Z | 2024-11-22T14:21:23.389Z |
5563507 | 5563507 | 20241120013510_NYqPw | USL008 | 2024-11-21T14:16:12.660Z | 2024-11-22T14:21:16.983Z |
5560466 | 5560466 | 20241120125421_qknQj | USL008 | 2024-11-21T14:08:55.061Z | 2024-11-22T14:19:21.665Z |
5560260 | 5560260 | 20241120122653_PQAgY | USL008 | 2024-11-21T14:08:26.149Z | 2024-11-22T14:19:21.623Z |
5560225 | 5560225 | 20241120122019_c2ndL | USL008 | 2024-11-21T14:08:19.265Z | 2024-11-22T14:19:21.615Z |
5560052 | 5560052 | 20241120115144_noqZo | USL008 | 2024-11-21T14:07:56.346Z | 2024-11-22T14:19:21.576Z |
5560009 | 5560009 | 20241120114605_cZIxp | USL008 | 2024-11-21T14:07:51.521Z | 2024-11-22T14:19:21.568Z |
5560003 | 5560003 | 20241120114537_2f42Q | USL008 | 2024-11-21T14:07:50.777Z | 2024-11-22T14:19:21.566Z |
5559983 | 5559983 | 20241120114122_reW12 | USL008 | 2024-11-21T14:07:48.533Z | 2024-11-22T14:19:21.561Z |
5559934 | 5559934 | 20241120113604_AIPQO | USL008 | 2024-11-21T14:07:36.707Z | 2024-11-22T14:19:21.553Z |
5559880 | 5559880 | 20241120112929_ZragU | USL008 | 2024-11-21T14:07:25.861Z | 2024-11-22T14:19:21.542Z |
5559863 | 5559863 | 20241120112728_3H68T | USL008 | 2024-11-21T14:07:21.310Z | 2024-11-22T14:19:21.538Z |
5559846 | 5559846 | 20241120112358_G8gvb | USL008 | 2024-11-21T14:07:19.562Z | 2024-11-22T14:19:21.535Z |
5559799 | 5559799 | 20241120111834_tqdA3 | USL008 | 2024-11-21T14:07:12.433Z | 2024-11-22T14:19:21.527Z |
5559763 | 5559763 | 20241120111410_UvHFW | USL008 | 2024-11-21T14:07:08.156Z | 2024-11-22T14:19:21.519Z |
5559331 | 5559331 | 20241120100525_IU83O | USL008 | 2024-11-21T14:06:00.535Z | 2024-11-22T14:19:21.419Z |
5559265 | 5559265 | 20241120095052_KAct7 | USL008 | 2024-11-21T14:05:45.980Z | 2024-11-22T14:19:21.401Z |
5559238 | 5559238 | 20241120094236_0oMNe | USL008 | 2024-11-21T14:05:40.558Z | 2024-11-22T14:19:21.393Z |
5559141 | 5559141 | 20241120092744_zsyXG | USL008 | 2024-11-21T14:05:27.146Z | 2024-11-22T14:19:21.372Z |
5559118 | 5559118 | 20241120092646_cTzoh | USL008 | 2024-11-21T14:05:24.842Z | 2024-11-22T14:19:21.368Z |
5559024 | 5559024 | 20241120090605_RQWoR | USL008 | 2024-11-21T14:05:05.552Z | 2024-11-22T14:19:21.349Z |
5558935 | 5558935 | 20241120085237_5ZH0N | USL008 | 2024-11-21T14:04:50.750Z | 2024-11-22T14:19:21.331Z |
5558877 | 5558877 | 20241120083806_bTI3x | USL008 | 2024-11-21T14:04:42.847Z | 2024-11-22T14:19:21.320Z |
5558853 | 5558853 | 20241120082944_gyYI2 | USL008 | 2024-11-21T14:04:38.543Z | 2024-11-22T14:19:21.315Z |
5558772 | 5558772 | 20241120075921_RN2nv | USL008 | 2024-11-21T14:04:19.417Z | 2024-11-22T14:19:21.297Z |
5558614 | 5558614 | 20241120070636_KdG5u | USL008 | 2024-11-21T14:03:49.715Z | 2024-11-22T14:19:21.263Z |
5558283 | 5558283 | 20241120055210_gvAI8 | USL008 | 2024-11-21T14:02:56.184Z | 2024-11-22T14:19:21.204Z |
5557719 | 5557719 | 20241120050754_stRD4 | USL008 | 2024-11-21T14:01:35.399Z | 2024-11-22T14:19:21.117Z |
5557323 | 5557323 | 20241120043928_4ZChK | USL008 | 2024-11-21T14:00:32.636Z | 2024-11-22T14:19:21.054Z |
5557149 | 5557149 | 20241119041148_9P3Hr | USL008 | 2024-11-20T14:12:22.407Z | 2024-11-22T14:22:22.547Z |
5557125 | 5557125 | 20241119040246_PJgvd | USL008 | 2024-11-20T14:12:19.864Z | 2024-11-22T14:22:22.384Z |
5557050 | 5557050 | 20241119033224_Jk06m | USL008 | 2024-11-20T14:12:04.717Z | 2024-11-22T14:22:21.937Z |
5556853 | 5556853 | 20241119021836_aWYcQ | USL008 | 2024-11-20T14:11:34.293Z | 2024-11-22T14:22:20.395Z |
5555312 | 5555312 | 20241119123902_UY5Lm | USL008 | 2024-11-20T14:05:09.624Z | 2024-11-22T14:20:03.642Z |
5555242 | 5555242 | 20241119122203_Rx0eN | USL008 | 2024-11-20T14:05:00.315Z | 2024-11-22T14:20:02.291Z |
5555212 | 5555212 | 20241119121620_RVhSx | USL008 | 2024-11-20T14:04:48.228Z | 2024-11-22T14:20:01.433Z |
5555199 | 5555199 | 20241119121259_CbmTD | USL008 | 2024-11-20T14:04:43.017Z | 2024-11-22T14:20:01.071Z |
5555191 | 5555191 | 20241119120752_PjmeW | USL008 | 2024-11-20T14:04:42.065Z | 2024-11-22T14:20:00.893Z |
5555066 | 5555066 | 20241119113217_bSwZd | USL008 | 2024-11-20T14:04:22.691Z | 2024-11-22T14:19:56.713Z |
5555060 | 5555060 | 20241119112836_M3hv0 | USL008 | 2024-11-20T14:04:21.251Z | 2024-11-22T14:19:56.553Z |
5555052 | 5555052 | 20241119112754_WYJdP | USL008 | 2024-11-20T14:04:18.754Z | 2024-11-22T14:19:56.271Z |
5554983 | 5554983 | 20241119111535_JhcM4 | USL008 | 2024-11-20T14:04:00.047Z | 2024-11-22T14:19:54.906Z |
5554766 | 5554766 | 20241119103349_M20Vl | USL008 | 2024-11-20T14:03:13.319Z | 2024-11-22T14:19:51.014Z |
5554747 | 5554747 | 20241119102152_MBAA9 | USL008 | 2024-11-20T14:03:10.901Z | 2024-11-22T14:19:50.499Z |
5554728 | 5554728 | 20241119101936_oB7Fl | USL008 | 2024-11-20T14:03:08.427Z | 2024-11-22T14:19:50.117Z |
5554726 | 5554726 | 20241119101843_KKlvY | USL008 | 2024-11-20T14:03:07.978Z | 2024-11-22T14:19:50.082Z |
5554704 | 5554704 | 20241119101202_6dtgS | USL008 | 2024-11-20T14:03:04.387Z | 2024-11-22T14:19:49.335Z |
5554610 | 5554610 | 20241119094805_USGXg | USL008 | 2024-11-20T14:02:40.028Z | 2024-11-22T14:19:45.544Z |
5554596 | 5554596 | 20241119094648_2IGyV | USL008 | 2024-11-20T14:02:35.402Z | 2024-11-22T14:19:45.117Z |
5554570 | 5554570 | 20241119093838_ZQqLz | USL008 | 2024-11-20T14:02:30.817Z | 2024-11-22T14:19:44.325Z |
5554554 | 5554554 | 20241119093528_1APF3 | USL008 | 2024-11-20T14:02:26.735Z | 2024-11-22T14:19:43.774Z |
5554552 | 5554552 | 20241119093424_nirFx | USL008 | 2024-11-20T14:02:26.283Z | 2024-11-22T14:19:43.716Z |
5554355 | 5554355 | 20241119082430_5HJJ1 | USL008 | 2024-11-20T14:01:45.147Z | 2024-11-22T14:19:38.299Z |
5554312 | 5554312 | 20241119080131_ddiNW | USL008 | 2024-11-20T14:01:33.597Z | 2024-11-22T14:19:36.958Z |
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);