participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,355 rows where station_code = "HR0018" 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 |
---|---|---|---|---|---|
5064746 | 5064746 | 20240910015540_nSpFk | HR0018 | 2024-09-14T12:15:59.064Z | 2024-09-18T12:15:17.153Z |
5064713 | 5064713 | 20240910015002_BK1Gl | HR0018 | 2024-09-14T12:15:57.286Z | 2024-09-18T12:15:17.058Z |
5064702 | 5064702 | 20240910014744_8ygoQ | HR0018 | 2024-09-14T12:15:55.834Z | 2024-09-18T12:15:16.952Z |
5064672 | 5064672 | 20240910014553_3ERAc | HR0018 | 2024-09-14T12:15:54.549Z | 2024-09-18T12:15:16.932Z |
5064327 | 5064327 | 20240910004938_COVBJ | HR0018 | 2024-09-14T12:15:17.758Z | 2024-09-18T12:15:16.142Z |
5064163 | 5064163 | 20240910001422_1Fxxp | HR0018 | 2024-09-14T12:15:01.530Z | 2024-09-18T12:15:15.645Z |
5064113 | 5064113 | 20240910000108_HfwNY | HR0018 | 2024-09-14T12:14:55.698Z | 2024-09-18T12:15:15.544Z |
5033545 | 5033545 | 20240907030839_CXbz9 | HR0018 | 2024-09-12T12:09:38.916Z | 2024-09-15T12:21:30.463Z |
5033253 | 5033253 | 20240907024148_WNf7y | HR0018 | 2024-09-12T12:09:02.778Z | 2024-09-15T12:21:29.375Z |
5033208 | 5033208 | 20240907023818_o0GsM | HR0018 | 2024-09-12T12:08:57.959Z | 2024-09-15T12:21:29.201Z |
5032787 | 5032787 | 20240907014839_3EE7y | HR0018 | 2024-09-12T12:08:01.507Z | 2024-09-15T12:21:27.839Z |
5031841 | 5031841 | 20240906233110_poNkn | HR0018 | 2024-09-12T12:05:54.824Z | 2024-09-15T12:21:24.410Z |
5031681 | 5031681 | 20240906225730_OR5hO | HR0018 | 2024-09-12T12:05:25.191Z | 2024-09-15T12:21:23.877Z |
5031652 | 5031652 | 20240906225127_jIGMb | HR0018 | 2024-09-12T12:05:20.718Z | 2024-09-15T12:21:23.504Z |
5031616 | 5031616 | 20240906224345_rVqQc | HR0018 | 2024-09-12T12:05:16.972Z | 2024-09-15T12:21:23.459Z |
5019175 | 5019175 | 20240904220424_1vx48 | HR0018 | 2024-09-10T12:12:17.208Z | 2024-09-13T12:19:50.864Z |
5019028 | 5019028 | 20240904212800_xbiwF | HR0018 | 2024-09-10T12:11:56.430Z | 2024-09-13T12:19:50.166Z |
5000385 | 5000385 | 20240902020651_sH1FZ | HR0018 | 2024-09-08T12:15:22.431Z | 2024-09-10T12:19:26.832Z |
5000366 | 5000366 | 20240902020517_4AYp3 | HR0018 | 2024-09-08T12:15:21.662Z | 2024-09-10T12:19:26.823Z |
4998070 | 4998070 | 20240903021050_Hn20Y | HR0018 | 2024-09-08T12:07:10.440Z | 2024-09-11T12:21:10.873Z |
4997746 | 4997746 | 20240903012056_P8nRI | HR0018 | 2024-09-08T12:06:46.033Z | 2024-09-11T12:21:08.131Z |
4997743 | 4997743 | 20240903012045_TFLJE | HR0018 | 2024-09-08T12:06:45.871Z | 2024-09-11T12:21:08.114Z |
4997361 | 4997361 | 20240902235923_kiipg | HR0018 | 2024-09-08T12:06:07.902Z | 2024-09-11T12:21:03.756Z |
4997350 | 4997350 | 20240902235818_yN0cQ | HR0018 | 2024-09-08T12:06:07.090Z | 2024-09-11T12:21:03.597Z |
4997283 | 4997283 | 20240902234700_13u8I | HR0018 | 2024-09-08T12:05:59.569Z | 2024-09-11T12:21:02.980Z |
4997223 | 4997223 | 20240902232655_N6V8P | HR0018 | 2024-09-08T12:05:55.108Z | 2024-09-11T12:21:02.287Z |
4991645 | 4991645 | 20240901025501_2D8bv | HR0018 | 2024-09-07T12:12:17.133Z | 2024-09-09T12:27:14.587Z |
4991147 | 4991147 | 20240901020228_gjadg | HR0018 | 2024-09-07T12:11:36.800Z | 2024-09-09T12:27:01.115Z |
4991005 | 4991005 | 20240901014625_4XRIy | HR0018 | 2024-09-07T12:11:26.689Z | 2024-09-09T12:26:57.600Z |
4990644 | 4990644 | 20240901004925_tY7BP | HR0018 | 2024-09-07T12:10:52.430Z | 2024-09-09T12:26:26.072Z |
4990273 | 4990273 | 20240831235044_oyS9V | HR0018 | 2024-09-07T12:10:17.802Z | 2024-09-09T12:26:15.235Z |
4990077 | 4990077 | 20240831232129_oNSnr | HR0018 | 2024-09-07T12:09:59.206Z | 2024-09-09T12:26:10.075Z |
4990051 | 4990051 | 20240831231756_36T9I | HR0018 | 2024-09-07T12:09:57.027Z | 2024-09-09T12:26:09.468Z |
4990028 | 4990028 | 20240831231722_aA1Ht | HR0018 | 2024-09-07T12:09:56.065Z | 2024-09-09T12:26:09.050Z |
4989295 | 4989295 | 20240901230951_UWxAA | HR0018 | 2024-09-07T12:08:46.098Z | 2024-09-10T12:19:17.283Z |
4989253 | 4989253 | 20240901230131_oBNKN | HR0018 | 2024-09-07T12:08:41.759Z | 2024-09-10T12:19:17.210Z |
4989221 | 4989221 | 20240901225739_3Cxix | HR0018 | 2024-09-07T12:08:39.827Z | 2024-09-10T12:19:17.077Z |
4988823 | 4988823 | 20240901213839_gxzjU | HR0018 | 2024-09-07T12:07:59.220Z | 2024-09-10T12:19:15.608Z |
4987937 | 4987937 | 20240901192217_AqtDs | HR0018 | 2024-09-07T12:06:30.553Z | 2024-09-10T12:19:11.874Z |
4987822 | 4987822 | 20240901190257_Z6dt2 | HR0018 | 2024-09-07T12:06:22.131Z | 2024-09-10T12:19:11.479Z |
4911216 | 4911216 | 20240809193550_g2M4u | HR0018 | 2024-08-29T12:07:08.711Z | 2024-09-02T12:21:26.075Z |
4891759 | 4891759 | 20240809013455_jTeBn | HR0018 | 2024-08-28T12:09:21.902Z | 2024-08-30T12:21:24.258Z |
4891720 | 4891720 | 20240809013216_OGZov | HR0018 | 2024-08-28T12:09:18.911Z | 2024-08-30T12:21:23.130Z |
4891679 | 4891679 | 20240809012652_WwhR7 | HR0018 | 2024-08-28T12:09:16.590Z | 2024-08-30T12:21:21.678Z |
4889263 | 4889263 | 20240808203050_hNIcR | HR0018 | 2024-08-28T12:05:52.550Z | 2024-08-30T12:19:01.254Z |
4882819 | 4882819 | 20240807022319_CDwSY | HR0018 | 2024-08-20T12:14:41.206Z | 2024-08-27T12:15:40.648Z |
4882193 | 4882193 | 20240807020338_y0eQ2 | HR0018 | 2024-08-20T12:14:26.478Z | 2024-08-27T12:15:27.075Z |
4881565 | 4881565 | 20240807014745_jBWyG | HR0018 | 2024-08-20T12:14:14.941Z | 2024-08-27T12:15:17.654Z |
4881130 | 4881130 | 20240807013728_kmLIB | HR0018 | 2024-08-20T12:13:48.240Z | 2024-08-27T12:15:02.294Z |
4880541 | 4880541 | 20240807012225_a5LIW | HR0018 | 2024-08-20T12:13:28.543Z | 2024-08-27T12:14:45.725Z |
4879423 | 4879423 | 20240807005459_gJUiX | HR0018 | 2024-08-20T12:12:51.515Z | 2024-08-27T12:14:13.189Z |
4879343 | 4879343 | 20240807005139_PdTQz | HR0018 | 2024-08-20T12:12:48.716Z | 2024-08-27T12:14:10.667Z |
4879286 | 4879286 | 20240807005057_BwSqQ | HR0018 | 2024-08-20T12:12:47.838Z | 2024-08-27T12:14:09.903Z |
4877898 | 4877898 | 20240807001510_IH74C | HR0018 | 2024-08-19T12:13:59.431Z | 2024-08-27T12:13:24.783Z |
4876638 | 4876638 | 20240806234352_UpOoE | HR0018 | 2024-08-19T12:12:57.665Z | 2024-08-27T12:12:46.550Z |
4875715 | 4875715 | 20240806232329_fcSj0 | HR0018 | 2024-08-19T12:12:18.151Z | 2024-08-27T12:12:21.295Z |
4875373 | 4875373 | 20240806231400_xT9ax | HR0018 | 2024-08-19T12:12:08.268Z | 2024-08-27T12:12:14.332Z |
4873812 | 4873812 | 20240806223348_rmJg0 | HR0018 | 2024-08-19T12:11:07.367Z | 2024-08-27T12:11:22.818Z |
4872780 | 4872780 | 20240806215842_VK2zk | HR0018 | 2024-08-19T12:10:20.871Z | 2024-08-27T12:10:47.932Z |
4872394 | 4872394 | 20240806214330_lzVQG | HR0018 | 2024-08-19T12:10:01.242Z | 2024-08-27T12:10:30.976Z |
4872032 | 4872032 | 20240806212635_oYrxQ | HR0018 | 2024-08-19T12:09:45.691Z | 2024-08-27T12:10:15.252Z |
4871921 | 4871921 | 20240806211919_1RMa0 | HR0018 | 2024-08-19T12:09:32.246Z | 2024-08-27T12:10:10.360Z |
4871896 | 4871896 | 20240806211726_0t0Sz | HR0018 | 2024-08-19T12:09:31.169Z | 2024-08-27T12:10:08.933Z |
4871843 | 4871843 | 20240806211421_erqH3 | HR0018 | 2024-08-19T12:09:29.492Z | 2024-08-27T12:10:05.104Z |
4871697 | 4871697 | 20240806210415_JcfkS | HR0018 | 2024-08-19T12:09:21.342Z | 2024-08-27T12:09:57.930Z |
4871647 | 4871647 | 20240806205819_qvO4s | HR0018 | 2024-08-19T12:09:18.866Z | 2024-08-27T12:09:56.026Z |
4871296 | 4871296 | 20240806200001_nMyc7 | HR0018 | 2024-08-19T12:08:45.133Z | 2024-08-27T12:09:31.674Z |
4806442 | 4806442 | 20240803020741_5MC3Q | HR0018 | 2024-08-12T12:18:56.161Z | 2024-08-13T12:17:41.306Z |
4806393 | 4806393 | 20240803015912_UloJM | HR0018 | 2024-08-12T12:18:52.199Z | 2024-08-13T12:17:39.815Z |
4806114 | 4806114 | 20240803012906_MEzWe | HR0018 | 2024-08-12T12:18:25.786Z | 2024-08-13T12:17:31.589Z |
4805685 | 4805685 | 20240803003904_S4f4b | HR0018 | 2024-08-12T12:18:03.389Z | 2024-08-13T12:17:21.239Z |
4805655 | 4805655 | 20240803003709_ebPhq | HR0018 | 2024-08-12T12:18:01.523Z | 2024-08-13T12:17:20.250Z |
4805607 | 4805607 | 20240803003236_9dCu7 | HR0018 | 2024-08-12T12:17:59.320Z | 2024-08-13T12:17:18.919Z |
4805454 | 4805454 | 20240803001239_9zA4n | HR0018 | 2024-08-12T12:17:51.412Z | 2024-08-13T12:17:15.406Z |
4805387 | 4805387 | 20240803000539_8bDgq | HR0018 | 2024-08-12T12:17:48.356Z | 2024-08-13T12:17:14.323Z |
4805358 | 4805358 | 20240803000336_hqNj8 | HR0018 | 2024-08-12T12:17:46.622Z | 2024-08-13T12:17:14.001Z |
4805322 | 4805322 | 20240802235838_ogW8v | HR0018 | 2024-08-12T12:17:41.851Z | 2024-08-13T12:17:12.623Z |
4805299 | 4805299 | 20240802235559_37atc | HR0018 | 2024-08-12T12:17:39.436Z | 2024-08-13T12:17:11.472Z |
4780402 | 4780402 | 20240801021543_FIEX9 | HR0018 | 2024-08-07T12:15:01.793Z | 2024-08-10T12:21:52.942Z |
4780388 | 4780388 | 20240801021441_9BX7I | HR0018 | 2024-08-07T12:15:01.253Z | 2024-08-10T12:21:52.558Z |
4780283 | 4780283 | 20240801020417_hhnft | HR0018 | 2024-08-07T12:14:57.001Z | 2024-08-10T12:21:50.614Z |
4780067 | 4780067 | 20240801014317_XEe1z | HR0018 | 2024-08-07T12:14:48.041Z | 2024-08-10T12:21:45.739Z |
4779812 | 4779812 | 20240801011724_2eC30 | HR0018 | 2024-08-07T12:14:42.451Z | 2024-08-10T12:21:40.179Z |
4778806 | 4778806 | 20240731233649_9U2cj | HR0018 | 2024-08-07T12:14:01.446Z | 2024-08-10T12:21:15.280Z |
4778795 | 4778795 | 20240731233555_Vl4jq | HR0018 | 2024-08-07T12:14:01.089Z | 2024-08-10T12:21:15.171Z |
4778775 | 4778775 | 20240731233454_m6cFU | HR0018 | 2024-08-07T12:14:00.401Z | 2024-08-10T12:21:14.674Z |
4778684 | 4778684 | 20240731232635_2ftB6 | HR0018 | 2024-08-07T12:13:56.004Z | 2024-08-10T12:21:12.202Z |
4778389 | 4778389 | 20240731224934_dDB8o | HR0018 | 2024-08-07T12:13:43.480Z | 2024-08-10T12:21:04.953Z |
4778217 | 4778217 | 20240731222214_J2tru | HR0018 | 2024-08-07T12:13:35.877Z | 2024-08-10T12:21:00.064Z |
4771477 | 4771477 | 20240801022832_2HPCy | HR0018 | 2024-08-07T12:00:27.470Z | 2024-08-11T12:10:43.479Z |
4771409 | 4771409 | 20240801021738_9RGd8 | HR0018 | 2024-08-07T12:00:09.937Z | 2024-08-11T12:10:37.386Z |
4770549 | 4770549 | 20240731003012_2fVi0 | HR0018 | 2024-08-06T12:14:01.724Z | 2024-08-08T12:25:12.247Z |
4770531 | 4770531 | 20240731002854_SWBsI | HR0018 | 2024-08-06T12:14:01.422Z | 2024-08-08T12:25:11.916Z |
4769350 | 4769350 | 20240731202128_Uj02L | HR0018 | 2024-08-06T12:10:46.927Z | 2024-08-10T12:20:32.539Z |
4762229 | 4762229 | 20240731015554_CNnXh | HR0018 | 2024-08-06T12:02:06.113Z | 2024-08-10T12:17:39.580Z |
4762063 | 4762063 | 20240731014705_2Gg7M | HR0018 | 2024-08-06T12:01:51.072Z | 2024-08-10T12:17:35.163Z |
4761948 | 4761948 | 20240731014207_6drAX | HR0018 | 2024-08-06T12:01:22.812Z | 2024-08-10T12:17:30.944Z |
4761234 | 4761234 | 20240731001112_B4fHT | HR0018 | 2024-08-05T12:16:29.584Z | 2024-08-08T12:25:02.169Z |
4761090 | 4761090 | 20240731000547_9L52A | HR0018 | 2024-08-05T12:16:24.759Z | 2024-08-08T12:24:57.775Z |
4760656 | 4760656 | 20240730234650_2JDQB | HR0018 | 2024-08-05T12:16:08.163Z | 2024-08-08T12:24:43.821Z |
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);