participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,281 rows where station_code = "US001Y" 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 |
---|---|---|---|---|---|
5592468 | 5592468 | 20241123033213_hEB2g | US001Y | 2024-11-24T14:21:02.741Z | 2024-11-24T14:21:11.788Z |
5591832 | 5591832 | 20241123010705_keKtJ | US001Y | 2024-11-24T14:20:19.822Z | 2024-11-24T14:21:11.606Z |
5585990 | 5585990 | 20241123104540_IFMkM | US001Y | 2024-11-24T14:06:39.398Z | 2024-11-24T14:06:39.398Z |
5585681 | 5585681 | 20241123095437_8x7ob | US001Y | 2024-11-24T14:05:43.434Z | 2024-11-24T14:05:43.434Z |
5585219 | 5585219 | 20241123080438_sddnk | US001Y | 2024-11-24T14:03:53.665Z | 2024-11-24T14:03:53.665Z |
5585017 | 5585017 | 20241123071919_yqy2m | US001Y | 2024-11-24T14:03:18.867Z | 2024-11-24T14:03:18.867Z |
5584911 | 5584911 | 20241123065101_XfV7p | US001Y | 2024-11-24T14:02:55.985Z | 2024-11-24T14:02:55.985Z |
5584423 | 5584423 | 20241123043429_u3JGs | US001Y | 2024-11-24T14:00:58.282Z | 2024-11-24T14:00:58.282Z |
5576001 | 5576001 | 20241122105958_0NKY0 | US001Y | 2024-11-23T14:08:14.680Z | 2024-11-24T14:21:10.529Z |
5575086 | 5575086 | 20241122080112_OaOUl | US001Y | 2024-11-23T14:05:25.489Z | 2024-11-24T14:21:10.210Z |
5567635 | 5567635 | 20241121104724_U0h0r | US001Y | 2024-11-22T14:06:41.738Z | 2024-11-24T14:21:51.945Z |
5566823 | 5566823 | 20241121080353_xVpQb | US001Y | 2024-11-22T14:04:11.622Z | 2024-11-24T14:21:38.847Z |
5566446 | 5566446 | 20241121061231_7l6Il | US001Y | 2024-11-22T14:02:54.842Z | 2024-11-24T14:21:31.842Z |
5553527 | 5553527 | 20241118030715_JA7o9 | US001Y | 2024-11-19T14:10:46.230Z | 2024-11-24T14:25:22.323Z |
5550579 | 5550579 | 20241118105118_VIuFS | US001Y | 2024-11-19T14:02:40.993Z | 2024-11-24T14:24:54.829Z |
5550193 | 5550193 | 20241118094534_hm5I6 | US001Y | 2024-11-19T14:01:44.014Z | 2024-11-24T14:24:52.505Z |
5549800 | 5549800 | 20241118065513_CsJgy | US001Y | 2024-11-19T14:00:52.697Z | 2024-11-24T14:24:50.434Z |
5544440 | 5544440 | 20241116110900_0zlTb | US001Y | 2024-11-17T14:01:10.022Z | 2024-11-24T14:25:26.203Z |
5544420 | 5544420 | 20241116105634_MFMIY | US001Y | 2024-11-17T14:01:05.545Z | 2024-11-24T14:25:26.107Z |
5544414 | 5544414 | 20241116105447_tb4jf | US001Y | 2024-11-17T14:01:04.093Z | 2024-11-24T14:25:26.104Z |
5544204 | 5544204 | 20241116081145_WG3vC | US001Y | 2024-11-17T14:00:27.286Z | 2024-11-24T14:25:25.409Z |
5542509 | 5542509 | 20241115103333_6JuuM | US001Y | 2024-11-16T14:01:32.564Z | 2024-11-24T14:25:39.672Z |
5542502 | 5542502 | 20241115102655_KpIBM | US001Y | 2024-11-16T14:01:31.727Z | 2024-11-24T14:25:39.643Z |
5542367 | 5542367 | 20241115085622_tOsk7 | US001Y | 2024-11-16T14:01:04.502Z | 2024-11-24T14:25:38.829Z |
5542307 | 5542307 | 20241115081719_vh55u | US001Y | 2024-11-16T14:00:56.302Z | 2024-11-24T14:25:38.677Z |
5542254 | 5542254 | 20241115074252_NBGQJ | US001Y | 2024-11-16T14:00:49.339Z | 2024-11-24T14:25:38.547Z |
5542204 | 5542204 | 20241115071154_YGKfq | US001Y | 2024-11-16T14:00:39.428Z | 2024-11-24T14:25:38.381Z |
5534122 | 5534122 | 20241113110257_sqUSV | US001Y | 2024-11-14T14:03:35.735Z | 2024-11-22T14:24:12.442Z |
5533352 | 5533352 | 20241113084026_jDBTk | US001Y | 2024-11-14T14:01:46.339Z | 2024-11-22T14:24:08.710Z |
5532985 | 5532985 | 20241113063537_alIAn | US001Y | 2024-11-14T14:00:43.551Z | 2024-11-22T14:24:06.455Z |
5469899 | 5469899 | 20241103043802_5c2Ho | US001Y | 2024-11-04T14:17:16.129Z | 2024-11-11T14:23:02.987Z |
5469683 | 5469683 | 20241103040120_3fGgu | US001Y | 2024-11-04T14:16:49.682Z | 2024-11-11T14:23:01.986Z |
5452762 | 5452762 | 20241101042427_MOYgj | US001Y | 2024-11-02T12:19:20.918Z | 2024-11-09T14:24:33.562Z |
5452240 | 5452240 | 20241101023134_KSi9j | US001Y | 2024-11-02T12:18:31.010Z | 2024-11-09T14:24:29.721Z |
5432865 | 5432865 | 20241029050059_gHBTC | US001Y | 2024-10-31T12:21:37.120Z | 2024-11-06T14:27:29.063Z |
5410648 | 5410648 | 20241027052531_nm00v | US001Y | 2024-10-29T12:18:02.015Z | 2024-11-04T14:29:05.196Z |
5410334 | 5410334 | 20241027050653_HUuwt | US001Y | 2024-10-29T12:17:53.341Z | 2024-11-04T14:29:04.343Z |
5400290 | 5400290 | 20241026062918_vWnam | US001Y | 2024-10-28T12:20:29.230Z | 2024-11-03T14:27:41.800Z |
5390149 | 5390149 | 20241026090552_h8rAF | US001Y | 2024-10-28T12:02:12.243Z | 2024-11-04T14:28:26.394Z |
5390141 | 5390141 | 20241026090207_EAaJ0 | US001Y | 2024-10-28T12:02:11.329Z | 2024-11-04T14:28:26.366Z |
5389472 | 5389472 | 20241026070647_v5Qz2 | US001Y | 2024-10-28T12:00:23.236Z | 2024-11-04T14:28:22.684Z |
5388063 | 5388063 | 20241025035720_8rPXy | US001Y | 2024-10-27T12:21:57.283Z | 2024-11-02T12:28:33.731Z |
5387336 | 5387336 | 20241025022458_0axfJ | US001Y | 2024-10-27T12:21:12.502Z | 2024-11-02T12:28:32.408Z |
5379031 | 5379031 | 20241025074557_Yy1Xu | US001Y | 2024-10-27T12:01:51.007Z | 2024-11-03T14:27:05.662Z |
5378741 | 5378741 | 20241025070134_cAKEg | US001Y | 2024-10-27T12:00:38.501Z | 2024-11-03T14:27:04.732Z |
5378678 | 5378678 | 20241025064844_ZhIHg | US001Y | 2024-10-27T12:00:27.238Z | 2024-11-03T14:27:04.496Z |
5378317 | 5378317 | 20241024055730_RoTtc | US001Y | 2024-10-26T12:22:59.957Z | 2024-11-01T12:27:03.759Z |
5376095 | 5376095 | 20241024034056_Dq3gg | US001Y | 2024-10-26T12:21:50.278Z | 2024-11-01T12:27:01.387Z |
5374217 | 5374217 | 20241024021651_3RwTK | US001Y | 2024-10-26T12:20:39.902Z | 2024-11-01T12:26:58.772Z |
5368909 | 5368909 | 20241024102944_zUJgb | US001Y | 2024-10-26T12:05:06.495Z | 2024-11-02T12:28:17.035Z |
5368880 | 5368880 | 20241024102553_32AFF | US001Y | 2024-10-26T12:05:02.918Z | 2024-11-02T12:28:17.016Z |
5368781 | 5368781 | 20241024101024_ryOO6 | US001Y | 2024-10-26T12:04:39.266Z | 2024-11-02T12:28:16.849Z |
5368706 | 5368706 | 20241024100006_3lx8U | US001Y | 2024-10-26T12:04:29.758Z | 2024-11-02T12:28:16.434Z |
5368425 | 5368425 | 20241024092241_64CSa | US001Y | 2024-10-26T12:03:30.743Z | 2024-11-02T12:28:15.523Z |
5368046 | 5368046 | 20241024082102_3oEeG | US001Y | 2024-10-26T12:02:23.291Z | 2024-11-02T12:28:14.973Z |
5367335 | 5367335 | 20241023062623_VZH3g | US001Y | 2024-10-25T12:21:50.876Z | 2024-10-31T12:30:12.405Z |
5367271 | 5367271 | 20241023061133_jP8x9 | US001Y | 2024-10-25T12:21:49.619Z | 2024-10-31T12:30:11.986Z |
5367065 | 5367065 | 20241023051320_MJaTi | US001Y | 2024-10-25T12:21:43.467Z | 2024-10-31T12:30:10.811Z |
5367014 | 5367014 | 20241023050247_2cT5i | US001Y | 2024-10-25T12:21:40.898Z | 2024-10-31T12:30:10.503Z |
5366716 | 5366716 | 20241023034835_oBR7n | US001Y | 2024-10-25T12:21:28.342Z | 2024-10-31T12:30:08.055Z |
5357834 | 5357834 | 20241023102043_NwIJU | US001Y | 2024-10-25T12:04:38.722Z | 2024-11-01T12:26:41.405Z |
5357410 | 5357410 | 20241023093041_UMBm7 | US001Y | 2024-10-25T12:03:29.356Z | 2024-11-01T12:26:40.175Z |
5356583 | 5356583 | 20241023071836_1UHP8 | US001Y | 2024-10-25T12:00:58.574Z | 2024-11-01T12:26:36.240Z |
5345642 | 5345642 | 20241022103027_PJ1nE | US001Y | 2024-10-24T12:02:25.294Z | 2024-10-31T12:29:44.982Z |
5345351 | 5345351 | 20241022053909_vuram | US001Y | 2024-10-23T12:19:15.220Z | 2024-10-30T12:26:52.520Z |
5337474 | 5337474 | 20241022100307_53DVu | US001Y | 2024-10-23T12:05:00.892Z | 2024-10-31T12:29:44.507Z |
5337386 | 5337386 | 20241022095731_im2E6 | US001Y | 2024-10-23T12:04:49.360Z | 2024-10-31T12:29:44.385Z |
5336838 | 5336838 | 20241022090238_oVHGn | US001Y | 2024-10-23T12:03:35.293Z | 2024-10-31T12:29:42.621Z |
5334239 | 5334239 | 20241021021049_6TiHE | US001Y | 2024-10-22T12:16:29.982Z | 2024-10-29T12:26:34.984Z |
5329253 | 5329253 | 20241021095644_Ss9qF | US001Y | 2024-10-22T12:03:43.434Z | 2024-10-30T12:26:34.082Z |
5328864 | 5328864 | 20241021090126_EMpro | US001Y | 2024-10-22T12:02:38.448Z | 2024-10-30T12:26:33.167Z |
5328115 | 5328115 | 20241021064440_I2kLT | US001Y | 2024-10-22T12:00:24.482Z | 2024-10-30T12:26:31.389Z |
5324550 | 5324550 | 20241020102926_3bsBr | US001Y | 2024-10-21T12:03:08.551Z | 2024-10-29T12:26:29.461Z |
5324303 | 5324303 | 20241020091711_9qa42 | US001Y | 2024-10-21T12:02:18.657Z | 2024-10-29T12:26:28.469Z |
5323950 | 5323950 | 20241020080138_3BT79 | US001Y | 2024-10-21T12:01:06.540Z | 2024-10-29T12:26:27.807Z |
5322290 | 5322290 | 20241019104424_K1vpc | US001Y | 2024-10-20T12:01:35.739Z | 2024-10-28T12:26:40.271Z |
5322064 | 5322064 | 20241019085307_QO0nO | US001Y | 2024-10-20T12:00:49.865Z | 2024-10-28T12:26:39.653Z |
5319016 | 5319016 | 20241018074929_ml5Er | US001Y | 2024-10-19T12:00:46.641Z | 2024-10-27T12:28:45.904Z |
5317757 | 5317757 | 20241017091453_Ya8R2 | US001Y | 2024-10-18T12:00:45.085Z | 2024-10-26T12:27:51.083Z |
5317672 | 5317672 | 20241017082244_LR2fy | US001Y | 2024-10-18T12:00:29.007Z | 2024-10-26T12:27:50.801Z |
5313737 | 5313737 | 20241016095507_3XdWH | US001Y | 2024-10-17T12:00:55.833Z | 2024-10-25T12:24:26.890Z |
5313700 | 5313700 | 20241016093943_AjeSH | US001Y | 2024-10-17T12:00:51.499Z | 2024-10-25T12:24:26.708Z |
5313601 | 5313601 | 20241016090035_m4xFG | US001Y | 2024-10-17T12:00:38.110Z | 2024-10-25T12:24:26.011Z |
5313563 | 5313563 | 20241016084820_NZbHs | US001Y | 2024-10-17T12:00:32.261Z | 2024-10-25T12:24:25.711Z |
5313505 | 5313505 | 20241016080049_2S9o5 | US001Y | 2024-10-17T12:00:25.778Z | 2024-10-25T12:24:25.371Z |
5308637 | 5308637 | 20241014102154_6tQJO | US001Y | 2024-10-16T12:04:04.696Z | 2024-10-23T12:24:18.732Z |
5307212 | 5307212 | 20241015084519_xLj2b | US001Y | 2024-10-16T12:00:56.995Z | 2024-10-24T12:27:41.043Z |
5307171 | 5307171 | 20241015082006_BEbLo | US001Y | 2024-10-16T12:00:51.542Z | 2024-10-24T12:27:40.761Z |
5307164 | 5307164 | 20241015081812_5aCd2 | US001Y | 2024-10-16T12:00:50.441Z | 2024-10-24T12:27:40.715Z |
5304586 | 5304586 | 20241013104400_yyTAW | US001Y | 2024-10-15T12:02:10.130Z | 2024-10-22T12:24:19.665Z |
5304447 | 5304447 | 20241013101343_AgDqi | US001Y | 2024-10-15T12:01:49.230Z | 2024-10-22T12:24:18.293Z |
5304167 | 5304167 | 20241013042300_j4c2K | US001Y | 2024-10-14T12:17:43.876Z | 2024-10-21T12:24:23.858Z |
5296100 | 5296100 | 20241013095859_j9Dm8 | US001Y | 2024-10-14T12:04:18.212Z | 2024-10-22T12:24:17.573Z |
5295733 | 5295733 | 20241013085221_GXU93 | US001Y | 2024-10-14T12:03:10.606Z | 2024-10-22T12:24:14.565Z |
5295329 | 5295329 | 20241013072653_mq3pV | US001Y | 2024-10-14T12:01:54.817Z | 2024-10-22T12:24:11.181Z |
5295313 | 5295313 | 20241013072227_9W7le | US001Y | 2024-10-14T12:01:51.596Z | 2024-10-22T12:24:10.874Z |
5295068 | 5295068 | 20241013055713_1026Q | US001Y | 2024-10-14T12:01:02.398Z | 2024-10-22T12:24:07.901Z |
5286399 | 5286399 | 20241012083155_gL49f | US001Y | 2024-10-13T12:02:24.750Z | 2024-10-21T12:22:53.601Z |
5286013 | 5286013 | 20241012071211_RqEDt | US001Y | 2024-10-13T12:01:16.061Z | 2024-10-21T12:22:47.933Z |
5285981 | 5285981 | 20241012070514_T3bLp | US001Y | 2024-10-13T12:01:09.771Z | 2024-10-21T12:22:47.405Z |
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);