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

738 rows where station_code = "US004L" 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
8669235 8669235 20251202103536_n3qIV US004L 2025-12-03T14:02:56.702Z 2025-12-06T14:23:41.480Z
8669116 8669116 20251202101515_OpNdk US004L 2025-12-03T14:02:36.159Z 2025-12-06T14:23:34.167Z
8668929 8668929 20251202092821_7Hs65 US004L 2025-12-03T14:01:37.131Z 2025-12-06T14:23:21.806Z
8668741 8668741 20251202084629_YnFaY US004L 2025-12-03T14:00:59.946Z 2025-12-06T14:23:07.623Z
8660117 8660117 20251130115804_tNXGH US004L 2025-12-02T14:06:32.435Z 2025-12-06T14:36:53.090Z
8659486 8659486 20251130103354_O5wZJ US004L 2025-12-02T14:04:07.625Z 2025-12-06T14:36:20.269Z
8658832 8658832 20251130082923_2OJfd US004L 2025-12-02T14:01:04.045Z 2025-12-06T14:35:42.585Z
8658777 8658777 20251130080250_AFQLF US004L 2025-12-02T14:00:47.911Z 2025-12-06T14:35:40.806Z
8658338 8658338 20251126104117_dZ2al US004L 2025-12-01T14:54:40.302Z 2025-12-05T15:01:04.048Z
8637466 8637466 20251128054214_8QXGY US004L 2025-11-29T14:27:27.686Z 2025-12-06T15:04:00.303Z
8618236 8618236 20251127115017_ZavS0 US004L 2025-11-28T14:03:52.872Z 2025-12-06T14:58:41.755Z
8618215 8618215 20251127114707_ncSGc US004L 2025-11-28T14:03:48.948Z 2025-12-06T14:58:41.399Z
8616915 8616915 20251126072426_hG4UG US004L 2025-11-27T14:32:00.516Z 2025-12-04T15:11:51.383Z
8615896 8615896 20251126052642_FhN2L US004L 2025-11-27T14:30:15.917Z 2025-12-04T15:11:33.590Z
8605107 8605107 20251126110408_4vG2B US004L 2025-11-27T14:01:59.046Z 2025-12-05T15:01:09.804Z
8605082 8605082 20251126105711_Egrgt US004L 2025-11-27T14:01:50.851Z 2025-12-05T15:01:08.674Z
8604797 8604797 20251126093652_2YJkC US004L 2025-11-27T14:00:39.168Z 2025-12-05T15:00:54.519Z
8583919 8583919 20251123101434_GS78P US004L 2025-11-25T14:04:35.369Z 2025-12-02T15:09:44.221Z
8582474 8582474 20251123063039_Swgg4 US004L 2025-11-24T14:33:39.451Z 2025-12-01T15:22:24.299Z
8582389 8582389 20251123055726_9Avfl US004L 2025-11-24T14:33:33.098Z 2025-12-01T15:22:23.046Z
8582192 8582192 20251123043454_iqA7V US004L 2025-11-24T14:33:21.853Z 2025-12-01T15:22:18.309Z
8581508 8581508 20251123002352_eQY0e US004L 2025-11-24T14:31:42.021Z 2025-12-01T15:20:48.103Z
8575134 8575134 20251122114634_UBH1G US004L 2025-11-24T14:02:15.535Z 2025-12-01T15:17:54.923Z
8575091 8575091 20251122114131_lEZYH US004L 2025-11-24T14:02:03.393Z 2025-12-01T15:17:51.810Z
8517004 8517004 20251118093026_tSL6f US004L 2025-11-19T14:42:21.989Z 2025-11-26T15:08:17.449Z
8516896 8516896 20251118085916_0PwQp US004L 2025-11-19T14:42:16.383Z 2025-11-26T15:08:11.268Z
8516653 8516653 20251118080128_FHQhg US004L 2025-11-19T14:42:07.130Z 2025-11-26T15:08:08.647Z
8516573 8516573 20251118074319_CJP2N US004L 2025-11-19T14:41:48.677Z 2025-11-26T15:08:08.291Z
8516554 8516554 20251118073941_HOn4Z US004L 2025-11-19T14:41:46.822Z 2025-11-26T15:08:08.217Z
8516417 8516417 20251118064927_k3u17 US004L 2025-11-19T14:41:21.443Z 2025-11-26T15:08:07.557Z
8500458 8500458 20251116090031_Lpnf5 US004L 2025-11-18T14:46:19.416Z 2025-11-24T15:05:43.059Z
8500433 8500433 20251116085504_N8yJv US004L 2025-11-18T14:46:18.263Z 2025-11-24T15:05:41.675Z
8500055 8500055 20251116072655_2DURq US004L 2025-11-18T14:45:29.063Z 2025-11-24T15:05:30.751Z
8500039 8500039 20251116071832_bpyge US004L 2025-11-18T14:45:27.943Z 2025-11-24T15:05:30.506Z
8498826 8498826 20251117012003_o2T2B US004L 2025-11-18T14:31:48.104Z 2025-11-25T15:09:01.962Z
8486713 8486713 20251116113317_Acbdk US004L 2025-11-18T14:00:33.511Z 2025-11-25T15:06:00.189Z
8486128 8486128 20251115111824_6COxj US004L 2025-11-17T14:34:11.362Z 2025-11-23T15:20:22.852Z
8485957 8485957 20251115111203_zTeg9 US004L 2025-11-17T14:34:07.897Z 2025-11-23T15:20:15.916Z
8485551 8485551 20251115105119_xmHJs US004L 2025-11-17T14:33:56.574Z 2025-11-23T15:20:07.882Z
8485046 8485046 20251115102210_T5G23 US004L 2025-11-17T14:33:09.578Z 2025-11-23T15:19:54.028Z
8485024 8485024 20251115102059_mzGYO US004L 2025-11-17T14:33:06.326Z 2025-11-23T15:19:53.368Z
8483355 8483355 20251115082419_XU2TC US004L 2025-11-17T14:31:20.098Z 2025-11-23T15:18:51.380Z
8483043 8483043 20251115074842_QR6AL US004L 2025-11-17T14:30:58.017Z 2025-11-23T15:18:40.780Z
8482342 8482342 20251116062404_Iummj US004L 2025-11-17T14:23:07.488Z 2025-11-24T15:05:26.705Z
8472910 8472910 20251115114732_5Sbd3 US004L 2025-11-17T14:00:37.023Z 2025-11-24T15:02:25.057Z
8470124 8470124 20251115042012_m5012 US004L 2025-11-16T14:22:04.160Z 2025-11-23T15:18:00.473Z
8462283 8462283 20251114112246_KbbNj US004L 2025-11-15T14:25:58.889Z 2025-11-22T15:24:15.093Z
8462114 8462114 20251114105149_Mewuv US004L 2025-11-15T14:25:34.375Z 2025-11-22T15:24:02.788Z
8462075 8462075 20251114103849_2Z5JV US004L 2025-11-15T14:25:30.333Z 2025-11-22T15:23:58.505Z
8451556 8451556 20251113084130_u3b2J US004L 2025-11-14T14:26:00.564Z 2025-11-21T15:13:17.823Z
8451317 8451317 20251113074504_RAnxa US004L 2025-11-14T14:25:37.473Z 2025-11-21T15:13:09.562Z
8440534 8440534 20251112065207_Mp8VJ US004L 2025-11-13T14:28:59.306Z 2025-11-20T15:25:52.675Z
8440501 8440501 20251112064209_mh61u US004L 2025-11-13T14:28:56.229Z 2025-11-20T15:25:51.856Z
8439141 8439141 20251112031853_9kYKa US004L 2025-11-13T14:25:49.578Z 2025-11-13T14:25:49.578Z
8438519 8438519 20251112020820_cfKf8 US004L 2025-11-13T14:23:57.927Z 2025-11-20T15:24:38.293Z
8416314 8416314 20251110083443_yV83K US004L 2025-11-11T14:25:34.406Z 2025-11-18T15:21:44.800Z
8416170 8416170 20251110080554_zwYFZ US004L 2025-11-11T14:25:10.426Z 2025-11-18T15:21:41.685Z
8415671 8415671 20251110061419_v7j3r US004L 2025-11-11T14:24:08.933Z 2025-11-18T15:21:32.432Z
8415138 8415138 20251110043007_be4EC US004L 2025-11-11T14:22:44.514Z 2025-11-18T15:21:22.184Z
8386694 8386694 20251106063331_jEi7r US004L 2025-11-07T14:12:03.789Z 2025-11-14T15:08:45.063Z
8385611 8385611 20251106004927_gUy9m US004L 2025-11-07T14:07:31.746Z 2025-11-14T15:08:17.199Z
8376613 8376613 20251103112738_hHcAs US004L 2025-11-05T14:36:55.457Z 2025-11-11T15:08:46.827Z
8376424 8376424 20251103105056_lzFyf US004L 2025-11-05T14:36:39.009Z 2025-11-11T15:08:37.929Z
8372839 8372839 20251104103236_TTcCF US004L 2025-11-05T14:19:22.989Z 2025-11-12T15:11:56.249Z
8366093 8366093 20251102100924_caaRb US004L 2025-11-04T14:34:23.145Z 2025-11-10T15:10:28.920Z
8365885 8365885 20251102095055_wfgNd US004L 2025-11-04T14:34:06.564Z 2025-11-10T15:10:27.098Z
8358912 8358912 20251102092737_F2KAL US004L 2025-11-03T14:46:43.041Z 2025-11-10T15:10:24.934Z
8356478 8356478 20251102015327_rmoLd US004L 2025-11-03T14:40:29.055Z 2025-11-10T15:07:18.959Z
8356384 8356384 20251102012531_f1PqF US004L 2025-11-03T14:40:00.592Z 2025-11-10T15:06:51.972Z
8339314 8339314 20251031101522_dsIeA US004L 2025-11-02T14:34:02.283Z 2025-11-08T15:17:33.998Z
8338933 8338933 20251031093814_fSO1c US004L 2025-11-02T14:33:21.654Z 2025-11-08T15:17:22.423Z
8338862 8338862 20251031093000_bDheI US004L 2025-11-02T14:33:18.902Z 2025-11-08T15:17:19.649Z
8338237 8338237 20251031082523_p1d7A US004L 2025-11-02T14:31:59.896Z 2025-11-08T15:16:37.162Z
8338083 8338083 20251031080423_4s2at US004L 2025-11-02T14:31:43.864Z 2025-11-08T15:16:31.928Z
8326192 8326192 20251030091813_4sDBw US004L 2025-11-01T12:35:19.848Z 2025-11-07T15:17:46.320Z
8325604 8325604 20251030080800_jaerk US004L 2025-11-01T12:34:17.717Z 2025-11-07T15:17:26.928Z
8205300 8205300 20251022070418_reUNJ US004L 2025-10-25T12:46:29.811Z 2025-10-30T13:13:39.608Z
8204132 8204132 20251023101517_gBF1c US004L 2025-10-25T12:26:33.207Z 2025-10-31T13:09:05.688Z
8203439 8203439 20251023090450_tR9ce US004L 2025-10-25T12:24:33.708Z 2025-10-31T13:08:59.837Z
8203185 8203185 20251023083326_LvCel US004L 2025-10-25T12:23:48.322Z 2025-10-31T13:08:59.232Z
8203125 8203125 20251023082414_IRF2R US004L 2025-10-25T12:23:29.388Z 2025-10-31T13:08:59.102Z
8202454 8202454 20251023064116_jSZOq US004L 2025-10-25T12:21:25.853Z 2025-10-31T13:08:55.312Z
8202281 8202281 20251023060808_FuJ2x US004L 2025-10-25T12:20:48.342Z 2025-10-31T13:08:54.755Z
8197298 8197298 20251022104859_E2Cth US004L 2025-10-24T12:36:03.769Z 2025-10-30T13:13:53.572Z
8197248 8197248 20251022104358_jciW2 US004L 2025-10-24T12:35:57.607Z 2025-10-30T13:13:52.937Z
8197160 8197160 20251022103741_Z6kOn US004L 2025-10-24T12:35:24.037Z 2025-10-30T13:13:52.710Z
8197081 8197081 20251022102816_ckPj2 US004L 2025-10-24T12:35:14.934Z 2025-10-30T13:13:52.528Z
8196603 8196603 20251022094652_OevHN US004L 2025-10-24T12:34:32.472Z 2025-10-30T13:13:49.548Z
8195859 8195859 20251022082007_9WfKN US004L 2025-10-24T12:32:32.766Z 2025-10-30T13:13:43.905Z
8195438 8195438 20251022072941_Ji4SA US004L 2025-10-24T12:31:58.977Z 2025-10-30T13:13:41.746Z
8195255 8195255 20251022070638_MDK36 US004L 2025-10-24T12:31:21.282Z 2025-10-30T13:13:39.662Z
8195205 8195205 20251022065753_S1mnY US004L 2025-10-24T12:31:18.529Z 2025-10-30T13:13:39.497Z
8195061 8195061 20251022063808_6hW4B US004L 2025-10-24T12:31:07.305Z 2025-10-30T13:13:38.877Z
8182712 8182712 20251021060804_YkH55 US004L 2025-10-23T12:31:21.748Z 2025-10-29T13:07:45.996Z
8173660 8173660 20251020112834_XLO2q US004L 2025-10-22T12:43:47.776Z 2025-10-28T13:09:36.500Z
8170859 8170859 20251020082101_UpuvF US004L 2025-10-22T12:40:31.814Z 2025-10-28T13:09:10.103Z
8169794 8169794 20251020065021_FuYbW US004L 2025-10-22T12:38:35.024Z 2025-10-28T13:09:04.648Z
8169325 8169325 20251020054752_NoxU2 US004L 2025-10-22T12:37:42.802Z 2025-10-28T13:09:01.202Z
8150850 8150850 20251019113249_bzAEK US004L 2025-10-20T12:31:35.552Z 2025-10-27T13:11:29.660Z
8149193 8149193 20251019090213_TAb9b US004L 2025-10-20T12:28:40.389Z 2025-10-27T13:11:15.930Z

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