participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "USL00Q" 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 |
---|---|---|---|---|---|
5505613 | 5505613 | 20241108062409_F97CL | USL00Q | 2024-11-09T14:16:25.301Z | 2024-11-09T14:16:28.827Z |
5505597 | 5505597 | 20241108061952_QdQ68 | USL00Q | 2024-11-09T14:16:24.687Z | 2024-11-09T14:16:28.823Z |
5505563 | 5505563 | 20241108060841_viytc | USL00Q | 2024-11-09T14:16:23.381Z | 2024-11-09T14:16:28.815Z |
5505557 | 5505557 | 20241108060647_7PL9f | USL00Q | 2024-11-09T14:16:23.208Z | 2024-11-09T14:16:28.815Z |
5505495 | 5505495 | 20241108054150_PqLGl | USL00Q | 2024-11-09T14:16:20.800Z | 2024-11-09T14:16:28.799Z |
5505430 | 5505430 | 20241108051550_xxTpF | USL00Q | 2024-11-09T14:16:17.077Z | 2024-11-09T14:16:28.782Z |
5505360 | 5505360 | 20241108044937_dCYB1 | USL00Q | 2024-11-09T14:16:12.948Z | 2024-11-09T14:16:28.764Z |
5505327 | 5505327 | 20241108043740_2zOSO | USL00Q | 2024-11-09T14:16:10.136Z | 2024-11-09T14:16:28.756Z |
5505309 | 5505309 | 20241108043357_XCjNu | USL00Q | 2024-11-09T14:16:07.611Z | 2024-11-09T14:16:28.751Z |
5505302 | 5505302 | 20241108043131_xog2l | USL00Q | 2024-11-09T14:16:06.985Z | 2024-11-09T14:16:28.750Z |
5505287 | 5505287 | 20241108042529_jJypt | USL00Q | 2024-11-09T14:16:04.674Z | 2024-11-09T14:16:28.745Z |
5505215 | 5505215 | 20241108040848_ML9P0 | USL00Q | 2024-11-09T14:15:56.096Z | 2024-11-09T14:16:28.727Z |
5505204 | 5505204 | 20241108040721_LoO2A | USL00Q | 2024-11-09T14:15:55.198Z | 2024-11-09T14:16:28.724Z |
5505198 | 5505198 | 20241108040527_D3EXj | USL00Q | 2024-11-09T14:15:54.646Z | 2024-11-09T14:16:28.723Z |
5505131 | 5505131 | 20241108035642_y9K82 | USL00Q | 2024-11-09T14:15:46.550Z | 2024-11-09T14:16:28.707Z |
5505096 | 5505096 | 20241108035131_uueAu | USL00Q | 2024-11-09T14:15:43.553Z | 2024-11-09T14:16:28.700Z |
5504972 | 5504972 | 20241108032704_vhoDT | USL00Q | 2024-11-09T14:15:30.216Z | 2024-11-09T14:16:28.670Z |
5504789 | 5504789 | 20241108025808_PWrm7 | USL00Q | 2024-11-09T14:15:11.526Z | 2024-11-09T14:16:28.626Z |
5504613 | 5504613 | 20241108022257_Pm27V | USL00Q | 2024-11-09T14:14:56.749Z | 2024-11-09T14:16:28.582Z |
5504507 | 5504507 | 20241108020837_L8tFU | USL00Q | 2024-11-09T14:14:46.160Z | 2024-11-09T14:16:28.557Z |
5504483 | 5504483 | 20241108020440_OrR2C | USL00Q | 2024-11-09T14:14:44.134Z | 2024-11-09T14:16:28.550Z |
5499676 | 5499676 | 20241108125531_8D2tJ | USL00Q | 2024-11-09T14:04:43.005Z | 2024-11-09T14:04:43.005Z |
5499606 | 5499606 | 20241108124325_Ktaij | USL00Q | 2024-11-09T14:04:25.751Z | 2024-11-09T14:04:25.751Z |
5499596 | 5499596 | 20241108124045_2Zdv2 | USL00Q | 2024-11-09T14:04:24.839Z | 2024-11-09T14:04:24.839Z |
5499578 | 5499578 | 20241108123908_Htrsr | USL00Q | 2024-11-09T14:04:21.782Z | 2024-11-09T14:04:21.782Z |
5499525 | 5499525 | 20241108123141_2W9VT | USL00Q | 2024-11-09T14:04:15.670Z | 2024-11-09T14:04:15.670Z |
5499513 | 5499513 | 20241108123043_1ToxB | USL00Q | 2024-11-09T14:04:14.870Z | 2024-11-09T14:04:14.870Z |
5499484 | 5499484 | 20241108122733_TihtQ | USL00Q | 2024-11-09T14:04:11.119Z | 2024-11-09T14:04:11.119Z |
5499381 | 5499381 | 20241108120851_nnZcP | USL00Q | 2024-11-09T14:03:54.659Z | 2024-11-09T14:03:54.659Z |
5499341 | 5499341 | 20241108120111_DaSTz | USL00Q | 2024-11-09T14:03:48.285Z | 2024-11-09T14:03:48.285Z |
5499303 | 5499303 | 20241108115218_9vpbr | USL00Q | 2024-11-09T14:03:42.823Z | 2024-11-09T14:03:42.823Z |
5499289 | 5499289 | 20241108114949_Vu82q | USL00Q | 2024-11-09T14:03:42.021Z | 2024-11-09T14:03:42.021Z |
5499284 | 5499284 | 20241108114949_PApzP | USL00Q | 2024-11-09T14:03:41.758Z | 2024-11-09T14:03:41.758Z |
5499277 | 5499277 | 20241108114844_UIolV | USL00Q | 2024-11-09T14:03:40.751Z | 2024-11-09T14:03:40.751Z |
5499266 | 5499266 | 20241108114712_uHJPs | USL00Q | 2024-11-09T14:03:39.057Z | 2024-11-09T14:03:39.057Z |
5499250 | 5499250 | 20241108114321_C4IWZ | USL00Q | 2024-11-09T14:03:37.481Z | 2024-11-09T14:03:37.481Z |
5499212 | 5499212 | 20241108113530_62cNv | USL00Q | 2024-11-09T14:03:33.006Z | 2024-11-09T14:03:33.006Z |
5499204 | 5499204 | 20241108113321_x8jK3 | USL00Q | 2024-11-09T14:03:31.814Z | 2024-11-09T14:03:31.814Z |
5499184 | 5499184 | 20241108112550_4nb2t | USL00Q | 2024-11-09T14:03:29.718Z | 2024-11-09T14:03:29.718Z |
5499140 | 5499140 | 20241108111748_rvA7d | USL00Q | 2024-11-09T14:03:24.547Z | 2024-11-09T14:03:24.547Z |
5499079 | 5499079 | 20241108110129_LdL2N | USL00Q | 2024-11-09T14:03:06.395Z | 2024-11-09T14:03:06.395Z |
5499068 | 5499068 | 20241108105814_DO5ce | USL00Q | 2024-11-09T14:03:05.330Z | 2024-11-09T14:03:05.330Z |
5499052 | 5499052 | 20241108105432_zaUqE | USL00Q | 2024-11-09T14:03:03.109Z | 2024-11-09T14:03:03.109Z |
5499033 | 5499033 | 20241108105131_g6Vol | USL00Q | 2024-11-09T14:03:01.175Z | 2024-11-09T14:03:01.175Z |
5498989 | 5498989 | 20241108103930_zQ4v5 | USL00Q | 2024-11-09T14:02:55.742Z | 2024-11-09T14:02:55.742Z |
5498946 | 5498946 | 20241108103139_2kuVA | USL00Q | 2024-11-09T14:02:49.456Z | 2024-11-09T14:02:49.456Z |
5498937 | 5498937 | 20241108102931_MrOx5 | USL00Q | 2024-11-09T14:02:48.680Z | 2024-11-09T14:02:48.680Z |
5498895 | 5498895 | 20241108102134_3t2Kv | USL00Q | 2024-11-09T14:02:43.504Z | 2024-11-09T14:02:43.504Z |
5498862 | 5498862 | 20241108101606_GS1hW | USL00Q | 2024-11-09T14:02:38.384Z | 2024-11-09T14:02:38.384Z |
5498775 | 5498775 | 20241108095600_339BJ | USL00Q | 2024-11-09T14:02:22.853Z | 2024-11-09T14:02:22.853Z |
5498769 | 5498769 | 20241108095428_qKQ9P | USL00Q | 2024-11-09T14:02:22.118Z | 2024-11-09T14:02:22.118Z |
5498753 | 5498753 | 20241108095244_Ptumh | USL00Q | 2024-11-09T14:02:20.728Z | 2024-11-09T14:02:20.728Z |
5498735 | 5498735 | 20241108094517_nQTbN | USL00Q | 2024-11-09T14:02:17.523Z | 2024-11-09T14:02:17.523Z |
5498725 | 5498725 | 20241108094241_IQU0Q | USL00Q | 2024-11-09T14:02:16.360Z | 2024-11-09T14:02:16.360Z |
5498697 | 5498697 | 20241108093802_2ycqN | USL00Q | 2024-11-09T14:02:12.807Z | 2024-11-09T14:02:12.807Z |
5498692 | 5498692 | 20241108093658_wdyy6 | USL00Q | 2024-11-09T14:02:12.131Z | 2024-11-09T14:02:12.131Z |
5498687 | 5498687 | 20241108093651_aB8EV | USL00Q | 2024-11-09T14:02:11.573Z | 2024-11-09T14:02:11.573Z |
5498666 | 5498666 | 20241108093339_HSxP2 | USL00Q | 2024-11-09T14:02:08.255Z | 2024-11-09T14:02:08.255Z |
5498646 | 5498646 | 20241108092906_t0b87 | USL00Q | 2024-11-09T14:02:04.572Z | 2024-11-09T14:02:04.572Z |
5498632 | 5498632 | 20241108092708_CocvP | USL00Q | 2024-11-09T14:02:01.682Z | 2024-11-09T14:02:01.682Z |
5498593 | 5498593 | 20241108091459_1VJVe | USL00Q | 2024-11-09T14:01:53.438Z | 2024-11-09T14:01:53.438Z |
5498542 | 5498542 | 20241108085840_2QW2f | USL00Q | 2024-11-09T14:01:44.147Z | 2024-11-09T14:01:44.147Z |
5498540 | 5498540 | 20241108085826_ZiSzQ | USL00Q | 2024-11-09T14:01:43.921Z | 2024-11-09T14:01:43.921Z |
5498471 | 5498471 | 20241108083806_Yn8pz | USL00Q | 2024-11-09T14:01:33.508Z | 2024-11-09T14:01:33.508Z |
5498431 | 5498431 | 20241108083001_6lXUi | USL00Q | 2024-11-09T14:01:28.549Z | 2024-11-09T14:01:28.549Z |
5498385 | 5498385 | 20241108082358_vP3XX | USL00Q | 2024-11-09T14:01:20.328Z | 2024-11-09T14:01:20.328Z |
5498377 | 5498377 | 20241108082306_s39z3 | USL00Q | 2024-11-09T14:01:18.475Z | 2024-11-09T14:01:18.475Z |
5498351 | 5498351 | 20241108081521_Hh02e | USL00Q | 2024-11-09T14:01:12.818Z | 2024-11-09T14:01:12.818Z |
5498296 | 5498296 | 20241108075416_S8uCS | USL00Q | 2024-11-09T14:01:03.602Z | 2024-11-09T14:01:03.602Z |
5498285 | 5498285 | 20241108074927_ExPgk | USL00Q | 2024-11-09T14:01:02.035Z | 2024-11-09T14:01:02.035Z |
5498256 | 5498256 | 20241108074348_B39bD | USL00Q | 2024-11-09T14:00:58.475Z | 2024-11-09T14:00:58.475Z |
5498245 | 5498245 | 20241108074124_Bpyed | USL00Q | 2024-11-09T14:00:55.939Z | 2024-11-09T14:00:55.939Z |
5498230 | 5498230 | 20241108073455_JM7mD | USL00Q | 2024-11-09T14:00:53.479Z | 2024-11-09T14:00:53.479Z |
5498220 | 5498220 | 20241108073419_ptD6E | USL00Q | 2024-11-09T14:00:52.067Z | 2024-11-09T14:00:52.067Z |
5498187 | 5498187 | 20241108072650_mIN2h | USL00Q | 2024-11-09T14:00:46.552Z | 2024-11-09T14:00:46.552Z |
5498169 | 5498169 | 20241108071934_IdMNF | USL00Q | 2024-11-09T14:00:42.145Z | 2024-11-09T14:00:42.145Z |
5498107 | 5498107 | 20241108065710_xs4So | USL00Q | 2024-11-09T14:00:30.425Z | 2024-11-09T14:00:30.425Z |
5498093 | 5498093 | 20241108064835_HUzJV | USL00Q | 2024-11-09T14:00:27.020Z | 2024-11-09T14:00:27.020Z |
5498047 | 5498047 | 20241108063437_pgzfv | USL00Q | 2024-11-09T14:00:19.004Z | 2024-11-09T14:00:19.004Z |
5498032 | 5498032 | 20241108062924_3VQQG | USL00Q | 2024-11-09T14:00:14.030Z | 2024-11-09T14:00:14.030Z |
5498020 | 5498020 | 20241108062502_m437o | USL00Q | 2024-11-09T14:00:10.287Z | 2024-11-09T14:00:10.287Z |
5497964 | 5497964 | 20241107062646_fBsHb | USL00Q | 2024-11-08T14:14:32.456Z | 2024-11-09T14:18:54.392Z |
5497951 | 5497951 | 20241107061923_6fgPp | USL00Q | 2024-11-08T14:14:31.904Z | 2024-11-09T14:18:54.249Z |
5497921 | 5497921 | 20241107060716_r3eYS | USL00Q | 2024-11-08T14:14:30.784Z | 2024-11-09T14:18:53.690Z |
5497901 | 5497901 | 20241107055800_yPEz3 | USL00Q | 2024-11-08T14:14:29.709Z | 2024-11-09T14:18:53.442Z |
5497874 | 5497874 | 20241107054036_HhxDT | USL00Q | 2024-11-08T14:14:28.552Z | 2024-11-09T14:18:52.964Z |
5497856 | 5497856 | 20241107053502_eBJg5 | USL00Q | 2024-11-08T14:14:27.854Z | 2024-11-09T14:18:52.805Z |
5497809 | 5497809 | 20241107051859_OwCHu | USL00Q | 2024-11-08T14:14:23.410Z | 2024-11-09T14:18:52.399Z |
5497786 | 5497786 | 20241107051446_3drxF | USL00Q | 2024-11-08T14:14:20.941Z | 2024-11-09T14:18:52.008Z |
5497774 | 5497774 | 20241107051046_ZJrUl | USL00Q | 2024-11-08T14:14:20.092Z | 2024-11-09T14:18:51.741Z |
5497753 | 5497753 | 20241107050045_3j2rk | USL00Q | 2024-11-08T14:14:18.422Z | 2024-11-09T14:18:51.539Z |
5497695 | 5497695 | 20241107043327_7g6Z1 | USL00Q | 2024-11-08T14:14:12.910Z | 2024-11-09T14:18:50.761Z |
5497680 | 5497680 | 20241107042735_U20dc | USL00Q | 2024-11-08T14:14:10.318Z | 2024-11-09T14:18:50.426Z |
5497628 | 5497628 | 20241107041456_Knk7c | USL00Q | 2024-11-08T14:14:05.469Z | 2024-11-09T14:18:48.225Z |
5497616 | 5497616 | 20241107041226_l5Q61 | USL00Q | 2024-11-08T14:14:03.543Z | 2024-11-09T14:18:47.587Z |
5497573 | 5497573 | 20241107040206_Antia | USL00Q | 2024-11-08T14:13:59.339Z | 2024-11-09T14:18:46.399Z |
5497474 | 5497474 | 20241107034736_8d0g4 | USL00Q | 2024-11-08T14:13:50.693Z | 2024-11-09T14:18:44.273Z |
5497416 | 5497416 | 20241107033624_q4m9t | USL00Q | 2024-11-08T14:13:44.414Z | 2024-11-09T14:18:42.473Z |
5493678 | 5493678 | 20241107130006_2Xocs | USL00Q | 2024-11-08T14:04:28.698Z | 2024-11-09T14:16:27.692Z |
5493661 | 5493661 | 20241107125626_1ItMX | USL00Q | 2024-11-08T14:04:26.877Z | 2024-11-09T14:16:27.687Z |
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);