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

>10,000 rows count all where station_code = "UK003N" 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
9602447 9602447 20260331211630_Uo66E UK003N 2026-04-02T12:08:54.003Z 2026-04-06T12:29:09.375Z
9595493 9595493 20260330042247_2tlzY UK003N 2026-03-31T12:01:35.699Z 2026-04-06T12:30:06.523Z
9595479 9595479 20260330041536_owsbN UK003N 2026-03-31T12:01:31.382Z 2026-04-06T12:30:05.691Z
9595362 9595362 20260330034716_AgQAD UK003N 2026-03-31T12:01:13.729Z 2026-04-06T12:29:59.676Z
9595345 9595345 20260330034609_cDtVb UK003N 2026-03-31T12:01:12.013Z 2026-04-06T12:29:59.056Z
9595334 9595334 20260330034132_3Wb9d UK003N 2026-03-31T12:01:10.485Z 2026-04-06T12:29:58.672Z
9595231 9595231 20260330030810_nhXXz UK003N 2026-03-31T12:00:51.092Z 2026-04-06T12:29:49.243Z
9595179 9595179 20260330025358_M0ktz UK003N 2026-03-31T12:00:43.374Z 2026-04-06T12:29:44.956Z
9595155 9595155 20260330024027_OAOti UK003N 2026-03-31T12:00:38.207Z 2026-04-06T12:29:43.351Z
9594730 9594730 20260329001739_7Igw0 UK003N 2026-03-30T12:10:14.307Z 2026-04-06T12:40:14.201Z
9594706 9594706 20260329000426_vWa6m UK003N 2026-03-30T12:10:11.564Z 2026-04-06T12:40:10.661Z
9594623 9594623 20260328233625_qbufz UK003N 2026-03-30T12:10:00.606Z 2026-04-06T12:40:01.950Z
9593041 9593041 20260329043352_Rnph9 UK003N 2026-03-30T12:02:43.570Z 2026-04-06T12:34:47.169Z
9592962 9592962 20260329040525_YIzQy UK003N 2026-03-30T12:02:27.355Z 2026-04-06T12:34:42.692Z
9592922 9592922 20260329035634_D82F2 UK003N 2026-03-30T12:02:20.692Z 2026-04-06T12:34:40.864Z
9592848 9592848 20260329033623_9po9C UK003N 2026-03-30T12:02:04.888Z 2026-04-06T12:34:36.938Z
9592837 9592837 20260329033521_liDwl UK003N 2026-03-30T12:02:03.756Z 2026-04-06T12:34:36.653Z
9592434 9592434 20260329020546_sQRZL UK003N 2026-03-30T12:00:57.746Z 2026-04-06T12:34:10.354Z
9592425 9592425 20260329020531_Fpecy UK003N 2026-03-30T12:00:57.055Z 2026-04-06T12:34:10.104Z
9592281 9592281 20260329013816_aCGUa UK003N 2026-03-30T12:00:33.729Z 2026-04-06T12:33:58.670Z
9592273 9592273 20260329013439_DuJU9 UK003N 2026-03-30T12:00:31.624Z 2026-04-06T12:33:57.997Z
9592154 9592154 20260329011404_Plh6o UK003N 2026-03-30T12:00:14.311Z 2026-04-06T12:33:51.728Z
9589655 9589655 20260328035622_MGBN7 UK003N 2026-03-29T12:01:32.252Z 2026-04-06T12:37:30.568Z
9589608 9589608 20260328035038_Iax3d UK003N 2026-03-29T12:01:28.744Z 2026-04-06T12:37:28.863Z
9589432 9589432 20260328032850_Ujwr3 UK003N 2026-03-29T12:01:13.969Z 2026-04-06T12:37:23.395Z
9589260 9589260 20260328030301_ZVFUO UK003N 2026-03-29T12:01:00.034Z 2026-04-06T12:37:10.257Z
9585355 9585355 20260326002430_sSswi UK003N 2026-03-27T12:17:11.676Z 2026-04-03T12:39:57.963Z
9585275 9585275 20260326000710_7i2Df UK003N 2026-03-27T12:17:03.700Z 2026-04-03T12:39:53.806Z
9585185 9585185 20260325233831_6JvQk UK003N 2026-03-27T12:16:53.883Z 2026-04-03T12:39:51.256Z
9585046 9585046 20260325231302_05NVk UK003N 2026-03-27T12:16:36.385Z 2026-04-03T12:39:47.763Z
9584935 9584935 20260325224919_e6cXT UK003N 2026-03-27T12:16:24.735Z 2026-04-03T12:39:44.796Z
9584892 9584892 20260325223404_dgm1n UK003N 2026-03-27T12:16:18.654Z 2026-04-03T12:39:43.356Z
9584416 9584416 20260325195034_FFQv6 UK003N 2026-03-27T12:15:14.418Z 2026-04-03T12:39:13.484Z
9582144 9582144 20260326044210_xbVIN UK003N 2026-03-27T12:04:43.557Z 2026-04-04T12:39:38.750Z
9581978 9581978 20260326041922_VHYsD UK003N 2026-03-27T12:04:19.821Z 2026-04-04T12:39:33.836Z
9581880 9581880 20260326040816_I5D1a UK003N 2026-03-27T12:04:02.803Z 2026-04-04T12:39:24.497Z
9581860 9581860 20260326040338_79ILT UK003N 2026-03-27T12:03:59.415Z 2026-04-04T12:39:23.062Z
9581661 9581661 20260326034109_dvHg6 UK003N 2026-03-27T12:03:35.795Z 2026-04-04T12:39:13.809Z
9581509 9581509 20260326032323_etxby UK003N 2026-03-27T12:03:19.051Z 2026-04-04T12:39:09.242Z
9581447 9581447 20260326031446_o0HWz UK003N 2026-03-27T12:03:10.095Z 2026-04-04T12:39:06.584Z
9581346 9581346 20260326025621_moY4W UK003N 2026-03-27T12:02:49.314Z 2026-04-04T12:38:53.708Z
9581306 9581306 20260326024808_9Epol UK003N 2026-03-27T12:02:41.041Z 2026-04-04T12:38:52.161Z
9580875 9580875 20260326014843_VF9Ao UK003N 2026-03-27T12:01:37.499Z 2026-04-04T12:38:32.142Z
9580858 9580858 20260326014801_J51nm UK003N 2026-03-27T12:01:36.267Z 2026-04-04T12:38:31.619Z
9580710 9580710 20260326012133_Hm285 UK003N 2026-03-27T12:01:14.261Z 2026-04-04T12:38:21.397Z
9580659 9580659 20260326011407_0AJWI UK003N 2026-03-27T12:01:06.460Z 2026-04-04T12:38:20.017Z
9580573 9580573 20260326010430_gJg98 UK003N 2026-03-27T12:00:50.124Z 2026-04-04T12:38:14.519Z
9580453 9580453 20260326004953_mNBge UK003N 2026-03-27T12:00:30.918Z 2026-04-04T12:38:10.789Z
9579895 9579895 20260324231228_JKZSY UK003N 2026-03-26T12:14:38.242Z 2026-04-02T12:37:33.860Z
9579845 9579845 20260324230920_FLJIq UK003N 2026-03-26T12:14:34.562Z 2026-04-02T12:37:32.679Z
9579827 9579827 20260324230521_CUFCt UK003N 2026-03-26T12:14:33.078Z 2026-04-02T12:37:32.127Z
9577047 9577047 20260325034528_y0JE7 UK003N 2026-03-26T12:03:58.846Z 2026-04-03T12:36:30.877Z
9577040 9577040 20260325034406_xF9ir UK003N 2026-03-26T12:03:58.124Z 2026-04-03T12:36:30.572Z
9576998 9576998 20260325033715_FFuE0 UK003N 2026-03-26T12:03:51.891Z 2026-04-03T12:36:28.738Z
9576875 9576875 20260325032226_fJrbT UK003N 2026-03-26T12:03:32.803Z 2026-04-03T12:36:24.330Z
9576777 9576777 20260325030754_Kk3TI UK003N 2026-03-26T12:03:16.387Z 2026-04-03T12:36:20.775Z
9576172 9576172 20260325012802_XHRYw UK003N 2026-03-26T12:01:29.170Z 2026-04-03T12:35:47.172Z
9576092 9576092 20260325011129_2KgFv UK003N 2026-03-26T12:01:14.078Z 2026-04-03T12:35:43.701Z
9575875 9575875 20260325003158_9BWhD UK003N 2026-03-26T12:00:31.138Z 2026-04-03T12:35:27.410Z
9562966 9562966 20260323040937_QfnZu UK003N 2026-03-24T12:04:35.608Z 2026-03-31T12:26:30.980Z
9562890 9562890 20260323033407_Q2x2l UK003N 2026-03-24T12:04:20.378Z 2026-03-31T12:26:28.552Z
9562869 9562869 20260323033042_2nqij UK003N 2026-03-24T12:04:19.272Z 2026-03-31T12:26:28.291Z
9562860 9562860 20260323032817_JOHbY UK003N 2026-03-24T12:04:17.748Z 2026-03-31T12:26:28.043Z
9562851 9562851 20260323032739_EzAPo UK003N 2026-03-24T12:04:17.203Z 2026-03-31T12:26:27.972Z
9562703 9562703 20260323030325_RvKsq UK003N 2026-03-24T12:03:49.320Z 2026-03-31T12:26:23.611Z
9562508 9562508 20260323022725_C5ftx UK003N 2026-03-24T12:03:17.612Z 2026-03-31T12:26:13.236Z
9562420 9562420 20260323021952_hwTcN UK003N 2026-03-24T12:03:04.763Z 2026-03-31T12:26:10.045Z
9562377 9562377 20260323021605_giO2l UK003N 2026-03-24T12:02:57.105Z 2026-03-31T12:26:09.043Z
9562063 9562063 20260323012809_vXGBK UK003N 2026-03-24T12:02:03.655Z 2026-03-31T12:26:00.692Z
9561474 9561474 20260321233857_5h5IF UK003N 2026-03-23T12:12:20.079Z 2026-03-29T12:21:07.528Z
9561323 9561323 20260321232121_hix08 UK003N 2026-03-23T12:12:16.470Z 2026-03-29T12:21:06.357Z
9561267 9561267 20260321231405_3z2iH UK003N 2026-03-23T12:12:15.123Z 2026-03-29T12:21:06.037Z
9560722 9560722 20260321220520_HhDDh UK003N 2026-03-23T12:12:01.790Z 2026-03-29T12:21:02.362Z
9560108 9560108 20260321203259_DUxv6 UK003N 2026-03-23T12:11:38.230Z 2026-03-29T12:20:58.034Z
9559866 9559866 20260321200431_YkkI1 UK003N 2026-03-23T12:11:32.723Z 2026-03-29T12:20:56.185Z
9554258 9554258 20260322025400_qZZqB UK003N 2026-03-23T12:02:23.556Z 2026-03-30T12:28:01.430Z
9554144 9554144 20260322024312_6tSMT UK003N 2026-03-23T12:02:16.049Z 2026-03-30T12:27:59.011Z
9554098 9554098 20260322023931_zq2i9 UK003N 2026-03-23T12:02:14.152Z 2026-03-30T12:27:58.429Z
9553124 9553124 20260322011609_jEiAi UK003N 2026-03-23T12:01:14.476Z 2026-03-30T12:27:35.398Z
9552939 9552939 20260322005739_9M6LP UK003N 2026-03-23T12:01:02.349Z 2026-03-30T12:27:32.668Z
9552800 9552800 20260322004441_OaShs UK003N 2026-03-23T12:00:52.873Z 2026-03-30T12:27:30.607Z
9552748 9552748 20260322003919_j9EjZ UK003N 2026-03-23T12:00:48.386Z 2026-03-30T12:27:29.454Z
9552642 9552642 20260322002530_At7Do UK003N 2026-03-23T12:00:39.374Z 2026-03-30T12:27:27.333Z
9552608 9552608 20260322002404_mtEiT UK003N 2026-03-23T12:00:37.325Z 2026-03-30T12:27:27.053Z
9552220 9552220 20260320232306_90BHR UK003N 2026-03-22T12:27:33.541Z 2026-03-28T12:37:07.990Z
9551994 9551994 20260320223241_eIsnk UK003N 2026-03-22T12:27:21.982Z 2026-03-28T12:37:05.501Z
9543022 9543022 20260321022011_qBVj1 UK003N 2026-03-22T12:02:24.824Z 2026-03-29T12:19:01.539Z
9542417 9542417 20260320233216_uBWLd UK003N 2026-03-22T12:00:10.136Z 2026-03-29T12:18:43.688Z
9542155 9542155 20260319225424_XoODX UK003N 2026-03-21T12:29:49.123Z 2026-03-27T12:42:46.120Z
9535015 9535015 20260320050905_zqK6D UK003N 2026-03-21T12:09:29.732Z 2026-03-28T12:34:25.617Z
9534968 9534968 20260320044927_82wbN UK003N 2026-03-21T12:09:19.932Z 2026-03-28T12:34:24.263Z
9534830 9534830 20260320042842_ALfzv UK003N 2026-03-21T12:09:00.041Z 2026-03-28T12:34:22.722Z
9534737 9534737 20260320041648_dgcOj UK003N 2026-03-21T12:08:44.970Z 2026-03-28T12:34:21.505Z
9534496 9534496 20260320035232_4oJlF UK003N 2026-03-21T12:08:07.187Z 2026-03-28T12:34:18.834Z
9534333 9534333 20260320034200_h1jR2 UK003N 2026-03-21T12:07:43.155Z 2026-03-28T12:34:17.370Z
9534289 9534289 20260320034005_MkxGP UK003N 2026-03-21T12:07:38.495Z 2026-03-28T12:34:17.041Z
9533936 9533936 20260320030951_4YbIN UK003N 2026-03-21T12:06:41.441Z 2026-03-28T12:34:02.401Z
9533464 9533464 20260320023128_ldZSC UK003N 2026-03-21T12:05:28.095Z 2026-03-28T12:33:53.202Z
9533389 9533389 20260320022721_20YHH UK003N 2026-03-21T12:05:19.771Z 2026-03-28T12:33:52.615Z
9532584 9532584 20260320010947_24crB UK003N 2026-03-21T12:03:08.071Z 2026-03-28T12:33:34.425Z

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