participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,520 rows where station_code = "HR0006" 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 |
---|---|---|---|---|---|
5135742 | 5135742 | 20240918190746_JZBKu | HR0006 | 2024-09-20T12:00:23.266Z | 2024-09-20T12:06:54.603Z |
5131933 | 5131933 | 20240915222005_ZJygh | HR0006 | 2024-09-19T12:15:35.102Z | 2024-09-20T12:12:50.455Z |
5131844 | 5131844 | 20240915214231_r6UOF | HR0006 | 2024-09-19T12:15:28.962Z | 2024-09-20T12:12:47.145Z |
5131832 | 5131832 | 20240915212830_Our42 | HR0006 | 2024-09-19T12:15:26.767Z | 2024-09-20T12:12:46.457Z |
5131795 | 5131795 | 20240915211534_mLMJT | HR0006 | 2024-09-19T12:15:21.385Z | 2024-09-20T12:12:44.429Z |
5131714 | 5131714 | 20240915205439_3eLMQ | HR0006 | 2024-09-19T12:15:17.590Z | 2024-09-20T12:12:39.751Z |
5131595 | 5131595 | 20240915202437_R4ELM | HR0006 | 2024-09-19T12:15:10.889Z | 2024-09-20T12:12:34.558Z |
5131586 | 5131586 | 20240915202121_03tH3 | HR0006 | 2024-09-19T12:15:10.357Z | 2024-09-20T12:12:34.135Z |
5131571 | 5131571 | 20240915201850_yxff3 | HR0006 | 2024-09-19T12:15:09.795Z | 2024-09-20T12:12:33.143Z |
5131433 | 5131433 | 20240915195151_IznqO | HR0006 | 2024-09-19T12:15:03.410Z | 2024-09-20T12:12:28.203Z |
5125413 | 5125413 | 20240918023141_o15n8 | HR0006 | 2024-09-19T12:03:11.594Z | 2024-09-20T12:08:15.762Z |
5125356 | 5125356 | 20240918021852_fR3kF | HR0006 | 2024-09-19T12:03:03.656Z | 2024-09-20T12:08:11.275Z |
5125065 | 5125065 | 20240917235532_CgmR2 | HR0006 | 2024-09-19T12:02:06.750Z | 2024-09-20T12:07:42.518Z |
5125041 | 5125041 | 20240917234906_5SN0G | HR0006 | 2024-09-19T12:02:00.873Z | 2024-09-20T12:07:38.721Z |
5124936 | 5124936 | 20240917225455_WshGX | HR0006 | 2024-09-19T12:01:49.628Z | 2024-09-20T12:07:32.749Z |
5124934 | 5124934 | 20240917225346_GHNyc | HR0006 | 2024-09-19T12:01:49.246Z | 2024-09-20T12:07:32.615Z |
5124736 | 5124736 | 20240917215633_B7U86 | HR0006 | 2024-09-19T12:01:29.526Z | 2024-09-20T12:07:23.310Z |
5124564 | 5124564 | 20240917211012_uBdaE | HR0006 | 2024-09-19T12:01:08.454Z | 2024-09-20T12:07:15.382Z |
5124424 | 5124424 | 20240917200918_5IqRO | HR0006 | 2024-09-19T12:00:49.554Z | 2024-09-20T12:07:02.743Z |
5124380 | 5124380 | 20240917194649_PPIZL | HR0006 | 2024-09-19T12:00:41.476Z | 2024-09-20T12:07:01.203Z |
5124256 | 5124256 | 20240917182928_nkhHp | HR0006 | 2024-09-19T12:00:20.815Z | 2024-09-20T12:06:57.330Z |
5080106 | 5080106 | 20240911033209_g8j2M | HR0006 | 2024-09-15T12:16:50.106Z | 2024-09-19T12:21:43.092Z |
5079580 | 5079580 | 20240911030428_0POZ3 | HR0006 | 2024-09-15T12:16:26.853Z | 2024-09-19T12:21:42.433Z |
5079154 | 5079154 | 20240911023540_M1XMJ | HR0006 | 2024-09-15T12:16:08.858Z | 2024-09-19T12:21:41.183Z |
5078574 | 5078574 | 20240911020416_SNR2C | HR0006 | 2024-09-15T12:15:44.465Z | 2024-09-19T12:21:40.567Z |
5078473 | 5078473 | 20240911020018_UkgPa | HR0006 | 2024-09-15T12:15:40.169Z | 2024-09-19T12:21:40.434Z |
5078452 | 5078452 | 20240911015809_11uZ8 | HR0006 | 2024-09-15T12:15:39.164Z | 2024-09-19T12:21:40.421Z |
5077189 | 5077189 | 20240911003121_txnmV | HR0006 | 2024-09-15T12:14:28.943Z | 2024-09-19T12:21:38.477Z |
5076209 | 5076209 | 20240910231329_TLPzM | HR0006 | 2024-09-15T12:13:22.660Z | 2024-09-19T12:21:36.616Z |
5076123 | 5076123 | 20240910230809_e9Bx7 | HR0006 | 2024-09-15T12:13:18.586Z | 2024-09-19T12:21:36.461Z |
5072983 | 5072983 | 20240911205109_AwkLV | HR0006 | 2024-09-15T12:06:23.655Z | 2024-09-20T12:21:31.062Z |
5070110 | 5070110 | 20240910223445_JgDBb | HR0006 | 2024-09-14T12:20:15.121Z | 2024-09-19T12:21:35.782Z |
5069982 | 5069982 | 20240910222048_SG3ME | HR0006 | 2024-09-14T12:20:10.718Z | 2024-09-19T12:21:35.562Z |
5065270 | 5065270 | 20240910033324_FtGYX | HR0006 | 2024-09-14T12:16:51.777Z | 2024-09-18T12:15:18.895Z |
5065005 | 5065005 | 20240910025033_H2wuY | HR0006 | 2024-09-14T12:16:17.054Z | 2024-09-18T12:15:18.135Z |
5064506 | 5064506 | 20240910012601_9H4PF | HR0006 | 2024-09-14T12:15:34.574Z | 2024-09-18T12:15:16.791Z |
5064406 | 5064406 | 20240910010007_i99tk | HR0006 | 2024-09-14T12:15:25.161Z | 2024-09-18T12:15:16.584Z |
5063931 | 5063931 | 20240909230055_uBVVr | HR0006 | 2024-09-14T12:14:29.753Z | 2024-09-18T12:15:14.910Z |
5063766 | 5063766 | 20240909223748_9AyYh | HR0006 | 2024-09-14T12:14:21.125Z | 2024-09-18T12:15:14.727Z |
5063584 | 5063584 | 20240909214929_2dbm8 | HR0006 | 2024-09-14T12:14:07.575Z | 2024-09-18T12:15:14.242Z |
5062939 | 5062939 | 20240909191645_TtgRL | HR0006 | 2024-09-14T12:13:05.817Z | 2024-09-18T12:15:12.588Z |
5059653 | 5059653 | 20240910182556_gixlx | HR0006 | 2024-09-14T12:06:40.766Z | 2024-09-19T12:21:31.001Z |
5054531 | 5054531 | 20240908030520_pmWzL | HR0006 | 2024-09-13T12:16:46.132Z | 2024-09-16T12:21:15.922Z |
5054251 | 5054251 | 20240908023229_8ENhl | HR0006 | 2024-09-13T12:16:35.444Z | 2024-09-16T12:21:14.681Z |
5054220 | 5054220 | 20240908022957_QdHxq | HR0006 | 2024-09-13T12:16:34.373Z | 2024-09-16T12:21:14.540Z |
5054175 | 5054175 | 20240908022027_2Av5A | HR0006 | 2024-09-13T12:16:32.406Z | 2024-09-16T12:21:14.199Z |
5053979 | 5053979 | 20240908015705_sXggr | HR0006 | 2024-09-13T12:16:25.092Z | 2024-09-16T12:21:13.411Z |
5053672 | 5053672 | 20240908011434_ly38z | HR0006 | 2024-09-13T12:16:13.170Z | 2024-09-16T12:21:12.393Z |
5053604 | 5053604 | 20240908010611_7T5GU | HR0006 | 2024-09-13T12:16:10.148Z | 2024-09-16T12:21:12.160Z |
5053332 | 5053332 | 20240908001220_dBCkz | HR0006 | 2024-09-13T12:15:59.160Z | 2024-09-16T12:21:10.342Z |
5053257 | 5053257 | 20240907235847_zfgKG | HR0006 | 2024-09-13T12:15:55.485Z | 2024-09-16T12:21:10.165Z |
5053127 | 5053127 | 20240907233044_3395r | HR0006 | 2024-09-13T12:15:47.712Z | 2024-09-16T12:21:09.574Z |
5053028 | 5053028 | 20240907230628_QjL38 | HR0006 | 2024-09-13T12:15:42.482Z | 2024-09-16T12:21:09.025Z |
5052920 | 5052920 | 20240907223658_TcDNh | HR0006 | 2024-09-13T12:15:35.940Z | 2024-09-16T12:21:08.602Z |
5052915 | 5052915 | 20240907223510_yMfyD | HR0006 | 2024-09-13T12:15:35.678Z | 2024-09-16T12:21:08.587Z |
5052798 | 5052798 | 20240907220935_x37s0 | HR0006 | 2024-09-13T12:15:28.483Z | 2024-09-16T12:21:07.731Z |
5052761 | 5052761 | 20240907215712_ReoIk | HR0006 | 2024-09-13T12:15:25.688Z | 2024-09-16T12:21:07.599Z |
5052718 | 5052718 | 20240907214533_PknDx | HR0006 | 2024-09-13T12:15:22.972Z | 2024-09-16T12:21:07.362Z |
5052714 | 5052714 | 20240907214344_z0mz0 | HR0006 | 2024-09-13T12:15:22.655Z | 2024-09-16T12:21:07.349Z |
5052677 | 5052677 | 20240907213235_Hpw3T | HR0006 | 2024-09-13T12:15:19.095Z | 2024-09-16T12:21:07.050Z |
5052543 | 5052543 | 20240907210128_qzg66 | HR0006 | 2024-09-13T12:15:13.426Z | 2024-09-16T12:21:06.201Z |
5052359 | 5052359 | 20240907202650_u2SX1 | HR0006 | 2024-09-13T12:15:05.498Z | 2024-09-16T12:21:05.241Z |
5052320 | 5052320 | 20240907201844_14Uas | HR0006 | 2024-09-13T12:15:04.116Z | 2024-09-16T12:21:05.113Z |
5052305 | 5052305 | 20240907201449_bBui4 | HR0006 | 2024-09-13T12:15:03.636Z | 2024-09-16T12:21:05.096Z |
5052139 | 5052139 | 20240907194446_FcBu3 | HR0006 | 2024-09-13T12:14:58.425Z | 2024-09-16T12:21:03.974Z |
5052005 | 5052005 | 20240907192532_cq9SC | HR0006 | 2024-09-13T12:14:53.087Z | 2024-09-16T12:21:03.086Z |
5051861 | 5051861 | 20240907185548_Umaqq | HR0006 | 2024-09-13T12:14:39.463Z | 2024-09-16T12:21:02.323Z |
5040193 | 5040193 | 20240906031656_jE734 | HR0006 | 2024-09-12T12:16:01.615Z | 2024-09-14T12:23:08.143Z |
5039866 | 5039866 | 20240906021204_asWYO | HR0006 | 2024-09-12T12:15:48.051Z | 2024-09-14T12:23:05.663Z |
5039812 | 5039812 | 20240906020505_LQsjm | HR0006 | 2024-09-12T12:15:45.941Z | 2024-09-14T12:23:04.942Z |
5032687 | 5032687 | 20240907013245_SFUTf | HR0006 | 2024-09-12T12:07:51.642Z | 2024-09-15T12:21:27.471Z |
5032563 | 5032563 | 20240907011536_3ogHk | HR0006 | 2024-09-12T12:07:40.520Z | 2024-09-15T12:21:26.787Z |
5032538 | 5032538 | 20240907011254_49qbT | HR0006 | 2024-09-12T12:07:33.801Z | 2024-09-15T12:21:26.729Z |
5032487 | 5032487 | 20240907010747_g9GWB | HR0006 | 2024-09-12T12:07:23.976Z | 2024-09-15T12:21:26.583Z |
5032310 | 5032310 | 20240907004354_iR7hk | HR0006 | 2024-09-12T12:07:06.243Z | 2024-09-15T12:21:26.006Z |
5032253 | 5032253 | 20240907003556_v8WEl | HR0006 | 2024-09-12T12:06:55.009Z | 2024-09-15T12:21:25.719Z |
5031848 | 5031848 | 20240906233154_Fiz3V | HR0006 | 2024-09-12T12:05:56.234Z | 2024-09-15T12:21:24.432Z |
5031772 | 5031772 | 20240906231558_Stvqr | HR0006 | 2024-09-12T12:05:46.572Z | 2024-09-15T12:21:24.248Z |
5031674 | 5031674 | 20240906225541_YuYT1 | HR0006 | 2024-09-12T12:05:24.314Z | 2024-09-15T12:21:23.864Z |
5031658 | 5031658 | 20240906225229_MgC6A | HR0006 | 2024-09-12T12:05:22.425Z | 2024-09-15T12:21:23.509Z |
5031228 | 5031228 | 20240906205649_jglUb | HR0006 | 2024-09-12T12:04:20.418Z | 2024-09-15T12:21:21.779Z |
5031175 | 5031175 | 20240906204521_C8EAe | HR0006 | 2024-09-12T12:04:10.012Z | 2024-09-15T12:21:21.631Z |
5031160 | 5031160 | 20240906204355_DKEMr | HR0006 | 2024-09-12T12:04:06.099Z | 2024-09-15T12:21:21.615Z |
5031131 | 5031131 | 20240906203442_zmzfh | HR0006 | 2024-09-12T12:04:00.196Z | 2024-09-15T12:21:21.521Z |
5031099 | 5031099 | 20240906202625_NYVMa | HR0006 | 2024-09-12T12:03:54.729Z | 2024-09-15T12:21:21.429Z |
5030995 | 5030995 | 20240906195346_znnUD | HR0006 | 2024-09-12T12:03:40.631Z | 2024-09-15T12:21:20.646Z |
5030891 | 5030891 | 20240906192010_kdNxO | HR0006 | 2024-09-12T12:03:20.603Z | 2024-09-15T12:21:20.299Z |
5030875 | 5030875 | 20240906191811_5Iyb2 | HR0006 | 2024-09-12T12:03:18.799Z | 2024-09-15T12:21:20.249Z |
5030842 | 5030842 | 20240906190456_gSNYa | HR0006 | 2024-09-12T12:03:13.686Z | 2024-09-15T12:21:20.141Z |
5030832 | 5030832 | 20240906190028_RqV4t | HR0006 | 2024-09-12T12:03:11.731Z | 2024-09-15T12:21:19.989Z |
5030823 | 5030823 | 20240906185410_HRbn0 | HR0006 | 2024-09-12T12:03:10.479Z | 2024-09-15T12:21:19.966Z |
5030806 | 5030806 | 20240906184708_jBbS3 | HR0006 | 2024-09-12T12:03:08.092Z | 2024-09-15T12:21:19.834Z |
5030783 | 5030783 | 20240906183650_cN5Xe | HR0006 | 2024-09-12T12:03:04.568Z | 2024-09-15T12:21:19.692Z |
5030774 | 5030774 | 20240906183520_dra27 | HR0006 | 2024-09-12T12:03:03.545Z | 2024-09-15T12:21:19.626Z |
5026438 | 5026438 | 20240905032943_u2wEM | HR0006 | 2024-09-11T12:12:29.954Z | 2024-09-13T12:19:58.258Z |
5026146 | 5026146 | 20240905022318_xZY4e | HR0006 | 2024-09-11T12:11:58.918Z | 2024-09-13T12:19:56.958Z |
5026120 | 5026120 | 20240905022036_MHzxZ | HR0006 | 2024-09-11T12:11:56.901Z | 2024-09-13T12:19:56.896Z |
5026018 | 5026018 | 20240905020135_Lr39s | HR0006 | 2024-09-11T12:11:44.909Z | 2024-09-13T12:19:56.577Z |
5026011 | 5026011 | 20240905015816_Zdtyb | HR0006 | 2024-09-11T12:11:43.943Z | 2024-09-13T12:19:56.574Z |
5025909 | 5025909 | 20240905013933_YXui7 | HR0006 | 2024-09-11T12:11:30.005Z | 2024-09-13T12:19:56.169Z |
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);