home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

2,463 rows where station_code = "HR0017" sorted by created_at descending

✎ View and edit SQL

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
5615561 5615561 20241126025454_k9fm1 HR0017 2024-11-27T14:20:04.331Z 2024-12-04T14:30:03.696Z
5615419 5615419 20241126024648_UmexL HR0017 2024-11-27T14:20:01.335Z 2024-12-04T14:30:03.555Z
5614857 5614857 20241126015954_s41Vh HR0017 2024-11-27T14:19:39.273Z 2024-12-04T14:30:02.926Z
5613082 5613082 20241125230209_Xvs3d HR0017 2024-11-27T14:18:08.162Z 2024-12-04T14:30:01.285Z
5610933 5610933 20241125170805_U36HP HR0017 2024-11-27T14:15:33.330Z 2024-12-04T14:29:56.052Z
5605059 5605059 20241125024328_CBUJa HR0017 2024-11-26T14:18:28.472Z 2024-12-03T14:27:54.398Z
5604836 5604836 20241125013729_Y6qZe HR0017 2024-11-26T14:17:56.111Z 2024-12-03T14:27:53.926Z
5604678 5604678 20241125004206_aCcI9 HR0017 2024-11-26T14:17:35.142Z 2024-12-03T14:27:53.618Z
5604597 5604597 20241125001352_YQztX HR0017 2024-11-26T14:17:23.517Z 2024-12-03T14:27:53.442Z
5604339 5604339 20241124222544_f2y2S HR0017 2024-11-26T14:16:59.632Z 2024-12-03T14:27:52.091Z
5604142 5604142 20241124210240_VKvxK HR0017 2024-11-26T14:16:38.982Z 2024-12-03T14:27:50.430Z
5604013 5604013 20241124194322_zQdDU HR0017 2024-11-26T14:16:07.102Z 2024-12-03T14:27:49.775Z
5603888 5603888 20241124175755_fhCAg HR0017 2024-11-26T14:15:37.076Z 2024-12-03T14:27:48.196Z
5600136 5600136 20241125034959_RW2q3 HR0017 2024-11-26T14:00:36.922Z 2024-12-04T14:29:48.070Z
5600022 5600022 20241125032126_J6WDs HR0017 2024-11-26T14:00:10.783Z 2024-12-04T14:29:47.657Z
5599680 5599680 20241124022115_EmUr8 HR0017 2024-11-25T14:17:18.560Z 2024-12-02T14:29:23.529Z
5598868 5598868 20241123215036_Y8Zo4 HR0017 2024-11-25T14:16:22.561Z 2024-12-02T14:29:20.423Z
5598810 5598810 20241123211118_c2ezc HR0017 2024-11-25T14:16:17.247Z 2024-12-02T14:29:20.307Z
5598766 5598766 20241123202255_yDylR HR0017 2024-11-25T14:16:11.160Z 2024-12-02T14:29:20.159Z
5598594 5598594 20241123164116_I4Eh3 HR0017 2024-11-25T14:15:21.767Z 2024-12-02T14:29:17.797Z
5598580 5598580 20241123163402_8uJYs HR0017 2024-11-25T14:15:18.471Z 2024-12-02T14:29:17.680Z
5592149 5592149 20241123022242_eYxXz HR0017 2024-11-24T14:20:41.859Z 2024-12-01T14:25:26.964Z
5591774 5591774 20241123005257_JOiUP HR0017 2024-11-24T14:20:17.149Z 2024-12-01T14:25:26.116Z
5591268 5591268 20241122221600_UO7Jt HR0017 2024-11-24T14:19:40.583Z 2024-12-01T14:25:25.134Z
5591222 5591222 20241122220233_i3gOr HR0017 2024-11-24T14:19:36.607Z 2024-12-01T14:25:25.050Z
5591161 5591161 20241122214258_mXToD HR0017 2024-11-24T14:19:32.365Z 2024-12-01T14:25:24.966Z
5591144 5591144 20241122213644_R8i49 HR0017 2024-11-24T14:19:29.872Z 2024-12-01T14:25:24.915Z
5589650 5589650 20241122170718_S70Vz HR0017 2024-11-24T14:17:37.209Z 2024-12-01T14:25:21.526Z
5572392 5572392 20241121021728_U1bWT HR0017 2024-11-22T14:18:22.381Z 2024-11-29T14:26:50.076Z
5572134 5572134 20241121013827_alGJE HR0017 2024-11-22T14:18:00.599Z 2024-11-29T14:26:48.394Z
5569973 5569973 20241120181550_a2ec9 HR0017 2024-11-22T14:14:42.409Z 2024-11-29T14:26:37.490Z
5561323 5561323 20241119195649_Fww8W HR0017 2024-11-21T14:13:05.563Z 2024-11-28T14:29:05.824Z
5543923 5543923 20241115043848_XLDh9 HR0017 2024-11-16T14:07:40.505Z 2024-11-23T14:26:22.236Z
5508692 5508692 20241108175006_CLJNS HR0017 2024-11-10T14:11:12.996Z 2024-11-17T14:23:29.277Z
5490179 5490179 20241105213225_ZtLCI HR0017 2024-11-07T14:13:30.662Z 2024-11-14T14:23:18.060Z
5490069 5490069 20241105205143_Cb1pA HR0017 2024-11-07T14:13:08.092Z 2024-11-14T14:23:17.393Z
5489689 5489689 20241105194303_in1pA HR0017 2024-11-07T14:12:35.378Z 2024-11-14T14:23:15.291Z
5489517 5489517 20241105190800_EJK4A HR0017 2024-11-07T14:12:07.483Z 2024-11-14T14:23:13.631Z
5489182 5489182 20241105180307_5bTuq HR0017 2024-11-07T14:11:25.706Z 2024-11-14T14:23:10.808Z
5489072 5489072 20241105174557_yZtJ3 HR0017 2024-11-07T14:11:16.114Z 2024-11-14T14:23:10.258Z
5489036 5489036 20241105174016_yepzs HR0017 2024-11-07T14:11:13.554Z 2024-11-14T14:23:09.740Z
5485152 5485152 20241105041129_pHuW4 HR0017 2024-11-06T14:17:50.574Z 2024-11-13T14:27:40.878Z
5485111 5485111 20241105040511_I5ZlF HR0017 2024-11-06T14:17:46.536Z 2024-11-13T14:27:40.755Z
5484461 5484461 20241105025407_N7JYx HR0017 2024-11-06T14:16:56.171Z 2024-11-13T14:27:38.112Z
5484446 5484446 20241105025059_mo5DD HR0017 2024-11-06T14:16:55.469Z 2024-11-13T14:27:38.088Z
5483972 5483972 20241105015022_TPTNF HR0017 2024-11-06T14:15:59.160Z 2024-11-13T14:27:37.075Z
5483913 5483913 20241105014337_6pCVM HR0017 2024-11-06T14:15:53.003Z 2024-11-13T14:27:37.013Z
5483452 5483452 20241105004311_hH0HB HR0017 2024-11-06T14:15:21.646Z 2024-11-13T14:27:36.297Z
5483340 5483340 20241105002810_zBpMp HR0017 2024-11-06T14:15:00.946Z 2024-11-13T14:27:36.054Z
5483273 5483273 20241105002122_x46OS HR0017 2024-11-06T14:14:51.721Z 2024-11-13T14:27:35.960Z
5483120 5483120 20241105000016_sOlJV HR0017 2024-11-06T14:14:40.929Z 2024-11-13T14:27:35.747Z
5482713 5482713 20241104230629_R0QHf HR0017 2024-11-06T14:13:42.198Z 2024-11-13T14:27:35.056Z
5482659 5482659 20241104225714_4j6U2 HR0017 2024-11-06T14:13:31.861Z 2024-11-13T14:27:34.981Z
5482254 5482254 20241104213814_u4i1b HR0017 2024-11-06T14:12:42.514Z 2024-11-13T14:27:34.197Z
5482099 5482099 20241104210538_GQtTa HR0017 2024-11-06T14:12:23.172Z 2024-11-13T14:27:33.889Z
5482059 5482059 20241104205924_BXhN6 HR0017 2024-11-06T14:12:19.494Z 2024-11-13T14:27:33.805Z
5481914 5481914 20241104201825_5UwYv HR0017 2024-11-06T14:11:50.325Z 2024-11-13T14:27:33.445Z
5478246 5478246 20241104034100_ZabR2 HR0017 2024-11-05T14:18:06.354Z 2024-11-12T14:28:14.722Z
5478190 5478190 20241104033350_iTw7x HR0017 2024-11-05T14:18:03.066Z 2024-11-12T14:28:14.541Z
5468729 5468729 20241103013503_Q2Ua2 HR0017 2024-11-04T14:14:58.685Z 2024-11-11T14:22:55.256Z
5461495 5461495 20241101191840_8Qy36 HR0017 2024-11-03T14:15:50.627Z 2024-11-10T14:26:28.950Z
5461365 5461365 20241101182407_KncWo HR0017 2024-11-03T14:15:20.402Z 2024-11-10T14:26:28.268Z
5454512 5454512 20241031043248_PWF2U HR0017 2024-11-02T12:23:09.192Z 2024-11-08T14:23:23.440Z
5453388 5453388 20241031020815_4Wjtg HR0017 2024-11-02T12:22:32.885Z 2024-11-08T14:23:17.230Z
5453352 5453352 20241031020439_9usEk HR0017 2024-11-02T12:22:32.252Z 2024-11-08T14:23:16.928Z
5453041 5453041 20241031012910_oKLIu HR0017 2024-11-02T12:22:24.704Z 2024-11-08T14:23:15.783Z
5451845 5451845 20241101011424_n4BrL HR0017 2024-11-02T12:18:01.264Z 2024-11-09T14:24:26.201Z
5451539 5451539 20241101001207_memn2 HR0017 2024-11-02T12:17:28.658Z 2024-11-09T14:24:24.069Z
5451192 5451192 20241031230241_4plvI HR0017 2024-11-02T12:16:42.313Z 2024-11-09T14:24:22.144Z
5451174 5451174 20241031225524_vxM3U HR0017 2024-11-02T12:16:40.909Z 2024-11-09T14:24:22.074Z
5450853 5450853 20241031212154_KcPuf HR0017 2024-11-02T12:16:04.548Z 2024-11-09T14:24:19.374Z
5450335 5450335 20241031184916_WiCuZ HR0017 2024-11-02T12:14:59.283Z 2024-11-09T14:24:15.494Z
5450316 5450316 20241031184001_LRDMs HR0017 2024-11-02T12:14:58.123Z 2024-11-09T14:24:15.410Z
5444469 5444469 20241031012338_ksvrf HR0017 2024-11-01T12:21:19.066Z 2024-11-08T14:23:15.671Z
5444454 5444454 20241031012234_lBjM5 HR0017 2024-11-01T12:21:18.304Z 2024-11-08T14:23:15.638Z
5443206 5443206 20241030035928_k3Uvu HR0017 2024-11-01T12:20:22.763Z 2024-11-07T14:26:50.089Z
5443035 5443035 20241030032125_bjPDn HR0017 2024-11-01T12:20:16.260Z 2024-11-07T14:26:49.287Z
5442643 5442643 20241030020852_2cvue HR0017 2024-11-01T12:20:03.973Z 2024-11-07T14:26:47.247Z
5442425 5442425 20241030012952_OD8dy HR0017 2024-11-01T12:19:47.956Z 2024-11-07T14:26:46.572Z
5441891 5441891 20241029235652_8fSCx HR0017 2024-11-01T12:19:11.345Z 2024-11-07T14:26:44.236Z
5441568 5441568 20241029223810_OMq6E HR0017 2024-11-01T12:18:45.523Z 2024-11-07T14:26:42.669Z
5441471 5441471 20241029222048_TjHWR HR0017 2024-11-01T12:18:38.985Z 2024-11-07T14:26:42.256Z
5441405 5441405 20241029220745_ovGCG HR0017 2024-11-01T12:18:32.680Z 2024-11-07T14:26:42.008Z
5441184 5441184 20241029210622_27meo HR0017 2024-11-01T12:18:16.129Z 2024-11-07T14:26:41.166Z
5441157 5441157 20241029205915_0YA1S HR0017 2024-11-01T12:18:12.516Z 2024-11-07T14:26:41.076Z
5440926 5440926 20241030232453_tLxfm HR0017 2024-11-01T12:16:00.664Z 2024-11-08T14:23:11.121Z
5440840 5440840 20241030231435_PzHEq HR0017 2024-11-01T12:15:54.001Z 2024-11-08T14:23:10.810Z
5440831 5440831 20241030231412_y0bC3 HR0017 2024-11-01T12:15:53.852Z 2024-11-08T14:23:10.792Z
5440388 5440388 20241030220626_JFJab HR0017 2024-11-01T12:15:28.279Z 2024-11-08T14:23:09.304Z
5440133 5440133 20241030212703_JhRPI HR0017 2024-11-01T12:14:53.432Z 2024-11-08T14:23:07.560Z
5439772 5439772 20241030203058_H9YzE HR0017 2024-11-01T12:14:27.604Z 2024-11-08T14:23:05.561Z
5433594 5433594 20241029202956_H7El1 HR0017 2024-10-31T12:22:23.613Z 2024-11-07T14:26:40.260Z
5433361 5433361 20241029192359_5jxjr HR0017 2024-10-31T12:22:10.535Z 2024-11-07T14:26:38.683Z
5433119 5433119 20241029170154_R5ZSh HR0017 2024-10-31T12:21:49.435Z 2024-11-07T14:26:34.691Z
5432496 5432496 20241029034204_SE2wr HR0017 2024-10-31T12:21:24.761Z 2024-11-06T14:27:27.652Z
5431788 5431788 20241029015847_cM9BM HR0017 2024-10-31T12:20:40.082Z 2024-11-06T14:27:24.839Z
5431740 5431740 20241029015332_2ELEb HR0017 2024-10-31T12:20:35.735Z 2024-11-06T14:27:24.645Z
5431485 5431485 20241029011939_ewBsM HR0017 2024-10-31T12:20:13.200Z 2024-11-06T14:27:23.896Z
5430919 5430919 20241029000506_f8Igh HR0017 2024-10-31T12:19:17.715Z 2024-11-06T14:27:22.253Z
5428690 5428690 20241028175458_sGhT2 HR0017 2024-10-31T12:15:24.204Z 2024-11-06T14:27:14.278Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network