participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,150 rows where station_code = "US003T" 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 |
---|---|---|---|---|---|
5480308 | 5480308 | 20241105122026_OtVtJ | US003T | 2024-11-06T14:05:12.491Z | 2024-11-09T14:19:22.472Z |
5480224 | 5480224 | 20241105120354_2LEvI | US003T | 2024-11-06T14:04:59.436Z | 2024-11-09T14:19:20.577Z |
5480192 | 5480192 | 20241105120059_AHVhw | US003T | 2024-11-06T14:04:49.556Z | 2024-11-09T14:19:19.961Z |
5480144 | 5480144 | 20241105114641_X0FUc | US003T | 2024-11-06T14:04:37.807Z | 2024-11-09T14:19:18.914Z |
5480051 | 5480051 | 20241105112619_VO23r | US003T | 2024-11-06T14:04:22.980Z | 2024-11-09T14:19:16.014Z |
5479903 | 5479903 | 20241105105804_tLZgU | US003T | 2024-11-06T14:03:51.833Z | 2024-11-09T14:19:13.669Z |
5479851 | 5479851 | 20241105105252_SAjpX | US003T | 2024-11-06T14:03:44.476Z | 2024-11-09T14:19:13.159Z |
5479687 | 5479687 | 20241105101857_jFe3X | US003T | 2024-11-06T14:03:04.934Z | 2024-11-09T14:19:10.504Z |
5479673 | 5479673 | 20241105101705_X0CQC | US003T | 2024-11-06T14:03:03.390Z | 2024-11-09T14:19:10.360Z |
5479311 | 5479311 | 20241105090415_16v9G | US003T | 2024-11-06T14:01:57.624Z | 2024-11-09T14:19:04.149Z |
5479290 | 5479290 | 20241105085903_ow2XU | US003T | 2024-11-06T14:01:45.547Z | 2024-11-09T14:19:03.455Z |
5479255 | 5479255 | 20241105084714_pe8go | US003T | 2024-11-06T14:01:37.422Z | 2024-11-09T14:19:02.678Z |
5479240 | 5479240 | 20241105083948_vxKV1 | US003T | 2024-11-06T14:01:35.702Z | 2024-11-09T14:19:02.290Z |
5477241 | 5477241 | 20241104012407_8XmGR | US003T | 2024-11-05T14:16:34.944Z | 2024-11-09T14:22:16.059Z |
5469482 | 5469482 | 20241103033445_0lQeZ | US003T | 2024-11-04T14:16:31.172Z | 2024-11-09T14:23:02.753Z |
5469300 | 5469300 | 20241103030559_0kEN5 | US003T | 2024-11-04T14:16:17.217Z | 2024-11-09T14:23:01.994Z |
5469008 | 5469008 | 20241103022216_gbBpb | US003T | 2024-11-04T14:15:22.321Z | 2024-11-09T14:23:00.635Z |
5468969 | 5468969 | 20241103021657_zN6yK | US003T | 2024-11-04T14:15:19.305Z | 2024-11-09T14:23:00.490Z |
5468931 | 5468931 | 20241103021136_iXcrf | US003T | 2024-11-04T14:15:15.115Z | 2024-11-09T14:23:00.380Z |
5468656 | 5468656 | 20241103011621_qHJ60 | US003T | 2024-11-04T14:14:46.941Z | 2024-11-09T14:22:59.210Z |
5463662 | 5463662 | 20241102043136_nmFKy | US003T | 2024-11-03T14:19:07.779Z | 2024-11-09T14:23:43.054Z |
5462882 | 5462882 | 20241102015030_Dy6Wb | US003T | 2024-11-03T14:18:08.667Z | 2024-11-09T14:23:36.650Z |
5459643 | 5459643 | 20241101112906_PtMol | US003T | 2024-11-03T14:12:24.038Z | 2024-11-09T14:23:20.054Z |
5459537 | 5459537 | 20241101111407_eX2YV | US003T | 2024-11-03T14:12:15.456Z | 2024-11-09T14:23:18.907Z |
5459529 | 5459529 | 20241101111323_BBME2 | US003T | 2024-11-03T14:12:14.285Z | 2024-11-09T14:23:18.859Z |
5459508 | 5459508 | 20241101111018_7eKi5 | US003T | 2024-11-03T14:12:04.008Z | 2024-11-09T14:23:18.609Z |
5459088 | 5459088 | 20241101100602_bMG8m | US003T | 2024-11-03T14:11:18.193Z | 2024-11-09T14:23:16.128Z |
5458834 | 5458834 | 20241101092406_4YYh2 | US003T | 2024-11-03T14:10:40.930Z | 2024-11-09T14:23:14.696Z |
5458729 | 5458729 | 20241101090643_SCIeV | US003T | 2024-11-03T14:10:31.566Z | 2024-11-09T14:23:13.973Z |
5458620 | 5458620 | 20241101084959_3SEtF | US003T | 2024-11-03T14:10:08.391Z | 2024-11-09T14:23:13.262Z |
5458399 | 5458399 | 20241101082125_kOW7V | US003T | 2024-11-03T14:09:42.675Z | 2024-11-09T14:23:11.921Z |
5458379 | 5458379 | 20241101081835_NLa2O | US003T | 2024-11-03T14:09:40.737Z | 2024-11-09T14:23:11.835Z |
5458259 | 5458259 | 20241101075530_ogtcq | US003T | 2024-11-03T14:09:23.406Z | 2024-11-09T14:23:11.080Z |
5456744 | 5456744 | 20241102121317_OQZps | US003T | 2024-11-03T14:05:36.208Z | 2024-11-09T14:22:45.330Z |
5456642 | 5456642 | 20241102115724_sHlcg | US003T | 2024-11-03T14:05:11.592Z | 2024-11-09T14:22:44.818Z |
5456559 | 5456559 | 20241102114520_1DfzP | US003T | 2024-11-03T14:04:59.066Z | 2024-11-09T14:22:44.425Z |
5456493 | 5456493 | 20241102113359_J2D62 | US003T | 2024-11-03T14:04:50.224Z | 2024-11-09T14:22:44.103Z |
5455895 | 5455895 | 20241102094036_OwR5S | US003T | 2024-11-03T14:02:36.900Z | 2024-11-09T14:22:40.567Z |
5455692 | 5455692 | 20241102085715_4rn6G | US003T | 2024-11-03T14:01:56.712Z | 2024-11-09T14:22:38.084Z |
5455622 | 5455622 | 20241102084532_MGtAc | US003T | 2024-11-03T14:01:43.021Z | 2024-11-09T14:22:37.470Z |
5455579 | 5455579 | 20241102083507_cwC5o | US003T | 2024-11-03T14:01:33.656Z | 2024-11-09T14:22:37.185Z |
5455528 | 5455528 | 20241102081916_b6t0z | US003T | 2024-11-03T14:01:11.982Z | 2024-11-09T14:22:36.581Z |
5455473 | 5455473 | 20241102075932_5oXSC | US003T | 2024-11-03T14:01:02.530Z | 2024-11-09T14:22:35.982Z |
5455469 | 5455469 | 20241102075851_cPgby | US003T | 2024-11-03T14:01:01.771Z | 2024-11-09T14:22:35.930Z |
5454960 | 5454960 | 20241031055409_NX30l | US003T | 2024-11-02T12:23:27.608Z | 2024-11-08T14:23:26.493Z |
5454928 | 5454928 | 20241031054709_Sat7g | US003T | 2024-11-02T12:23:26.835Z | 2024-11-08T14:23:26.280Z |
5454657 | 5454657 | 20241031045232_PwOq5 | US003T | 2024-11-02T12:23:15.705Z | 2024-11-08T14:23:24.629Z |
5453116 | 5453116 | 20241031014145_BZKhv | US003T | 2024-11-02T12:22:27.112Z | 2024-11-08T14:23:16.023Z |
5453030 | 5453030 | 20241101064726_cQgkb | US003T | 2024-11-02T12:19:42.291Z | 2024-11-09T14:24:37.978Z |
5453019 | 5453019 | 20241101064226_FM4uT | US003T | 2024-11-02T12:19:42.089Z | 2024-11-09T14:24:37.764Z |
5452783 | 5452783 | 20241101043313_3j1Yq | US003T | 2024-11-02T12:19:21.668Z | 2024-11-09T14:24:33.680Z |
5452116 | 5452116 | 20241101020312_3RsHK | US003T | 2024-11-02T12:18:17.373Z | 2024-11-09T14:24:28.316Z |
5452072 | 5452072 | 20241101015213_b4yak | US003T | 2024-11-02T12:18:15.137Z | 2024-11-09T14:24:27.834Z |
5452006 | 5452006 | 20241101014313_SDbbB | US003T | 2024-11-02T12:18:10.652Z | 2024-11-09T14:24:27.565Z |
5447865 | 5447865 | 20241031121803_YTRvL | US003T | 2024-11-02T12:09:20.228Z | 2024-11-09T14:24:01.552Z |
5447569 | 5447569 | 20241031115350_r0nmS | US003T | 2024-11-02T12:08:28.071Z | 2024-11-09T14:24:00.517Z |
5447500 | 5447500 | 20241031114724_Cn3yc | US003T | 2024-11-02T12:08:19.710Z | 2024-11-09T14:24:00.099Z |
5447307 | 5447307 | 20241031112842_qZhf2 | US003T | 2024-11-02T12:07:44.080Z | 2024-11-09T14:23:58.767Z |
5447025 | 5447025 | 20241031105916_HvT6T | US003T | 2024-11-02T12:06:57.347Z | 2024-11-09T14:23:57.414Z |
5446883 | 5446883 | 20241031104323_UWMuV | US003T | 2024-11-02T12:06:37.934Z | 2024-11-09T14:23:56.982Z |
5446875 | 5446875 | 20241031104229_Dvvpo | US003T | 2024-11-02T12:06:36.061Z | 2024-11-09T14:23:56.933Z |
5446702 | 5446702 | 20241031102356_BVtA1 | US003T | 2024-11-02T12:06:03.937Z | 2024-11-09T14:23:56.046Z |
5446532 | 5446532 | 20241031100821_jUgKk | US003T | 2024-11-02T12:05:32.284Z | 2024-11-09T14:23:55.023Z |
5446491 | 5446491 | 20241031100446_c3b0q | US003T | 2024-11-02T12:05:27.945Z | 2024-11-09T14:23:54.910Z |
5446280 | 5446280 | 20241031094330_LuQU2 | US003T | 2024-11-02T12:04:45.584Z | 2024-11-09T14:23:54.046Z |
5446009 | 5446009 | 20241031091717_EoZih | US003T | 2024-11-02T12:03:58.647Z | 2024-11-09T14:23:52.309Z |
5445847 | 5445847 | 20241031085320_r2j9o | US003T | 2024-11-02T12:03:22.227Z | 2024-11-09T14:23:51.568Z |
5445434 | 5445434 | 20241031080256_CD74S | US003T | 2024-11-02T12:02:02.510Z | 2024-11-09T14:23:50.018Z |
5445394 | 5445394 | 20241031075607_8LWqp | US003T | 2024-11-02T12:01:57.665Z | 2024-11-09T14:23:49.770Z |
5445251 | 5445251 | 20241031072638_uL4t4 | US003T | 2024-11-02T12:01:26.477Z | 2024-11-09T14:23:48.597Z |
5445228 | 5445228 | 20241031072437_UXYTH | US003T | 2024-11-02T12:01:22.929Z | 2024-11-09T14:23:48.534Z |
5445118 | 5445118 | 20241031070054_ehlXT | US003T | 2024-11-02T12:00:58.749Z | 2024-11-09T14:23:47.634Z |
5445038 | 5445038 | 20241101073509_gIIKu | US003T | 2024-11-02T12:00:44.690Z | 2024-11-09T14:23:10.702Z |
5445024 | 5445024 | 20241101072951_3sxgZ | US003T | 2024-11-02T12:00:36.226Z | 2024-11-09T14:23:10.351Z |
5443377 | 5443377 | 20241030054319_D92gk | US003T | 2024-11-01T12:20:29.122Z | 2024-11-07T14:26:51.114Z |
5443270 | 5443270 | 20241030042518_EcdqE | US003T | 2024-11-01T12:20:25.449Z | 2024-11-07T14:26:50.503Z |
5435200 | 5435200 | 20241030110122_pFBx5 | US003T | 2024-11-01T12:04:30.480Z | 2024-11-08T14:22:49.611Z |
5435131 | 5435131 | 20241030105224_7sVim | US003T | 2024-11-01T12:04:21.737Z | 2024-11-08T14:22:49.361Z |
5434994 | 5434994 | 20241030103435_365oO | US003T | 2024-11-01T12:03:55.130Z | 2024-11-08T14:22:48.922Z |
5434912 | 5434912 | 20241030102421_2uDqU | US003T | 2024-11-01T12:03:44.668Z | 2024-11-08T14:22:48.479Z |
5434491 | 5434491 | 20241030093329_3A22O | US003T | 2024-11-01T12:02:30.564Z | 2024-11-08T14:22:46.661Z |
5434217 | 5434217 | 20241030084007_6mj6J | US003T | 2024-11-01T12:01:34.551Z | 2024-11-08T14:22:45.640Z |
5434040 | 5434040 | 20241030080851_6CEAq | US003T | 2024-11-01T12:00:59.632Z | 2024-11-08T14:22:44.542Z |
5433832 | 5433832 | 20241030071421_100Ob | US003T | 2024-11-01T12:00:17.477Z | 2024-11-08T14:22:43.273Z |
5433095 | 5433095 | 20241029064013_uMAji | US003T | 2024-10-31T12:21:45.715Z | 2024-11-06T14:27:30.003Z |
5433072 | 5433072 | 20241029061259_RRrqq | US003T | 2024-10-31T12:21:44.838Z | 2024-11-06T14:27:29.893Z |
5432888 | 5432888 | 20241029050631_S2jLs | US003T | 2024-10-31T12:21:37.841Z | 2024-11-06T14:27:29.093Z |
5432729 | 5432729 | 20241029042701_vNaRy | US003T | 2024-10-31T12:21:32.835Z | 2024-11-06T14:27:28.578Z |
5423940 | 5423940 | 20241029122737_DHRy8 | US003T | 2024-10-31T12:03:15.763Z | 2024-11-07T14:26:29.692Z |
5423836 | 5423836 | 20241029121102_qX11P | US003T | 2024-10-31T12:02:55.773Z | 2024-11-07T14:26:29.198Z |
5423732 | 5423732 | 20241029114548_tSCH6 | US003T | 2024-10-31T12:02:29.133Z | 2024-11-07T14:26:28.595Z |
5423706 | 5423706 | 20241029113817_K3pDI | US003T | 2024-10-31T12:02:25.655Z | 2024-11-07T14:26:28.469Z |
5423694 | 5423694 | 20241029113529_iGwDI | US003T | 2024-10-31T12:02:20.400Z | 2024-11-07T14:26:28.354Z |
5423679 | 5423679 | 20241029113210_BIMUW | US003T | 2024-10-31T12:02:18.665Z | 2024-11-07T14:26:27.876Z |
5423629 | 5423629 | 20241029111610_ZJwaW | US003T | 2024-10-31T12:02:11.542Z | 2024-11-07T14:26:27.392Z |
5423583 | 5423583 | 20241029110421_2yYB4 | US003T | 2024-10-31T12:02:03.539Z | 2024-11-07T14:26:26.916Z |
5423453 | 5423453 | 20241029102608_fH8to | US003T | 2024-10-31T12:01:30.768Z | 2024-11-07T14:26:25.810Z |
5423376 | 5423376 | 20241029101140_wcAv0 | US003T | 2024-10-31T12:01:19.198Z | 2024-11-07T14:26:25.522Z |
5423304 | 5423304 | 20241029092527_W9fwz | US003T | 2024-10-31T12:00:56.198Z | 2024-11-07T14:26:24.978Z |
5423208 | 5423208 | 20241029082843_ubWnb | US003T | 2024-10-31T12:00:38.408Z | 2024-11-07T14:26:24.434Z |
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);