participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
137 rows where station_code = "IT000A" 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 |
---|---|---|---|---|---|
5135757 | 5135757 | 20240918192340_jiDg3 | IT000A | 2024-09-20T12:00:25.195Z | 2024-09-20T12:06:54.608Z |
5132176 | 5132176 | 20240915235226_9lBR3 | IT000A | 2024-09-19T12:15:54.773Z | 2024-09-20T12:12:59.625Z |
5131999 | 5131999 | 20240915223534_byxfz | IT000A | 2024-09-19T12:15:42.289Z | 2024-09-20T12:12:52.610Z |
5131597 | 5131597 | 20240915202437_R4ELM | IT000A | 2024-09-19T12:15:10.889Z | 2024-09-20T12:12:34.558Z |
5125685 | 5125685 | 20240918031950_JsaA5 | IT000A | 2024-09-19T12:03:52.741Z | 2024-09-20T12:08:36.901Z |
5125552 | 5125552 | 20240918025704_83Njm | IT000A | 2024-09-19T12:03:30.674Z | 2024-09-20T12:08:29.164Z |
5125407 | 5125407 | 20240918022903_VZRoY | IT000A | 2024-09-19T12:03:10.383Z | 2024-09-20T12:08:15.100Z |
5125334 | 5125334 | 20240918021229_nyVE6 | IT000A | 2024-09-19T12:02:55.335Z | 2024-09-20T12:08:09.885Z |
5125309 | 5125309 | 20240918015751_2UHUI | IT000A | 2024-09-19T12:02:43.633Z | 2024-09-20T12:08:06.044Z |
5125162 | 5125162 | 20240918004433_tjQ1W | IT000A | 2024-09-19T12:02:25.257Z | 2024-09-20T12:07:51.161Z |
5125040 | 5125040 | 20240917234412_2yqLA | IT000A | 2024-09-19T12:02:00.148Z | 2024-09-20T12:07:38.489Z |
5124896 | 5124896 | 20240917223742_WV5Vg | IT000A | 2024-09-19T12:01:45.221Z | 2024-09-20T12:07:30.964Z |
5124870 | 5124870 | 20240917223044_qQCE1 | IT000A | 2024-09-19T12:01:42.366Z | 2024-09-20T12:07:29.301Z |
5124866 | 5124866 | 20240917222253_MzWOw | IT000A | 2024-09-19T12:01:41.555Z | 2024-09-20T12:07:29.074Z |
5124296 | 5124296 | 20240917192212_FeaU8 | IT000A | 2024-09-19T12:00:30.557Z | 2024-09-20T12:06:59.238Z |
5124261 | 5124261 | 20240917183549_N02Vb | IT000A | 2024-09-19T12:00:22.042Z | 2024-09-20T12:06:57.482Z |
5098687 | 5098687 | 20240913185913_z7iXH | IT000A | 2024-09-17T12:01:21.121Z | 2024-09-20T12:18:05.754Z |
5076723 | 5076723 | 20240911000547_wjDB6 | IT000A | 2024-09-15T12:13:58.651Z | 2024-09-19T12:21:37.518Z |
5076321 | 5076321 | 20240910232031_fPWYa | IT000A | 2024-09-15T12:13:27.678Z | 2024-09-19T12:21:36.710Z |
5076258 | 5076258 | 20240910231712_P2hr5 | IT000A | 2024-09-15T12:13:25.236Z | 2024-09-19T12:21:36.663Z |
5076141 | 5076141 | 20240910230909_GfUBP | IT000A | 2024-09-15T12:13:19.469Z | 2024-09-19T12:21:36.486Z |
5069717 | 5069717 | 20240910220158_g1G8t | IT000A | 2024-09-14T12:20:04.729Z | 2024-09-19T12:21:35.266Z |
5069708 | 5069708 | 20240910215937_mwLRb | IT000A | 2024-09-14T12:20:04.380Z | 2024-09-19T12:21:35.252Z |
5065286 | 5065286 | 20240910033702_eSQSD | IT000A | 2024-09-14T12:16:53.466Z | 2024-09-18T12:15:18.929Z |
5065030 | 5065030 | 20240910025528_g46tL | IT000A | 2024-09-14T12:16:18.753Z | 2024-09-18T12:15:18.179Z |
5064486 | 5064486 | 20240910011836_atLrH | IT000A | 2024-09-14T12:15:31.710Z | 2024-09-18T12:15:16.726Z |
5064410 | 5064410 | 20240910010038_ZsKh2 | IT000A | 2024-09-14T12:15:25.398Z | 2024-09-18T12:15:16.589Z |
5064332 | 5064332 | 20240910005113_8vUo3 | IT000A | 2024-09-14T12:15:18.064Z | 2024-09-18T12:15:16.154Z |
5064135 | 5064135 | 20240910000757_c5WZV | IT000A | 2024-09-14T12:14:58.529Z | 2024-09-18T12:15:15.565Z |
5064016 | 5064016 | 20240909232146_suEto | IT000A | 2024-09-14T12:14:40.426Z | 2024-09-18T12:15:15.208Z |
5063978 | 5063978 | 20240909231256_cL6J2 | IT000A | 2024-09-14T12:14:35.248Z | 2024-09-18T12:15:15.102Z |
5063947 | 5063947 | 20240909230627_bx4fi | IT000A | 2024-09-14T12:14:33.128Z | 2024-09-18T12:15:14.943Z |
5063459 | 5063459 | 20240909211914_2KxxT | IT000A | 2024-09-14T12:14:01.361Z | 2024-09-18T12:15:14.016Z |
5062949 | 5062949 | 20240909191853_fIi80 | IT000A | 2024-09-14T12:13:07.169Z | 2024-09-18T12:15:12.680Z |
5062945 | 5062945 | 20240909191732_lXa9O | IT000A | 2024-09-14T12:13:06.257Z | 2024-09-18T12:15:12.666Z |
5062897 | 5062897 | 20240909185432_oJKuF | IT000A | 2024-09-14T12:13:01.340Z | 2024-09-18T12:15:12.444Z |
5062827 | 5062827 | 20240909183406_iI2pj | IT000A | 2024-09-14T12:12:55.504Z | 2024-09-18T12:15:12.264Z |
5054448 | 5054448 | 20240908025313_c1Xy6 | IT000A | 2024-09-13T12:16:42.244Z | 2024-09-16T12:21:15.621Z |
5054319 | 5054319 | 20240908023934_2xqho | IT000A | 2024-09-13T12:16:38.044Z | 2024-09-16T12:21:14.905Z |
5054299 | 5054299 | 20240908023708_MywHP | IT000A | 2024-09-13T12:16:36.970Z | 2024-09-16T12:21:14.764Z |
5053993 | 5053993 | 20240908015828_3ZGMj | IT000A | 2024-09-13T12:16:25.694Z | 2024-09-16T12:21:13.693Z |
5053186 | 5053186 | 20240907234800_SbueM | IT000A | 2024-09-13T12:15:52.689Z | 2024-09-16T12:21:09.974Z |
5053112 | 5053112 | 20240907232951_fWt7u | IT000A | 2024-09-13T12:15:46.926Z | 2024-09-16T12:21:09.516Z |
5052801 | 5052801 | 20240907220935_x37s0 | IT000A | 2024-09-13T12:15:28.483Z | 2024-09-16T12:21:07.731Z |
5052772 | 5052772 | 20240907220134_kZuxA | IT000A | 2024-09-13T12:15:26.233Z | 2024-09-16T12:21:07.629Z |
5052722 | 5052722 | 20240907214533_PknDx | IT000A | 2024-09-13T12:15:22.972Z | 2024-09-16T12:21:07.362Z |
5052244 | 5052244 | 20240907200311_Q5H2C | IT000A | 2024-09-13T12:15:01.361Z | 2024-09-16T12:21:04.750Z |
5052228 | 5052228 | 20240907200020_20l1m | IT000A | 2024-09-13T12:15:00.813Z | 2024-09-16T12:21:04.681Z |
5051971 | 5051971 | 20240907191707_7PlKr | IT000A | 2024-09-13T12:14:50.919Z | 2024-09-16T12:21:02.656Z |
5033704 | 5033704 | 20240907033056_fTpvY | IT000A | 2024-09-12T12:09:50.971Z | 2024-09-15T12:21:31.524Z |
5033696 | 5033696 | 20240907032932_rYKl3 | IT000A | 2024-09-12T12:09:50.459Z | 2024-09-15T12:21:31.520Z |
5033683 | 5033683 | 20240907032807_uEpwM | IT000A | 2024-09-12T12:09:49.664Z | 2024-09-15T12:21:31.509Z |
5033456 | 5033456 | 20240907030025_mLsOL | IT000A | 2024-09-12T12:09:32.850Z | 2024-09-15T12:21:30.166Z |
5033025 | 5033025 | 20240907021453_sze5m | IT000A | 2024-09-12T12:08:43.891Z | 2024-09-15T12:21:28.851Z |
5032654 | 5032654 | 20240907012605_ieDr4 | IT000A | 2024-09-12T12:07:48.644Z | 2024-09-15T12:21:27.288Z |
5032463 | 5032463 | 20240907010452_UxOPQ | IT000A | 2024-09-12T12:07:22.229Z | 2024-09-15T12:21:26.508Z |
5032359 | 5032359 | 20240907005205_I3il2 | IT000A | 2024-09-12T12:07:10.326Z | 2024-09-15T12:21:26.255Z |
5032349 | 5032349 | 20240907005033_xmNr2 | IT000A | 2024-09-12T12:07:09.510Z | 2024-09-15T12:21:26.214Z |
5032097 | 5032097 | 20240907001115_rAAs4 | IT000A | 2024-09-12T12:06:32.389Z | 2024-09-15T12:21:25.225Z |
5031427 | 5031427 | 20240906215308_hHvN6 | IT000A | 2024-09-12T12:04:46.192Z | 2024-09-15T12:21:22.342Z |
5031348 | 5031348 | 20240906213107_C3JjB | IT000A | 2024-09-12T12:04:34.380Z | 2024-09-15T12:21:22.075Z |
5031195 | 5031195 | 20240906204930_bq3HB | IT000A | 2024-09-12T12:04:16.351Z | 2024-09-15T12:21:21.689Z |
5030762 | 5030762 | 20240906182719_tvMf2 | IT000A | 2024-09-12T12:03:00.061Z | 2024-09-15T12:21:19.590Z |
5026342 | 5026342 | 20240905030647_rho0N | IT000A | 2024-09-11T12:12:18.115Z | 2024-09-13T12:19:57.699Z |
5026148 | 5026148 | 20240905022318_xZY4e | IT000A | 2024-09-11T12:11:58.918Z | 2024-09-13T12:19:56.959Z |
5026100 | 5026100 | 20240905021642_AV15Q | IT000A | 2024-09-11T12:11:55.134Z | 2024-09-13T12:19:56.860Z |
5025929 | 5025929 | 20240905014142_WafXN | IT000A | 2024-09-11T12:11:32.313Z | 2024-09-13T12:19:56.266Z |
5025912 | 5025912 | 20240905013933_YXui7 | IT000A | 2024-09-11T12:11:30.005Z | 2024-09-13T12:19:56.169Z |
5025766 | 5025766 | 20240905011207_C3wgG | IT000A | 2024-09-11T12:10:57.907Z | 2024-09-13T12:19:55.538Z |
5020916 | 5020916 | 20240905033459_bQCUM | IT000A | 2024-09-10T12:15:07.475Z | 2024-09-13T12:19:58.327Z |
5020798 | 5020798 | 20240905030647_lM9xP | IT000A | 2024-09-10T12:15:01.803Z | 2024-09-10T12:16:55.243Z |
5020583 | 5020583 | 20240905022318_izOeF | IT000A | 2024-09-10T12:14:45.868Z | 2024-09-10T12:16:55.185Z |
5020541 | 5020541 | 20240905021642_XuuOi | IT000A | 2024-09-10T12:14:40.557Z | 2024-09-10T12:16:55.175Z |
5020369 | 5020369 | 20240905014142_B9JWv | IT000A | 2024-09-10T12:14:21.961Z | 2024-09-10T12:16:55.136Z |
5020354 | 5020354 | 20240905013933_ZBUML | IT000A | 2024-09-10T12:14:21.149Z | 2024-09-10T12:16:55.132Z |
5020185 | 5020185 | 20240905011207_0KuPV | IT000A | 2024-09-10T12:14:02.661Z | 2024-09-13T12:19:55.552Z |
5019838 | 5019838 | 20240905000222_LC227 | IT000A | 2024-09-10T12:13:36.444Z | 2024-09-13T12:19:54.020Z |
5019808 | 5019808 | 20240904235513_9Bg8B | IT000A | 2024-09-10T12:13:33.764Z | 2024-09-13T12:19:53.900Z |
5019724 | 5019724 | 20240904234253_yjOq0 | IT000A | 2024-09-10T12:13:19.332Z | 2024-09-13T12:19:53.603Z |
5019612 | 5019612 | 20240904232008_WbvhE | IT000A | 2024-09-10T12:13:00.493Z | 2024-09-13T12:19:53.031Z |
5019455 | 5019455 | 20240904225135_BzqUk | IT000A | 2024-09-10T12:12:46.322Z | 2024-09-13T12:19:52.123Z |
5019061 | 5019061 | 20240904213825_FScN0 | IT000A | 2024-09-10T12:12:00.717Z | 2024-09-13T12:19:50.326Z |
5019010 | 5019010 | 20240904212431_Jjznm | IT000A | 2024-09-10T12:11:54.630Z | 2024-09-13T12:19:50.056Z |
5018557 | 5018557 | 20240904184749_bBmZl | IT000A | 2024-09-10T12:10:50.977Z | 2024-09-13T12:19:48.149Z |
5018539 | 5018539 | 20240904184300_ZvQ5m | IT000A | 2024-09-10T12:10:49.284Z | 2024-09-13T12:19:48.083Z |
5010529 | 5010529 | 20240904031504_JbyVO | IT000A | 2024-09-09T12:08:49.567Z | 2024-09-12T12:19:27.784Z |
5010306 | 5010306 | 20240904025116_iPKH7 | IT000A | 2024-09-09T12:08:33.923Z | 2024-09-12T12:19:26.806Z |
5009834 | 5009834 | 20240904020541_YF1yJ | IT000A | 2024-09-09T12:08:08.490Z | 2024-09-12T12:19:24.608Z |
5009646 | 5009646 | 20240904014422_UiNyi | IT000A | 2024-09-09T12:07:53.475Z | 2024-09-12T12:19:23.853Z |
5009643 | 5009643 | 20240904014410_cOOo2 | IT000A | 2024-09-09T12:07:53.396Z | 2024-09-12T12:19:23.842Z |
5009539 | 5009539 | 20240904013225_wdlM9 | IT000A | 2024-09-09T12:07:48.912Z | 2024-09-12T12:19:23.260Z |
5009227 | 5009227 | 20240904010531_fJbFC | IT000A | 2024-09-09T12:07:30.572Z | 2024-09-12T12:19:22.080Z |
5008849 | 5008849 | 20240904003017_02v9o | IT000A | 2024-09-09T12:07:08.535Z | 2024-09-12T12:19:20.276Z |
5008831 | 5008831 | 20240904002833_oUH5v | IT000A | 2024-09-09T12:07:07.399Z | 2024-09-12T12:19:20.202Z |
5008640 | 5008640 | 20240904000602_TSSpU | IT000A | 2024-09-09T12:06:56.833Z | 2024-09-12T12:19:18.490Z |
5008545 | 5008545 | 20240903235248_4waXK | IT000A | 2024-09-09T12:06:52.410Z | 2024-09-12T12:19:18.038Z |
5008188 | 5008188 | 20240903231728_PsR4q | IT000A | 2024-09-09T12:06:31.086Z | 2024-09-12T12:19:16.413Z |
5008119 | 5008119 | 20240903230458_j8ldh | IT000A | 2024-09-09T12:06:27.763Z | 2024-09-12T12:19:16.260Z |
5007924 | 5007924 | 20240903223650_tiJ2x | IT000A | 2024-09-09T12:06:13.576Z | 2024-09-12T12:19:15.401Z |
5007671 | 5007671 | 20240903215946_vkb4W | IT000A | 2024-09-09T12:06:01.431Z | 2024-09-12T12:19:14.377Z |
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);