participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,802 rows where station_code = "US0036" 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 |
---|---|---|---|---|---|
5134288 | 5134288 | 20240916074941_lMpM1 | US0036 | 2024-09-19T12:17:35.395Z | 2024-09-19T12:17:35.395Z |
5134275 | 5134275 | 20240916074555_C1oay | US0036 | 2024-09-19T12:17:34.960Z | 2024-09-19T12:17:34.960Z |
5134250 | 5134250 | 20240916072720_VCPjq | US0036 | 2024-09-19T12:17:33.586Z | 2024-09-19T12:17:33.586Z |
5134233 | 5134233 | 20240916072100_ziBE1 | US0036 | 2024-09-19T12:17:32.755Z | 2024-09-19T12:17:32.755Z |
5134230 | 5134230 | 20240916071322_MBDFb | US0036 | 2024-09-19T12:17:32.527Z | 2024-09-19T12:17:32.527Z |
5123075 | 5123075 | 20240914084753_VuHpC | US0036 | 2024-09-18T12:11:39.526Z | 2024-09-19T12:20:07.576Z |
5122918 | 5122918 | 20240914082311_TzVT6 | US0036 | 2024-09-18T12:11:34.094Z | 2024-09-19T12:20:06.690Z |
5122786 | 5122786 | 20240914075755_3Yhqr | US0036 | 2024-09-18T12:11:31.159Z | 2024-09-19T12:20:06.186Z |
5122743 | 5122743 | 20240914074827_83Sq7 | US0036 | 2024-09-18T12:11:29.902Z | 2024-09-19T12:20:05.910Z |
5122657 | 5122657 | 20240914072754_KyVB5 | US0036 | 2024-09-18T12:11:27.191Z | 2024-09-19T12:20:05.542Z |
5122476 | 5122476 | 20240914063547_xL10y | US0036 | 2024-09-18T12:11:20.251Z | 2024-09-19T12:20:04.497Z |
5122190 | 5122190 | 20240914044942_DXoBB | US0036 | 2024-09-18T12:11:08.919Z | 2024-09-19T12:20:02.951Z |
5122168 | 5122168 | 20240914044331_S2W4U | US0036 | 2024-09-18T12:11:08.218Z | 2024-09-19T12:20:02.903Z |
5121886 | 5121886 | 20240914041933_VZoL3 | US0036 | 2024-09-18T12:11:02.782Z | 2024-09-19T12:20:02.480Z |
5121047 | 5121047 | 20240914034921_41GqT | US0036 | 2024-09-18T12:10:50.324Z | 2024-09-19T12:20:01.261Z |
5120463 | 5120463 | 20240914032131_u2X1c | US0036 | 2024-09-18T12:10:40.963Z | 2024-09-19T12:20:00.350Z |
5120442 | 5120442 | 20240914032033_rJmuu | US0036 | 2024-09-18T12:10:39.877Z | 2024-09-19T12:20:00.233Z |
5118415 | 5118415 | 20240915094047_aS1ra | US0036 | 2024-09-18T12:08:43.161Z | 2024-09-19T12:19:22.629Z |
5118411 | 5118411 | 20240915093912_FbI5K | US0036 | 2024-09-18T12:08:42.980Z | 2024-09-19T12:19:22.588Z |
5118399 | 5118399 | 20240915093808_aH1UG | US0036 | 2024-09-18T12:08:42.353Z | 2024-09-19T12:19:22.504Z |
5118095 | 5118095 | 20240915082945_7vWr3 | US0036 | 2024-09-18T12:08:23.899Z | 2024-09-19T12:19:20.326Z |
5118081 | 5118081 | 20240915082749_FqosZ | US0036 | 2024-09-18T12:08:22.527Z | 2024-09-19T12:19:20.221Z |
5118043 | 5118043 | 20240915081507_TEh3m | US0036 | 2024-09-18T12:08:20.474Z | 2024-09-19T12:19:19.936Z |
5118029 | 5118029 | 20240915080929_6HXrz | US0036 | 2024-09-18T12:08:19.147Z | 2024-09-19T12:19:19.846Z |
5117984 | 5117984 | 20240915080508_hFnDo | US0036 | 2024-09-18T12:08:15.426Z | 2024-09-19T12:19:19.493Z |
5117796 | 5117796 | 20240915070444_MVFvX | US0036 | 2024-09-18T12:08:00.253Z | 2024-09-19T12:19:18.032Z |
5117774 | 5117774 | 20240915070001_Cg9kj | US0036 | 2024-09-18T12:07:58.333Z | 2024-09-19T12:19:17.815Z |
5117727 | 5117727 | 20240915063759_fTSgj | US0036 | 2024-09-18T12:07:53.727Z | 2024-09-19T12:19:17.250Z |
5117719 | 5117719 | 20240915063604_pwjxj | US0036 | 2024-09-18T12:07:53.468Z | 2024-09-19T12:19:17.212Z |
5117698 | 5117698 | 20240915062830_EI1II | US0036 | 2024-09-18T12:07:52.542Z | 2024-09-19T12:19:17.013Z |
5117696 | 5117696 | 20240915062739_cvpOX | US0036 | 2024-09-18T12:07:52.483Z | 2024-09-19T12:19:17.007Z |
5117651 | 5117651 | 20240915060429_9V5Fb | US0036 | 2024-09-18T12:07:51.070Z | 2024-09-19T12:19:16.774Z |
5108938 | 5108938 | 20240913080918_8POoy | US0036 | 2024-09-17T12:14:20.475Z | 2024-09-19T12:20:51.222Z |
5108936 | 5108936 | 20240913080758_EaMmY | US0036 | 2024-09-17T12:14:19.564Z | 2024-09-19T12:20:51.207Z |
5108898 | 5108898 | 20240913080044_3IxR3 | US0036 | 2024-09-17T12:14:15.884Z | 2024-09-19T12:20:51.063Z |
5108862 | 5108862 | 20240913074857_EufOv | US0036 | 2024-09-17T12:14:11.246Z | 2024-09-19T12:20:50.959Z |
5108839 | 5108839 | 20240913074232_8GqoY | US0036 | 2024-09-17T12:14:09.374Z | 2024-09-19T12:20:50.913Z |
5108712 | 5108712 | 20240913070728_cMcNl | US0036 | 2024-09-17T12:13:58.598Z | 2024-09-19T12:20:50.465Z |
5108683 | 5108683 | 20240913065931_VH2gH | US0036 | 2024-09-17T12:13:57.507Z | 2024-09-19T12:20:50.293Z |
5108663 | 5108663 | 20240913065653_ttu2W | US0036 | 2024-09-17T12:13:56.448Z | 2024-09-19T12:20:50.215Z |
5108548 | 5108548 | 20240913062204_92AyQ | US0036 | 2024-09-17T12:13:50.735Z | 2024-09-19T12:20:49.454Z |
5108515 | 5108515 | 20240913060841_ptlxU | US0036 | 2024-09-17T12:13:48.773Z | 2024-09-19T12:20:49.222Z |
5108336 | 5108336 | 20240913045533_J9hiQ | US0036 | 2024-09-17T12:13:37.515Z | 2024-09-19T12:20:48.253Z |
5108285 | 5108285 | 20240913044140_VurAC | US0036 | 2024-09-17T12:13:34.860Z | 2024-09-19T12:20:48.002Z |
5107570 | 5107570 | 20240913040149_6oocq | US0036 | 2024-09-17T12:13:17.277Z | 2024-09-19T12:20:47.264Z |
5107417 | 5107417 | 20240913035519_miAgj | US0036 | 2024-09-17T12:13:14.819Z | 2024-09-19T12:20:47.124Z |
5105888 | 5105888 | 20240913030209_vJNAH | US0036 | 2024-09-17T12:12:32.069Z | 2024-09-19T12:20:45.025Z |
5105502 | 5105502 | 20240913024926_U7RrJ | US0036 | 2024-09-17T12:12:19.446Z | 2024-09-19T12:20:44.604Z |
5095448 | 5095448 | 20240912073603_h2KcN | US0036 | 2024-09-16T12:15:40.552Z | 2024-09-19T12:21:18.556Z |
5095353 | 5095353 | 20240912072049_UczF5 | US0036 | 2024-09-16T12:15:35.102Z | 2024-09-19T12:21:18.200Z |
5095326 | 5095326 | 20240912071520_odGFz | US0036 | 2024-09-16T12:15:32.618Z | 2024-09-19T12:21:18.137Z |
5095211 | 5095211 | 20240912063957_nqlVw | US0036 | 2024-09-16T12:15:23.050Z | 2024-09-19T12:21:17.528Z |
5095207 | 5095207 | 20240912063622_Urayt | US0036 | 2024-09-16T12:15:22.486Z | 2024-09-19T12:21:17.514Z |
5095191 | 5095191 | 20240912063137_Ml7YB | US0036 | 2024-09-16T12:15:21.411Z | 2024-09-19T12:21:17.461Z |
5095124 | 5095124 | 20240912060505_IvNNF | US0036 | 2024-09-16T12:15:17.063Z | 2024-09-19T12:21:17.307Z |
5095048 | 5095048 | 20240912053105_GZboz | US0036 | 2024-09-16T12:15:11.064Z | 2024-09-19T12:21:17.071Z |
5095047 | 5095047 | 20240912052623_23elU | US0036 | 2024-09-16T12:15:10.975Z | 2024-09-19T12:21:17.065Z |
5094953 | 5094953 | 20240912045122_zutSW | US0036 | 2024-09-16T12:15:03.081Z | 2024-09-19T12:21:16.626Z |
5094946 | 5094946 | 20240912044755_KGxrQ | US0036 | 2024-09-16T12:15:02.685Z | 2024-09-19T12:21:16.618Z |
5094630 | 5094630 | 20240912041232_T292j | US0036 | 2024-09-16T12:14:52.615Z | 2024-09-19T12:21:16.332Z |
5094308 | 5094308 | 20240912035652_xZp2L | US0036 | 2024-09-16T12:14:41.259Z | 2024-09-19T12:21:16.067Z |
5093048 | 5093048 | 20240912030940_krZfu | US0036 | 2024-09-16T12:14:10.870Z | 2024-09-19T12:21:14.918Z |
5089333 | 5089333 | 20240912003553_ymhH5 | US0036 | 2024-09-16T12:11:20.508Z | 2024-09-19T12:21:09.888Z |
5089012 | 5089012 | 20240912001851_cVUpv | US0036 | 2024-09-16T12:11:11.908Z | 2024-09-19T12:21:09.677Z |
5082235 | 5082235 | 20240911094230_aFkqZ | US0036 | 2024-09-15T12:18:08.824Z | 2024-09-19T12:21:47.542Z |
5082176 | 5082176 | 20240911093228_0Kjoq | US0036 | 2024-09-15T12:18:05.879Z | 2024-09-19T12:21:47.407Z |
5082093 | 5082093 | 20240911092052_PvwM0 | US0036 | 2024-09-15T12:18:02.765Z | 2024-09-19T12:21:47.176Z |
5082070 | 5082070 | 20240911091720_69kmV | US0036 | 2024-09-15T12:18:01.159Z | 2024-09-19T12:21:47.151Z |
5082025 | 5082025 | 20240911091423_LUtNC | US0036 | 2024-09-15T12:17:59.746Z | 2024-09-19T12:21:47.055Z |
5081844 | 5081844 | 20240911085055_ViVWn | US0036 | 2024-09-15T12:17:50.935Z | 2024-09-19T12:21:46.564Z |
5081807 | 5081807 | 20240911084526_Zk6QC | US0036 | 2024-09-15T12:17:49.174Z | 2024-09-19T12:21:46.490Z |
5081617 | 5081617 | 20240911080956_zh2Ui | US0036 | 2024-09-15T12:17:38.867Z | 2024-09-19T12:21:45.872Z |
5081560 | 5081560 | 20240911080208_IyrcI | US0036 | 2024-09-15T12:17:37.868Z | 2024-09-19T12:21:45.730Z |
5081477 | 5081477 | 20240911074819_TpXuS | US0036 | 2024-09-15T12:17:35.419Z | 2024-09-19T12:21:45.496Z |
5081413 | 5081413 | 20240911074034_IYQZt | US0036 | 2024-09-15T12:17:32.610Z | 2024-09-19T12:21:45.277Z |
5081412 | 5081412 | 20240911073909_tSqAc | US0036 | 2024-09-15T12:17:32.481Z | 2024-09-19T12:21:45.276Z |
5081304 | 5081304 | 20240911071910_UE5gX | US0036 | 2024-09-15T12:17:29.880Z | 2024-09-19T12:21:45.066Z |
5081186 | 5081186 | 20240911064901_5Dau8 | US0036 | 2024-09-15T12:17:26.179Z | 2024-09-19T12:21:44.726Z |
5081158 | 5081158 | 20240911064323_ZcE5W | US0036 | 2024-09-15T12:17:25.213Z | 2024-09-19T12:21:44.685Z |
5081014 | 5081014 | 20240911060045_2pyXH | US0036 | 2024-09-15T12:17:20.575Z | 2024-09-19T12:21:44.372Z |
5080982 | 5080982 | 20240911055056_3ImcI | US0036 | 2024-09-15T12:17:19.647Z | 2024-09-19T12:21:44.186Z |
5080838 | 5080838 | 20240911050227_oSm2P | US0036 | 2024-09-15T12:17:15.405Z | 2024-09-19T12:21:43.873Z |
5080829 | 5080829 | 20240911045832_OwYmE | US0036 | 2024-09-15T12:17:14.846Z | 2024-09-19T12:21:43.842Z |
5080807 | 5080807 | 20240911045343_LKheL | US0036 | 2024-09-15T12:17:14.040Z | 2024-09-19T12:21:43.697Z |
5080685 | 5080685 | 20240911042428_cvjVt | US0036 | 2024-09-15T12:17:10.166Z | 2024-09-19T12:21:43.387Z |
5080614 | 5080614 | 20240911041339_AEqNK | US0036 | 2024-09-15T12:17:08.908Z | 2024-09-19T12:21:43.353Z |
5080574 | 5080574 | 20240911041154_KndEI | US0036 | 2024-09-15T12:17:08.501Z | 2024-09-19T12:21:43.345Z |
5079577 | 5079577 | 20240911030427_oV4AX | US0036 | 2024-09-15T12:16:26.669Z | 2024-09-19T12:21:42.390Z |
5078977 | 5078977 | 20240911022743_ATNpd | US0036 | 2024-09-15T12:16:01.342Z | 2024-09-19T12:21:40.951Z |
5078647 | 5078647 | 20240911020759_ogauH | US0036 | 2024-09-15T12:15:47.664Z | 2024-09-19T12:21:40.645Z |
5078639 | 5078639 | 20240911020750_2BFPX | US0036 | 2024-09-15T12:15:47.448Z | 2024-09-19T12:21:40.640Z |
5077988 | 5077988 | 20240911013404_wqET1 | US0036 | 2024-09-15T12:15:15.750Z | 2024-09-19T12:21:39.880Z |
5077756 | 5077756 | 20240911011606_Uj3AS | US0036 | 2024-09-15T12:15:03.371Z | 2024-09-19T12:21:39.608Z |
5077739 | 5077739 | 20240911011326_gIbtN | US0036 | 2024-09-15T12:15:02.441Z | 2024-09-19T12:21:39.586Z |
5067210 | 5067210 | 20240910090654_TRqEd | US0036 | 2024-09-14T12:18:35.810Z | 2024-09-18T12:15:23.596Z |
5067124 | 5067124 | 20240910085712_xmhwg | US0036 | 2024-09-14T12:18:32.915Z | 2024-09-18T12:15:23.450Z |
5067107 | 5067107 | 20240910085540_Nn0xK | US0036 | 2024-09-14T12:18:30.947Z | 2024-09-18T12:15:23.377Z |
5066962 | 5066962 | 20240910083510_oLhg1 | US0036 | 2024-09-14T12:18:23.409Z | 2024-09-18T12:15:23.055Z |
5066674 | 5066674 | 20240910080125_Cz2Jt | US0036 | 2024-09-14T12:18:07.033Z | 2024-09-18T12:15:22.407Z |
5066633 | 5066633 | 20240910075807_bLvjM | US0036 | 2024-09-14T12:18:05.144Z | 2024-09-18T12:15:22.353Z |
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);