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

9,752 rows where station_code = "UK00AM" 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
9272885 9272885 20260128035751_oYe63 UK00AM 2026-01-29T14:28:12.002Z 2026-01-29T14:30:25.703Z
9272850 9272850 20260128034454_3WVyt UK00AM 2026-01-29T14:28:02.091Z 2026-01-29T14:30:25.581Z
9272737 9272737 20260128031328_n2F6y UK00AM 2026-01-29T14:27:39.348Z 2026-01-29T14:30:25.444Z
9272535 9272535 20260128022907_X3CKg UK00AM 2026-01-29T14:27:05.798Z 2026-01-29T14:30:25.372Z
9272038 9272038 20260127231705_dSO83 UK00AM 2026-01-29T14:25:22.127Z 2026-01-29T14:30:25.268Z
9271995 9271995 20260127225230_Sbxbi UK00AM 2026-01-29T14:25:15.442Z 2026-01-29T14:30:25.261Z
9271991 9271991 20260127224504_llQbM UK00AM 2026-01-29T14:25:14.158Z 2026-01-29T14:30:25.259Z
9271918 9271918 20260127214900_IczKB UK00AM 2026-01-29T14:24:54.745Z 2026-01-29T14:30:25.229Z
9271839 9271839 20260127203419_unHB4 UK00AM 2026-01-29T14:24:09.981Z 2026-01-29T14:30:25.170Z
9271826 9271826 20260127203324_r6Q8Z UK00AM 2026-01-29T14:24:08.851Z 2026-01-29T14:30:25.169Z
9271749 9271749 20260127194933_slUeQ UK00AM 2026-01-29T14:23:15.933Z 2026-01-29T14:30:25.097Z
9255959 9255959 20260124053227_wZvUN UK00AM 2026-01-25T14:15:20.798Z 2026-01-29T14:48:10.332Z
9255787 9255787 20260124045610_v7DFP UK00AM 2026-01-25T14:14:43.914Z 2026-01-29T14:47:57.823Z
9255781 9255781 20260124045538_4vrfN UK00AM 2026-01-25T14:14:41.344Z 2026-01-29T14:47:57.095Z
9255712 9255712 20260124043801_3sgi0 UK00AM 2026-01-25T14:14:27.764Z 2026-01-29T14:47:53.409Z
9255660 9255660 20260124042604_fGIXJ UK00AM 2026-01-25T14:14:13.427Z 2026-01-29T14:47:49.820Z
9255140 9255140 20260124011324_5wEBj UK00AM 2026-01-25T14:12:01.869Z 2026-01-29T14:47:04.452Z
9255132 9255132 20260124010809_6i9XV UK00AM 2026-01-25T14:11:59.675Z 2026-01-29T14:47:03.992Z
9254975 9254975 20260123234319_RQi5B UK00AM 2026-01-25T14:11:30.438Z 2026-01-29T14:46:57.990Z
9254954 9254954 20260123232727_H36WC UK00AM 2026-01-25T14:11:27.343Z 2026-01-29T14:46:57.233Z
9252763 9252763 20260123061351_0jOwC UK00AM 2026-01-24T14:17:03.570Z 2026-01-29T14:53:23.542Z
9252552 9252552 20260123040921_GtFPg UK00AM 2026-01-24T14:16:10.132Z 2026-01-29T14:53:08.217Z
9252474 9252474 20260123032410_CAj2c UK00AM 2026-01-24T14:15:45.272Z 2026-01-29T14:53:00.759Z
9252213 9252213 20260123014708_FhKIz UK00AM 2026-01-24T14:14:45.405Z 2026-01-29T14:52:39.984Z
9244222 9244222 20260121065021_ongE3 UK00AM 2026-01-22T14:24:38.236Z 2026-01-29T15:05:56.289Z
9244136 9244136 20260121062050_a2AIo UK00AM 2026-01-22T14:24:15.247Z 2026-01-29T15:05:52.955Z
9243988 9243988 20260121054717_5d2Dl UK00AM 2026-01-22T14:23:48.973Z 2026-01-29T15:05:37.587Z
9243963 9243963 20260121054409_I2k2d UK00AM 2026-01-22T14:23:39.905Z 2026-01-29T15:05:36.802Z
9243937 9243937 20260121053721_cExNI UK00AM 2026-01-22T14:23:35.946Z 2026-01-29T15:05:35.298Z
9243906 9243906 20260121053133_WZa6G UK00AM 2026-01-22T14:23:29.196Z 2026-01-29T15:05:34.041Z
9243855 9243855 20260121052606_HFQYx UK00AM 2026-01-22T14:23:21.997Z 2026-01-29T15:05:30.165Z
9243847 9243847 20260121052538_HeRSM UK00AM 2026-01-22T14:23:21.302Z 2026-01-29T15:05:29.780Z
9243811 9243811 20260121051948_loLp5 UK00AM 2026-01-22T14:23:06.326Z 2026-01-29T15:05:28.428Z
9243709 9243709 20260121050859_V9IOG UK00AM 2026-01-22T14:22:48.807Z 2026-01-29T15:05:24.368Z
9243392 9243392 20260121042703_pd56C UK00AM 2026-01-22T14:21:37.260Z 2026-01-29T15:05:00.451Z
9243375 9243375 20260121042411_xFqmD UK00AM 2026-01-22T14:21:34.254Z 2026-01-29T15:04:59.438Z
9243353 9243353 20260121042033_huJXF UK00AM 2026-01-22T14:21:31.006Z 2026-01-29T15:04:56.762Z
9243334 9243334 20260121041634_fCBo7 UK00AM 2026-01-22T14:21:27.810Z 2026-01-29T15:04:55.973Z
9243328 9243328 20260121041540_ck34c UK00AM 2026-01-22T14:21:27.439Z 2026-01-29T15:04:55.863Z
9243317 9243317 20260121041311_NYzfk UK00AM 2026-01-22T14:21:25.925Z 2026-01-29T15:04:55.454Z
9237225 9237225 20260120045227_d0t2i UK00AM 2026-01-21T14:25:43.496Z 2026-01-28T15:01:04.661Z
9236862 9236862 20260120041025_kNIYx UK00AM 2026-01-21T14:24:23.186Z 2026-01-28T15:00:39.686Z
9223224 9223224 20260117234955_2qPYC UK00AM 2026-01-19T14:18:18.884Z 2026-01-26T15:01:58.572Z
9223181 9223181 20260117233729_TPnjW UK00AM 2026-01-19T14:18:02.691Z 2026-01-26T15:01:56.911Z
9217851 9217851 20260116200709_iViDC UK00AM 2026-01-18T14:09:16.571Z 2026-01-25T14:57:49.608Z
9217817 9217817 20260116195921_xHrJp UK00AM 2026-01-18T14:09:09.149Z 2026-01-25T14:57:48.824Z
9217689 9217689 20260116190646_QMBNV UK00AM 2026-01-18T14:08:31.864Z 2026-01-25T14:57:44.346Z
9217565 9217565 20260116175721_n6mU2 UK00AM 2026-01-18T14:07:58.501Z 2026-01-25T14:57:26.271Z
9213889 9213889 20260116045717_tnihh UK00AM 2026-01-17T14:19:00.848Z 2026-01-24T15:12:50.504Z
9213625 9213625 20260116040907_9GvQN UK00AM 2026-01-17T14:17:48.891Z 2026-01-24T15:12:26.019Z
9213611 9213611 20260116040831_Dutgi UK00AM 2026-01-17T14:17:45.619Z 2026-01-24T15:12:24.712Z
9213581 9213581 20260116040508_Y1Dfq UK00AM 2026-01-17T14:17:40.032Z 2026-01-24T15:12:23.258Z
9213451 9213451 20260116033831_o8Euw UK00AM 2026-01-17T14:16:59.192Z 2026-01-24T15:12:14.903Z
9213346 9213346 20260116031634_GB3VG UK00AM 2026-01-17T14:16:32.029Z 2026-01-24T15:12:10.309Z
9213299 9213299 20260116030552_I6dKt UK00AM 2026-01-17T14:16:20.551Z 2026-01-24T15:12:08.073Z
9213242 9213242 20260116024542_GJ629 UK00AM 2026-01-17T14:16:02.729Z 2026-01-24T15:11:51.146Z
9213228 9213228 20260116024052_rg6Mp UK00AM 2026-01-17T14:16:00.007Z 2026-01-24T15:11:50.416Z
9213225 9213225 20260116023935_qVK8y UK00AM 2026-01-17T14:15:58.876Z 2026-01-24T15:11:50.198Z
9213193 9213193 20260116023149_NNbpt UK00AM 2026-01-17T14:15:51.501Z 2026-01-24T15:11:48.532Z
9208747 9208747 20260115064021_q2rX3 UK00AM 2026-01-16T14:13:48.855Z 2026-01-22T15:04:38.692Z
9208743 9208743 20260115063959_tmaiG UK00AM 2026-01-16T14:13:48.444Z 2026-01-22T15:04:38.629Z
9208736 9208736 20260115063959_YwIuu UK00AM 2026-01-16T14:13:47.801Z 2026-01-22T15:04:38.512Z
9208718 9208718 20260115063602_bp5tV UK00AM 2026-01-16T14:13:45.186Z 2026-01-22T15:04:38.087Z
9208705 9208705 20260115063354_W6y3p UK00AM 2026-01-16T14:13:43.220Z 2026-01-22T15:04:37.789Z
9208305 9208305 20260115045918_vLTza UK00AM 2026-01-16T14:12:04.964Z 2026-01-22T15:04:06.929Z
9208141 9208141 20260115041914_gGi1j UK00AM 2026-01-16T14:11:27.939Z 2026-01-22T15:04:02.137Z
9207409 9207409 20260115013121_pNnEt UK00AM 2026-01-16T14:08:39.214Z 2026-01-22T15:03:21.168Z
9207385 9207385 20260115011934_0FfJu UK00AM 2026-01-16T14:08:32.430Z 2026-01-22T15:03:20.478Z
9207344 9207344 20260115010534_5o2GA UK00AM 2026-01-16T14:08:20.851Z 2026-01-22T15:03:19.340Z
9207335 9207335 20260115010442_CBG0L UK00AM 2026-01-16T14:08:19.495Z 2026-01-22T15:03:19.225Z
9204509 9204509 20260114065345_ZtbSr UK00AM 2026-01-15T14:27:28.780Z 2026-01-22T15:10:30.259Z
9204389 9204389 20260114063513_qQZ2I UK00AM 2026-01-15T14:27:12.147Z 2026-01-22T15:10:27.079Z
9204142 9204142 20260114060942_aMJKk UK00AM 2026-01-15T14:26:30.250Z 2026-01-22T15:10:20.769Z
9204131 9204131 20260114060941_xD1gs UK00AM 2026-01-15T14:26:28.850Z 2026-01-22T15:10:18.547Z
9204055 9204055 20260114060430_kBXtr UK00AM 2026-01-15T14:26:19.421Z 2026-01-22T15:10:17.372Z
9204016 9204016 20260114060333_IejRG UK00AM 2026-01-15T14:26:15.985Z 2026-01-22T15:10:16.988Z
9203999 9203999 20260114060258_ckBHE UK00AM 2026-01-15T14:26:14.221Z 2026-01-22T15:10:16.824Z
9203978 9203978 20260114060137_S2533 UK00AM 2026-01-15T14:26:00.489Z 2026-01-22T15:10:16.511Z
9203682 9203682 20260114052833_ZmUYL UK00AM 2026-01-15T14:25:10.487Z 2026-01-22T15:10:12.014Z
9203464 9203464 20260114045901_ZXYMY UK00AM 2026-01-15T14:24:29.730Z 2026-01-22T15:10:08.359Z
9203376 9203376 20260114045313_QQs0A UK00AM 2026-01-15T14:24:11.033Z 2026-01-22T15:10:06.435Z
9203341 9203341 20260114045113_2jfwW UK00AM 2026-01-15T14:24:05.380Z 2026-01-22T15:10:05.879Z
9203268 9203268 20260114044656_C3uUu UK00AM 2026-01-15T14:23:55.427Z 2026-01-22T15:10:04.642Z
9203254 9203254 20260114044523_VeXSp UK00AM 2026-01-15T14:23:54.506Z 2026-01-22T15:10:04.454Z
9203212 9203212 20260114044238_6gMFl UK00AM 2026-01-15T14:23:40.042Z 2026-01-22T15:10:03.714Z
9202892 9202892 20260114041602_92m61 UK00AM 2026-01-15T14:22:43.418Z 2026-01-22T15:09:58.838Z
9202820 9202820 20260114041025_mdhK9 UK00AM 2026-01-15T14:22:27.935Z 2026-01-22T15:09:52.392Z
9202776 9202776 20260114040800_3zk0J UK00AM 2026-01-15T14:22:20.331Z 2026-01-22T15:09:40.834Z
9202721 9202721 20260114040520_KEyk4 UK00AM 2026-01-15T14:22:14.567Z 2026-01-22T15:09:31.274Z
9202629 9202629 20260114035625_nQcUv UK00AM 2026-01-15T14:21:48.470Z 2026-01-22T15:09:23.848Z
9202517 9202517 20260114034411_JyVtx UK00AM 2026-01-15T14:21:33.842Z 2026-01-22T15:09:21.603Z
9202318 9202318 20260114032847_OYN0J UK00AM 2026-01-15T14:21:03.875Z 2026-01-22T15:09:16.273Z
9201743 9201743 20260114024709_9bz24 UK00AM 2026-01-15T14:19:37.911Z 2026-01-22T15:09:08.827Z
9201421 9201421 20260114021606_xDAIv UK00AM 2026-01-15T14:18:36.732Z 2026-01-22T15:09:03.503Z
9201330 9201330 20260114021037_v1HXK UK00AM 2026-01-15T14:18:16.849Z 2026-01-22T15:09:01.968Z
9201068 9201068 20260114014009_Tbha1 UK00AM 2026-01-15T14:17:31.130Z 2026-01-22T15:08:57.437Z
9201011 9201011 20260114012905_rGecj UK00AM 2026-01-15T14:17:12.236Z 2026-01-22T15:08:47.746Z
9200855 9200855 20260114011449_uFpCQ UK00AM 2026-01-15T14:16:41.117Z 2026-01-22T15:08:31.071Z
9200843 9200843 20260114011110_ySrw0 UK00AM 2026-01-15T14:16:39.221Z 2026-01-22T15:08:30.620Z
9200826 9200826 20260114010634_L97oj UK00AM 2026-01-15T14:16:35.880Z 2026-01-22T15:08:29.789Z

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