participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "HR000V" 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 |
---|---|---|---|---|---|
5573242 | 5573242 | 20241121041303_xXEai | HR000V | 2024-11-22T14:19:17.956Z | 2024-11-22T14:19:22.476Z |
5573207 | 5573207 | 20241121040828_jgYTi | HR000V | 2024-11-22T14:19:15.853Z | 2024-11-22T14:19:22.470Z |
5572725 | 5572725 | 20241121030240_sA3Wh | HR000V | 2024-11-22T14:18:46.341Z | 2024-11-22T14:19:22.381Z |
5572481 | 5572481 | 20241121022625_8g3Ul | HR000V | 2024-11-22T14:18:29.423Z | 2024-11-22T14:19:22.337Z |
5572342 | 5572342 | 20241121021238_8z6Fm | HR000V | 2024-11-22T14:18:17.454Z | 2024-11-22T14:19:22.311Z |
5572258 | 5572258 | 20241121020031_6Tekp | HR000V | 2024-11-22T14:18:08.336Z | 2024-11-22T14:19:22.291Z |
5572100 | 5572100 | 20241121013248_DNbAd | HR000V | 2024-11-22T14:17:57.684Z | 2024-11-22T14:19:22.259Z |
5571970 | 5571970 | 20241121011521_ZxLGg | HR000V | 2024-11-22T14:17:50.267Z | 2024-11-22T14:19:22.234Z |
5571798 | 5571798 | 20241121004838_OhbcA | HR000V | 2024-11-22T14:17:40.348Z | 2024-11-22T14:19:22.198Z |
5570975 | 5570975 | 20241120215005_H1Wuj | HR000V | 2024-11-22T14:16:15.512Z | 2024-11-22T14:19:22.016Z |
5565926 | 5565926 | 20241121050654_VTHLk | HR000V | 2024-11-22T14:01:25.142Z | 2024-11-22T14:01:25.142Z |
5565875 | 5565875 | 20241121045819_dw8K3 | HR000V | 2024-11-22T14:01:17.516Z | 2024-11-22T14:01:17.516Z |
5553941 | 5553941 | 20241117022952_WORJN | HR000V | 2024-11-19T14:13:25.763Z | 2024-11-22T14:23:17.286Z |
5549354 | 5549354 | 20241117043214_h1Npi | HR000V | 2024-11-18T14:11:30.055Z | 2024-11-22T14:23:20.393Z |
5549316 | 5549316 | 20241117042102_FaC83 | HR000V | 2024-11-18T14:11:27.315Z | 2024-11-22T14:23:20.207Z |
5549239 | 5549239 | 20241117040001_RbOXg | HR000V | 2024-11-18T14:11:21.122Z | 2024-11-22T14:23:19.527Z |
5549135 | 5549135 | 20241117032012_VV4oN | HR000V | 2024-11-18T14:11:04.486Z | 2024-11-22T14:23:18.882Z |
5548985 | 5548985 | 20241117023456_5rMNX | HR000V | 2024-11-18T14:10:35.557Z | 2024-11-22T14:23:17.410Z |
5548917 | 5548917 | 20241117021637_G1aNp | HR000V | 2024-11-18T14:10:26.370Z | 2024-11-22T14:23:16.868Z |
5548874 | 5548874 | 20241117020427_uLbD6 | HR000V | 2024-11-18T14:10:22.132Z | 2024-11-22T14:23:16.612Z |
5548835 | 5548835 | 20241117015534_jVrBg | HR000V | 2024-11-18T14:10:18.522Z | 2024-11-22T14:23:16.233Z |
5548780 | 5548780 | 20241117014039_cTc2z | HR000V | 2024-11-18T14:10:12.539Z | 2024-11-22T14:23:15.759Z |
5548763 | 5548763 | 20241117013425_A8mCE | HR000V | 2024-11-18T14:10:10.945Z | 2024-11-22T14:23:15.572Z |
5548760 | 5548760 | 20241117013414_MyV3g | HR000V | 2024-11-18T14:10:10.712Z | 2024-11-22T14:23:15.477Z |
5548574 | 5548574 | 20241117002518_hr1Op | HR000V | 2024-11-18T14:09:31.294Z | 2024-11-22T14:23:14.400Z |
5548556 | 5548556 | 20241117001730_NaJ3V | HR000V | 2024-11-18T14:09:27.951Z | 2024-11-22T14:23:14.329Z |
5548435 | 5548435 | 20241116233157_fXY33 | HR000V | 2024-11-18T14:09:13.243Z | 2024-11-22T14:23:13.094Z |
5548333 | 5548333 | 20241116223706_LtR7C | HR000V | 2024-11-18T14:08:48.062Z | 2024-11-22T14:23:12.103Z |
5548274 | 5548274 | 20241116220043_aNXh2 | HR000V | 2024-11-18T14:08:38.076Z | 2024-11-22T14:23:11.597Z |
5548266 | 5548266 | 20241116215935_GVEsN | HR000V | 2024-11-18T14:08:36.644Z | 2024-11-22T14:23:11.566Z |
5548226 | 5548226 | 20241116214051_yyr3G | HR000V | 2024-11-18T14:08:30.142Z | 2024-11-22T14:23:11.197Z |
5545256 | 5545256 | 20241116032552_N1wIE | HR000V | 2024-11-17T14:04:20.272Z | 2024-11-22T14:23:39.090Z |
5545242 | 5545242 | 20241116031422_KQgYi | HR000V | 2024-11-17T14:04:18.322Z | 2024-11-22T14:23:38.678Z |
5545203 | 5545203 | 20241116023625_F277w | HR000V | 2024-11-17T14:04:06.877Z | 2024-11-22T14:23:37.226Z |
5545201 | 5545201 | 20241116023214_K132V | HR000V | 2024-11-17T14:04:06.186Z | 2024-11-22T14:23:37.222Z |
5545197 | 5545197 | 20241116022629_5DDKY | HR000V | 2024-11-17T14:04:05.172Z | 2024-11-22T14:23:37.206Z |
5545176 | 5545176 | 20241116020146_xkN1b | HR000V | 2024-11-17T14:03:58.590Z | 2024-11-22T14:23:37.032Z |
5545148 | 5545148 | 20241116013350_B2r4a | HR000V | 2024-11-17T14:03:54.608Z | 2024-11-22T14:23:36.553Z |
5545139 | 5545139 | 20241116012206_zVnBk | HR000V | 2024-11-17T14:03:53.621Z | 2024-11-22T14:23:36.494Z |
5545127 | 5545127 | 20241116004950_1jllx | HR000V | 2024-11-17T14:03:50.998Z | 2024-11-22T14:23:36.246Z |
5545117 | 5545117 | 20241116003808_ciPxz | HR000V | 2024-11-17T14:03:49.779Z | 2024-11-22T14:23:36.215Z |
5545056 | 5545056 | 20241115230059_yau1H | HR000V | 2024-11-17T14:03:42.136Z | 2024-11-22T14:23:35.645Z |
5545043 | 5545043 | 20241115225307_T4m2E | HR000V | 2024-11-17T14:03:40.710Z | 2024-11-22T14:23:35.542Z |
5543928 | 5543928 | 20241115044112_R7dm8 | HR000V | 2024-11-16T14:07:41.163Z | 2024-11-22T14:24:02.560Z |
5543922 | 5543922 | 20241115043848_XLDh9 | HR000V | 2024-11-16T14:07:40.505Z | 2024-11-22T14:24:02.522Z |
5543878 | 5543878 | 20241115040409_9Rg79 | HR000V | 2024-11-16T14:07:35.367Z | 2024-11-22T14:24:02.219Z |
5543691 | 5543691 | 20241115030010_UhKwG | HR000V | 2024-11-16T14:07:02.147Z | 2024-11-22T14:24:00.772Z |
5543505 | 5543505 | 20241115014938_6D1mM | HR000V | 2024-11-16T14:06:32.888Z | 2024-11-22T14:23:59.778Z |
5543459 | 5543459 | 20241115012926_RbndJ | HR000V | 2024-11-16T14:06:24.581Z | 2024-11-22T14:23:59.378Z |
5543407 | 5543407 | 20241115011057_l9su2 | HR000V | 2024-11-16T14:06:15.041Z | 2024-11-22T14:23:58.868Z |
5543330 | 5543330 | 20241115001646_HnJK1 | HR000V | 2024-11-16T14:06:06.532Z | 2024-11-22T14:23:58.290Z |
5538783 | 5538783 | 20241113045726_mf4jB | HR000V | 2024-11-14T14:13:57.407Z | 2024-11-21T14:26:28.743Z |
5538737 | 5538737 | 20241113044839_SsXwR | HR000V | 2024-11-14T14:13:54.397Z | 2024-11-21T14:26:28.681Z |
5538546 | 5538546 | 20241113040911_MnbD8 | HR000V | 2024-11-14T14:13:37.132Z | 2024-11-21T14:26:27.094Z |
5538504 | 5538504 | 20241113040042_CYDWD | HR000V | 2024-11-14T14:13:34.634Z | 2024-11-21T14:26:26.868Z |
5538492 | 5538492 | 20241113035737_YcE9Y | HR000V | 2024-11-14T14:13:33.220Z | 2024-11-21T14:26:26.616Z |
5538483 | 5538483 | 20241113035528_k84eA | HR000V | 2024-11-14T14:13:31.925Z | 2024-11-21T14:26:26.551Z |
5538420 | 5538420 | 20241113033722_UYqAk | HR000V | 2024-11-14T14:13:25.213Z | 2024-11-21T14:26:25.507Z |
5538367 | 5538367 | 20241113032138_c0evs | HR000V | 2024-11-14T14:13:20.796Z | 2024-11-21T14:26:25.034Z |
5538353 | 5538353 | 20241113031814_WSBEF | HR000V | 2024-11-14T14:13:18.021Z | 2024-11-21T14:26:24.696Z |
5538323 | 5538323 | 20241113031027_UzP6q | HR000V | 2024-11-14T14:13:15.016Z | 2024-11-21T14:26:23.467Z |
5538255 | 5538255 | 20241113025022_88T30 | HR000V | 2024-11-14T14:13:09.905Z | 2024-11-21T14:26:22.830Z |
5538253 | 5538253 | 20241113024926_6O2BO | HR000V | 2024-11-14T14:13:08.850Z | 2024-11-21T14:26:22.740Z |
5538166 | 5538166 | 20241113022608_3984c | HR000V | 2024-11-14T14:12:58.851Z | 2024-11-21T14:26:21.263Z |
5538155 | 5538155 | 20241113022501_6Pqgd | HR000V | 2024-11-14T14:12:57.775Z | 2024-11-21T14:26:21.130Z |
5538143 | 5538143 | 20241113022021_PhgAA | HR000V | 2024-11-14T14:12:55.703Z | 2024-11-21T14:26:21.035Z |
5538113 | 5538113 | 20241113021403_2R2CP | HR000V | 2024-11-14T14:12:51.891Z | 2024-11-21T14:26:20.824Z |
5538088 | 5538088 | 20241113020856_Qi13I | HR000V | 2024-11-14T14:12:50.129Z | 2024-11-21T14:26:20.670Z |
5537926 | 5537926 | 20241113013319_jMbte | HR000V | 2024-11-14T14:12:38.161Z | 2024-11-21T14:26:17.280Z |
5537804 | 5537804 | 20241113004239_QWH37 | HR000V | 2024-11-14T14:12:31.103Z | 2024-11-21T14:26:16.343Z |
5537768 | 5537768 | 20241113003217_NdfJZ | HR000V | 2024-11-14T14:12:29.262Z | 2024-11-21T14:26:15.878Z |
5537716 | 5537716 | 20241113001756_21i7q | HR000V | 2024-11-14T14:12:26.220Z | 2024-11-21T14:26:15.492Z |
5537685 | 5537685 | 20241113000635_DVG5d | HR000V | 2024-11-14T14:12:24.428Z | 2024-11-21T14:26:15.233Z |
5537681 | 5537681 | 20241113000321_tb5T8 | HR000V | 2024-11-14T14:12:24.106Z | 2024-11-21T14:26:15.206Z |
5537666 | 5537666 | 20241113000150_f5hXZ | HR000V | 2024-11-14T14:12:23.615Z | 2024-11-21T14:26:15.182Z |
5537581 | 5537581 | 20241112234549_d4G2z | HR000V | 2024-11-14T14:12:12.380Z | 2024-11-21T14:26:14.760Z |
5537540 | 5537540 | 20241112233621_2Qemr | HR000V | 2024-11-14T14:12:06.817Z | 2024-11-21T14:26:14.091Z |
5537487 | 5537487 | 20241112232338_8nYNX | HR000V | 2024-11-14T14:11:57.112Z | 2024-11-21T14:26:13.497Z |
5537358 | 5537358 | 20241112222127_nIMn6 | HR000V | 2024-11-14T14:11:40.262Z | 2024-11-21T14:26:11.480Z |
5537339 | 5537339 | 20241112221231_YCFnw | HR000V | 2024-11-14T14:11:39.068Z | 2024-11-21T14:26:11.350Z |
5537335 | 5537335 | 20241112221102_d2I32 | HR000V | 2024-11-14T14:11:38.067Z | 2024-11-21T14:26:11.302Z |
5537281 | 5537281 | 20241112215306_yuoxh | HR000V | 2024-11-14T14:11:30.955Z | 2024-11-21T14:26:10.824Z |
5537229 | 5537229 | 20241112211606_3WRRR | HR000V | 2024-11-14T14:11:22.317Z | 2024-11-21T14:26:10.197Z |
5537159 | 5537159 | 20241112204025_wADp9 | HR000V | 2024-11-14T14:11:09.699Z | 2024-11-21T14:26:09.407Z |
5537113 | 5537113 | 20241112202925_YT2oC | HR000V | 2024-11-14T14:11:03.842Z | 2024-11-21T14:26:08.933Z |
5532147 | 5532147 | 20241112044205_UAQ8A | HR000V | 2024-11-13T14:16:22.398Z | 2024-11-20T14:26:20.311Z |
5532080 | 5532080 | 20241112043514_JvYWE | HR000V | 2024-11-13T14:16:16.408Z | 2024-11-20T14:26:18.398Z |
5532073 | 5532073 | 20241112043446_wN31Y | HR000V | 2024-11-13T14:16:15.742Z | 2024-11-20T14:26:18.383Z |
5531648 | 5531648 | 20241112035724_v1HKF | HR000V | 2024-11-13T14:15:48.703Z | 2024-11-20T14:26:13.006Z |
5531237 | 5531237 | 20241112032425_xuSfE | HR000V | 2024-11-13T14:15:31.029Z | 2024-11-20T14:26:08.867Z |
5531226 | 5531226 | 20241112032356_LDlUj | HR000V | 2024-11-13T14:15:28.179Z | 2024-11-20T14:26:08.685Z |
5530766 | 5530766 | 20241112024508_0kA6B | HR000V | 2024-11-13T14:14:36.157Z | 2024-11-20T14:26:03.193Z |
5530608 | 5530608 | 20241112023338_zVS9n | HR000V | 2024-11-13T14:14:24.769Z | 2024-11-20T14:26:01.995Z |
5530516 | 5530516 | 20241112022548_ZVgZH | HR000V | 2024-11-13T14:14:19.903Z | 2024-11-20T14:26:00.993Z |
5530437 | 5530437 | 20241112021728_e3FBa | HR000V | 2024-11-13T14:14:15.542Z | 2024-11-20T14:26:00.134Z |
5530023 | 5530023 | 20241112013725_HL2uQ | HR000V | 2024-11-13T14:13:41.199Z | 2024-11-20T14:25:53.094Z |
5529952 | 5529952 | 20241112012856_XYRzd | HR000V | 2024-11-13T14:13:28.772Z | 2024-11-20T14:25:51.509Z |
5529893 | 5529893 | 20241112011826_PR1Vk | HR000V | 2024-11-13T14:13:19.867Z | 2024-11-20T14:25:50.506Z |
5529382 | 5529382 | 20241112000925_fB2jh | HR000V | 2024-11-13T14:12:29.910Z | 2024-11-20T14:25:43.927Z |
5529151 | 5529151 | 20241111233833_vnUuz | HR000V | 2024-11-13T14:12:09.301Z | 2024-11-20T14:25:40.777Z |
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);