participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,251 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 |
---|---|---|---|---|---|
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 |
5285918 | 5285918 | 20241012063902_WqOzL | US001Y | 2024-10-13T12:01:01.509Z | 2024-10-21T12:22:46.333Z |
5285856 | 5285856 | 20241012060649_Gy9Vf | US001Y | 2024-10-13T12:00:50.642Z | 2024-10-21T12:22:45.316Z |
5284363 | 5284363 | 20241011023854_2Miqx | US001Y | 2024-10-12T12:17:18.617Z | 2024-10-19T12:27:55.582Z |
5283098 | 5283098 | 20241011004404_KSYjR | US001Y | 2024-10-12T12:16:24.258Z | 2024-10-19T12:27:48.957Z |
5278149 | 5278149 | 20241011094610_JmXj2 | US001Y | 2024-10-12T12:05:19.244Z | 2024-10-20T12:23:38.261Z |
5277509 | 5277509 | 20241011080435_cYzFU | US001Y | 2024-10-12T12:03:37.543Z | 2024-10-20T12:23:28.800Z |
5277335 | 5277335 | 20241011072347_HGhJX | US001Y | 2024-10-12T12:03:07.188Z | 2024-10-20T12:23:25.900Z |
5277175 | 5277175 | 20241011064125_xGiJC | US001Y | 2024-10-12T12:02:49.076Z | 2024-10-20T12:23:22.340Z |
5277062 | 5277062 | 20241011060953_Afa7H | US001Y | 2024-10-12T12:02:25.996Z | 2024-10-20T12:23:19.258Z |
5270373 | 5270373 | 20241010092859_w3921 | US001Y | 2024-10-11T12:04:17.399Z | 2024-10-19T12:26:59.033Z |
5270170 | 5270170 | 20241010085052_bsshb | US001Y | 2024-10-11T12:03:50.427Z | 2024-10-19T12:26:58.145Z |
5268631 | 5268631 | 20241009023650_79YUw | US001Y | 2024-10-10T12:16:14.679Z | 2024-10-17T12:20:18.077Z |
5264041 | 5264041 | 20241009071607_hMQHQ | US001Y | 2024-10-10T12:02:59.239Z | 2024-10-18T12:21:40.595Z |
5263905 | 5263905 | 20241009063548_HhXFe | US001Y | 2024-10-10T12:02:30.571Z | 2024-10-18T12:21:39.223Z |
5263728 | 5263728 | 20241009054430_oEj6k | US001Y | 2024-10-10T12:01:55.104Z | 2024-10-18T12:21:37.519Z |
5255299 | 5255299 | 20241008040642_Hum62 | US001Y | 2024-10-09T12:00:57.068Z | 2024-10-17T12:19:51.688Z |
5255159 | 5255159 | 20241008034703_aLxxa | US001Y | 2024-10-09T12:00:43.829Z | 2024-10-17T12:19:51.202Z |
5249503 | 5249503 | 20241007092136_tPq2C | US001Y | 2024-10-08T12:05:01.380Z | 2024-10-16T12:21:04.350Z |
5248929 | 5248929 | 20241007071759_4tEFV | US001Y | 2024-10-08T12:03:44.779Z | 2024-10-16T12:21:02.416Z |
5248845 | 5248845 | 20241007065101_3AN8b | US001Y | 2024-10-08T12:03:27.461Z | 2024-10-16T12:21:02.064Z |
5207691 | 5207691 | 20241002093722_Dtuy6 | US001Y | 2024-10-03T12:06:21.006Z | 2024-10-11T12:23:26.909Z |
5156392 | 5156392 | 20240924040312_3UyjE | US001Y | 2024-09-25T12:08:18.917Z | 2024-10-02T12:18:49.351Z |
5152169 | 5152169 | 20240923083227_dn0NZ | US001Y | 2024-09-24T12:04:03.825Z | 2024-10-01T12:22:13.298Z |
5151861 | 5151861 | 20240923070041_5ScHs | US001Y | 2024-09-24T12:03:40.817Z | 2024-10-01T12:22:11.426Z |
5151759 | 5151759 | 20240923063047_7cD7b | US001Y | 2024-09-24T12:03:22.398Z | 2024-10-01T12:22:10.397Z |
5150728 | 5150728 | 20240923003517_LOtUI | US001Y | 2024-09-24T12:01:05.477Z | 2024-10-01T12:22:02.620Z |
5148202 | 5148202 | 20240922101251_tifN2 | US001Y | 2024-09-23T12:06:27.114Z | 2024-09-30T12:22:45.943Z |
5147753 | 5147753 | 20240922084446_29MjH | US001Y | 2024-09-23T12:05:53.310Z | 2024-09-30T12:22:44.640Z |
5147639 | 5147639 | 20240922081629_mXeW4 | US001Y | 2024-09-23T12:05:33.367Z | 2024-09-30T12:22:44.189Z |
5140444 | 5140444 | 20240920102252_MOR8y | US001Y | 2024-09-21T12:03:59.263Z | 2024-09-28T12:23:20.928Z |
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);