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

4,512 rows where station_code = "US0055" 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
9611679 9611679 20260405030831_k130I US0055 2026-04-06T12:15:42.913Z 2026-04-06T12:16:14.846Z
9609936 9609936 20260405111804_uEO83 US0055 2026-04-06T12:04:50.818Z 2026-04-06T12:04:50.818Z
9609641 9609641 20260405085305_n5y53 US0055 2026-04-06T12:03:02.365Z 2026-04-06T12:03:02.365Z
9609364 9609364 20260405051043_SW6EZ US0055 2026-04-06T12:01:28.469Z 2026-04-06T12:01:28.469Z
9609342 9609342 20260405050101_GF948 US0055 2026-04-06T12:01:19.436Z 2026-04-06T12:01:19.436Z
9609336 9609336 20260405044847_HcM02 US0055 2026-04-06T12:01:17.724Z 2026-04-06T12:01:17.724Z
9609176 9609176 20260405035326_0cOF4 US0055 2026-04-06T12:00:34.482Z 2026-04-06T12:00:34.482Z
9595815 9595815 20260330085633_Jk2n4 US0055 2026-03-31T12:02:35.452Z 2026-04-06T12:30:34.828Z
9593467 9593467 20260329110611_YVGM2 US0055 2026-03-30T12:04:04.568Z 2026-04-06T12:35:20.467Z
9593453 9593453 20260329105453_5iSlc US0055 2026-03-30T12:04:00.094Z 2026-04-06T12:35:19.607Z
9593437 9593437 20260329104203_pRJ4K US0055 2026-03-30T12:03:57.788Z 2026-04-06T12:35:18.767Z
9593378 9593378 20260329095646_QrDVy US0055 2026-03-30T12:03:46.491Z 2026-04-06T12:35:15.176Z
9590761 9590761 20260328111043_R9FPy US0055 2026-03-29T12:03:13.899Z 2026-04-06T12:38:33.639Z
9590645 9590645 20260328103227_o0pzM US0055 2026-03-29T12:03:04.111Z 2026-04-06T12:38:28.651Z
9590615 9590615 20260328102313_4P3vH US0055 2026-03-29T12:03:00.729Z 2026-04-06T12:38:27.369Z
9590511 9590511 20260328094639_kLyCe US0055 2026-03-29T12:02:50.008Z 2026-04-06T12:38:13.659Z
9590477 9590477 20260328092341_KQ7G6 US0055 2026-03-29T12:02:44.015Z 2026-04-06T12:38:11.558Z
9590438 9590438 20260328091321_bN9zO US0055 2026-03-29T12:02:39.255Z 2026-04-06T12:38:09.727Z
9590404 9590404 20260328085518_Cbuwe US0055 2026-03-29T12:02:34.516Z 2026-04-06T12:38:06.128Z
9590124 9590124 20260328063838_mt2nd US0055 2026-03-29T12:02:02.822Z 2026-04-06T12:37:51.755Z
9589668 9589668 20260328035759_TuRBv US0055 2026-03-29T12:01:33.146Z 2026-04-06T12:37:31.160Z
9589466 9589466 20260328033200_7Narj US0055 2026-03-29T12:01:18.158Z 2026-04-06T12:37:24.850Z
9587211 9587211 20260327114225_lo0k3 US0055 2026-03-28T12:05:01.949Z 2026-04-05T12:34:08.111Z
9582804 9582804 20260326093616_VJHmZ US0055 2026-03-27T12:06:51.365Z 2026-04-04T12:40:29.362Z
9582544 9582544 20260326082107_4SVG9 US0055 2026-03-27T12:06:06.449Z 2026-04-04T12:40:08.079Z
9582450 9582450 20260326073654_TXC0w US0055 2026-03-27T12:05:48.570Z 2026-04-04T12:40:01.595Z
9582441 9582441 20260326072953_kPNNF US0055 2026-03-27T12:05:46.245Z 2026-04-04T12:40:01.122Z
9580303 9580303 20260320104947_QWFYg US0055 2026-03-26T12:31:32.128Z 2026-03-28T12:35:19.226Z
9580302 9580302 20260320104053_b8Por US0055 2026-03-26T12:31:30.672Z 2026-03-28T12:35:18.007Z
9580295 9580295 20260320101028_L1qsD US0055 2026-03-26T12:31:24.509Z 2026-03-28T12:35:04.483Z
9580291 9580291 20260320095436_1MYca US0055 2026-03-26T12:31:21.797Z 2026-03-28T12:35:02.318Z
9580287 9580287 20260320093040_s6dqS US0055 2026-03-26T12:31:18.020Z 2026-03-28T12:34:59.354Z
9580283 9580283 20260320090437_u9WqR US0055 2026-03-26T12:31:13.532Z 2026-03-28T12:34:56.264Z
9580281 9580281 20260320090241_kgZtb US0055 2026-03-26T12:31:13.100Z 2026-03-28T12:34:55.821Z
9580279 9580279 20260320084753_bn7iv US0055 2026-03-26T12:31:11.111Z 2026-03-28T12:34:53.963Z
9580278 9580278 20260320083032_Z6oHL US0055 2026-03-26T12:31:08.146Z 2026-03-28T12:34:50.475Z
9580275 9580275 20260320075339_XoBZU US0055 2026-03-26T12:30:54.438Z 2026-03-28T12:34:46.155Z
9580273 9580273 20260320073454_7C0ki US0055 2026-03-26T12:30:52.155Z 2026-03-28T12:34:34.963Z
9580269 9580269 20260320065519_vL2P0 US0055 2026-03-26T12:30:48.640Z 2026-03-28T12:34:32.246Z
9580265 9580265 20260320064944_6yIUZ US0055 2026-03-26T12:30:48.097Z 2026-03-28T12:34:31.886Z
9580263 9580263 20260320064303_E24oT US0055 2026-03-26T12:30:47.784Z 2026-03-28T12:34:31.564Z
9580262 9580262 20260320063147_JFoAs US0055 2026-03-26T12:30:47.158Z 2026-03-28T12:34:30.853Z
9580258 9580258 20260320060940_KjIDT US0055 2026-03-26T12:30:45.691Z 2026-03-28T12:34:29.155Z
9580251 9580251 20260320052512_XZ1mc US0055 2026-03-26T12:30:42.454Z 2026-03-28T12:34:26.639Z
9580250 9580250 20260320050648_otUFP US0055 2026-03-26T12:30:41.267Z 2026-03-28T12:34:25.517Z
9580246 9580246 20260320041748_GzV8A US0055 2026-03-26T12:30:35.552Z 2026-03-28T12:34:21.675Z
9580243 9580243 20260320041355_VASCk US0055 2026-03-26T12:30:34.429Z 2026-03-28T12:34:21.005Z
9580239 9580239 20260321110627_ER34W US0055 2026-03-26T12:26:56.224Z 2026-03-29T12:19:43.230Z
9580233 9580233 20260321103507_lEsPj US0055 2026-03-26T12:26:47.198Z 2026-03-29T12:19:40.152Z
9580229 9580229 20260321101131_0820g US0055 2026-03-26T12:26:41.705Z 2026-03-29T12:19:37.862Z
9579118 9579118 20260324091618_sSyfy US0055 2026-03-26T12:10:48.575Z 2026-04-02T12:35:27.367Z
9577753 9577753 20260325082559_Ca3gP US0055 2026-03-26T12:05:59.525Z 2026-04-03T12:37:25.651Z
9577586 9577586 20260325073504_akdCp US0055 2026-03-26T12:05:34.913Z 2026-04-03T12:37:09.376Z
9577560 9577560 20260325072432_a3tuz US0055 2026-03-26T12:05:31.141Z 2026-04-03T12:37:06.607Z
9577225 9577225 20260325041925_sf4gt US0055 2026-03-26T12:04:28.043Z 2026-04-03T12:36:52.321Z
9504394 9504394 20260317113044_tFPqC US0055 2026-03-18T12:07:56.231Z 2026-03-25T12:42:21.461Z
9496271 9496271 20260316110627_xBf8T US0055 2026-03-17T12:09:23.304Z 2026-03-24T12:41:18.950Z
9496077 9496077 20260316102405_gwnGJ US0055 2026-03-17T12:09:00.445Z 2026-03-24T12:41:18.232Z
9495804 9495804 20260316091745_tie4I US0055 2026-03-17T12:08:16.181Z 2026-03-24T12:41:16.741Z
9495496 9495496 20260316080717_q3T7E US0055 2026-03-17T12:07:26.503Z 2026-03-24T12:41:15.044Z
9495401 9495401 20260316073926_2QdUy US0055 2026-03-17T12:07:08.830Z 2026-03-24T12:41:14.445Z
9495395 9495395 20260316073716_EXKqH US0055 2026-03-17T12:07:07.593Z 2026-03-24T12:41:14.361Z
9495351 9495351 20260316065438_kgt9q US0055 2026-03-17T12:06:58.032Z 2026-03-24T12:41:13.847Z
9495338 9495338 20260316064356_rBuy2 US0055 2026-03-17T12:06:54.649Z 2026-03-24T12:41:12.992Z
9495257 9495257 20260316052124_ww5SD US0055 2026-03-17T12:06:36.873Z 2026-03-24T12:41:07.942Z
9494822 9494822 20260316030924_wmD3R US0055 2026-03-17T12:05:06.533Z 2026-03-24T12:40:50.427Z
9448580 9448580 20260309111303_A2ypY US0055 2026-03-10T12:10:20.306Z 2026-03-17T12:42:21.000Z
9448397 9448397 20260309104004_49Nv4 US0055 2026-03-10T12:09:45.590Z 2026-03-17T12:42:19.451Z
9448343 9448343 20260309102859_0PYnm US0055 2026-03-10T12:09:36.196Z 2026-03-17T12:42:15.219Z
9447599 9447599 20260309081214_2wvt2 US0055 2026-03-10T12:07:10.867Z 2026-03-17T12:41:53.794Z
9447177 9447177 20260309054041_c9bYZ US0055 2026-03-10T12:05:26.955Z 2026-03-17T12:41:48.532Z
9443665 9443665 20260308110007_lZy8m US0055 2026-03-09T12:08:36.011Z 2026-03-16T12:44:06.661Z
9443642 9443642 20260308105643_p1Xxy US0055 2026-03-09T12:08:32.240Z 2026-03-16T12:44:06.420Z
9442871 9442871 20260308070604_bFWlP US0055 2026-03-09T12:05:51.440Z 2026-03-16T12:43:58.111Z
9442251 9442251 20260308024312_yk4w0 US0055 2026-03-09T12:03:16.500Z 2026-03-16T12:43:47.703Z
9437652 9437652 20260307054840_Mz3fs US0055 2026-03-08T12:04:51.901Z 2026-03-15T12:41:24.352Z
9437562 9437562 20260307043531_L1reN US0055 2026-03-08T12:04:30.491Z 2026-03-15T12:41:16.209Z
9437226 9437226 20260307023809_VHTDc US0055 2026-03-08T12:03:06.193Z 2026-03-15T12:41:04.826Z
9423665 9423665 20260304114154_PMQLU US0055 2026-03-05T14:05:44.030Z 2026-03-12T12:33:01.171Z
9423487 9423487 20260304102927_976dQ US0055 2026-03-05T14:05:04.416Z 2026-03-12T12:32:57.962Z
9416681 9416681 20260302115826_fDZ7X US0055 2026-03-03T14:04:22.580Z 2026-03-10T12:36:17.147Z
9412220 9412220 20260301014908_Ykx7c US0055 2026-03-02T14:00:50.210Z 2026-03-09T12:39:24.757Z
9404465 9404465 20260227122246_hq26n US0055 2026-02-28T14:10:54.224Z 2026-03-07T14:48:50.727Z
9404460 9404460 20260227122239_P5Ya3 US0055 2026-02-28T14:10:53.476Z 2026-03-07T14:48:50.435Z
9404431 9404431 20260227121336_D73dX US0055 2026-02-28T14:10:47.240Z 2026-03-07T14:48:48.926Z
9404330 9404330 20260227120110_3m3Ys US0055 2026-02-28T14:10:34.064Z 2026-03-07T14:48:45.115Z
9404276 9404276 20260227115307_BIdOA US0055 2026-02-28T14:10:26.315Z 2026-03-07T14:48:42.430Z
9404231 9404231 20260227114850_t35du US0055 2026-02-28T14:10:18.596Z 2026-03-07T14:48:40.773Z
9404171 9404171 20260227114355_kq0rO US0055 2026-02-28T14:10:10.978Z 2026-03-07T14:48:38.274Z
9404122 9404122 20260227113812_82Bus US0055 2026-02-28T14:10:02.559Z 2026-03-07T14:48:34.973Z
9403991 9403991 20260227111503_ZsTmY US0055 2026-02-28T14:09:40.044Z 2026-03-07T14:48:22.998Z
9403682 9403682 20260227103022_QSWGA US0055 2026-02-28T14:08:55.440Z 2026-03-07T14:48:09.021Z
9403157 9403157 20260227081939_DQA0N US0055 2026-02-28T14:07:23.993Z 2026-03-07T14:47:38.403Z
9403053 9403053 20260227072819_O5JNe US0055 2026-02-28T14:07:02.949Z 2026-03-07T14:47:26.055Z
9403031 9403031 20260227070955_V7eYI US0055 2026-02-28T14:06:58.150Z 2026-03-07T14:47:23.937Z
9402994 9402994 20260227062047_1P26v US0055 2026-02-28T14:06:48.441Z 2026-03-07T14:47:20.580Z
9400103 9400103 20260226122231_Ekh5C US0055 2026-02-27T14:09:32.519Z 2026-03-06T14:44:43.984Z
9399957 9399957 20260226112420_DZtm5 US0055 2026-02-27T14:09:09.697Z 2026-03-06T14:44:39.562Z
9399939 9399939 20260226111954_nozAQ US0055 2026-02-27T14:09:05.751Z 2026-03-06T14:44:38.985Z
9399781 9399781 20260226102622_BXtKi US0055 2026-02-27T14:08:40.125Z 2026-03-06T14:44:34.962Z

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