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 = "UK0022" 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
9616648 9616648 20260406033949_NKDrZ UK0022 2026-04-07T12:13:10.689Z 2026-04-07T12:13:20.026Z
9616627 9616627 20260406033907_ykt2Y UK0022 2026-04-07T12:13:09.619Z 2026-04-07T12:13:20.022Z
9616342 9616342 20260406025419_p3klg UK0022 2026-04-07T12:12:38.940Z 2026-04-07T12:13:19.965Z
9615940 9615940 20260406020850_i8S22 UK0022 2026-04-07T12:11:53.918Z 2026-04-07T12:13:19.888Z
9615910 9615910 20260406020605_qxi2W UK0022 2026-04-07T12:11:46.422Z 2026-04-07T12:13:19.883Z
9615749 9615749 20260406014819_0Eqv1 UK0022 2026-04-07T12:11:29.132Z 2026-04-07T12:13:19.856Z
9615738 9615738 20260406014709_mLPWq UK0022 2026-04-07T12:11:28.057Z 2026-04-07T12:13:19.854Z
9614929 9614929 20260406000924_rWaEJ UK0022 2026-04-07T12:09:36.646Z 2026-04-07T12:13:19.699Z
9614778 9614778 20260405235144_dsGP0 UK0022 2026-04-07T12:09:23.345Z 2026-04-07T12:13:19.671Z
9614324 9614324 20260405225332_TmLfB UK0022 2026-04-07T12:08:25.267Z 2026-04-07T12:13:19.577Z
9613955 9613955 20260405214327_tobsz UK0022 2026-04-07T12:07:42.243Z 2026-04-07T12:13:19.492Z
9613464 9613464 20260405202251_zAiNX UK0022 2026-04-07T12:06:44.763Z 2026-04-07T12:13:19.388Z
9613452 9613452 20260405202224_kCdJ6 UK0022 2026-04-07T12:06:44.214Z 2026-04-07T12:13:19.387Z
9611892 9611892 20260406035501_ZIoVS UK0022 2026-04-07T12:00:09.521Z 2026-04-07T12:00:09.521Z
9608346 9608346 20260403221730_dovyh UK0022 2026-04-05T12:10:08.874Z 2026-04-07T12:18:08.506Z
9608264 9608264 20260403212616_46pq6 UK0022 2026-04-05T12:09:51.089Z 2026-04-07T12:18:06.215Z
9608185 9608185 20260403203902_ZhK6O UK0022 2026-04-05T12:09:20.082Z 2026-04-07T12:18:02.439Z
9595420 9595420 20260330035616_eZQ2n UK0022 2026-03-31T12:01:21.636Z 2026-04-07T12:24:04.123Z
9595361 9595361 20260330034716_AgQAD UK0022 2026-03-31T12:01:13.729Z 2026-04-07T12:24:02.528Z
9595257 9595257 20260330031159_Kv4Lv UK0022 2026-03-31T12:00:54.955Z 2026-04-07T12:23:59.515Z
9595186 9595186 20260330025805_Eq95j UK0022 2026-03-31T12:00:45.040Z 2026-04-07T12:23:58.099Z
9595154 9595154 20260330024027_OAOti UK0022 2026-03-31T12:00:38.207Z 2026-04-07T12:23:56.989Z
9595091 9595091 20260330022041_CXXw3 UK0022 2026-03-31T12:00:27.670Z 2026-04-07T12:23:55.143Z
9594978 9594978 20260329011237_xl1aA UK0022 2026-03-30T12:10:43.126Z 2026-04-06T12:40:22.187Z
9594830 9594830 20260329004013_4jjvv UK0022 2026-03-30T12:10:24.332Z 2026-04-06T12:40:17.497Z
9594728 9594728 20260329001739_7Igw0 UK0022 2026-03-30T12:10:14.307Z 2026-04-06T12:40:14.201Z
9594622 9594622 20260328233625_qbufz UK0022 2026-03-30T12:10:00.606Z 2026-04-06T12:40:01.950Z
9592847 9592847 20260329033623_9po9C UK0022 2026-03-30T12:02:04.888Z 2026-04-07T12:26:42.130Z
9592836 9592836 20260329033521_liDwl UK0022 2026-03-30T12:02:03.756Z 2026-04-07T12:26:41.932Z
9592786 9592786 20260329032309_QDQok UK0022 2026-03-30T12:01:56.355Z 2026-04-07T12:26:40.948Z
9592579 9592579 20260329023819_doxur UK0022 2026-03-30T12:01:21.663Z 2026-04-07T12:26:35.308Z
9592488 9592488 20260329021752_gs4yL UK0022 2026-03-30T12:01:07.038Z 2026-04-07T12:26:33.565Z
9592409 9592409 20260329020411_1uRNI UK0022 2026-03-30T12:00:55.066Z 2026-04-07T12:26:32.408Z
9592265 9592265 20260329013439_VX9IM UK0022 2026-03-30T12:00:31.096Z 2026-04-07T12:26:29.709Z
9592216 9592216 20260329012612_vjsAJ UK0022 2026-03-30T12:00:25.042Z 2026-04-07T12:26:28.858Z
9592153 9592153 20260329011404_Plh6o UK0022 2026-03-30T12:00:14.288Z 2026-04-07T12:26:27.717Z
9589743 9589743 20260328040520_ZnYMU UK0022 2026-03-29T12:01:36.748Z 2026-04-06T12:37:32.685Z
9589654 9589654 20260328035622_MGBN7 UK0022 2026-03-29T12:01:32.252Z 2026-04-06T12:37:30.568Z
9589643 9589643 20260328035456_XqFN3 UK0022 2026-03-29T12:01:31.216Z 2026-04-06T12:37:30.024Z
9589607 9589607 20260328035038_Iax3d UK0022 2026-03-29T12:01:28.744Z 2026-04-06T12:37:28.863Z
9589532 9589532 20260328034437_kkO0x UK0022 2026-03-29T12:01:24.428Z 2026-04-06T12:37:27.018Z
9589431 9589431 20260328032850_Ujwr3 UK0022 2026-03-29T12:01:13.969Z 2026-04-06T12:37:23.395Z
9589269 9589269 20260328030402_PqcG4 UK0022 2026-03-29T12:01:00.719Z 2026-04-06T12:37:10.503Z
9589049 9589049 20260328021921_B2uos UK0022 2026-03-29T12:00:41.018Z 2026-04-06T12:37:00.738Z
9588987 9588987 20260328020912_NqTCp UK0022 2026-03-29T12:00:36.401Z 2026-04-06T12:36:58.726Z
9585256 9585256 20260326000306_nnc7p UK0022 2026-03-27T12:17:00.952Z 2026-04-03T12:39:53.086Z
9585233 9585233 20260325234937_PIZhQ UK0022 2026-03-27T12:16:57.131Z 2026-04-03T12:39:52.141Z
9585184 9585184 20260325233831_6JvQk UK0022 2026-03-27T12:16:53.883Z 2026-04-03T12:39:51.256Z
9585163 9585163 20260325233750_ai2lA UK0022 2026-03-27T12:16:52.858Z 2026-04-03T12:39:50.946Z
9584891 9584891 20260325223404_dgm1n UK0022 2026-03-27T12:16:18.654Z 2026-04-03T12:39:43.356Z
9584794 9584794 20260325221604_zLrA2 UK0022 2026-03-27T12:16:08.890Z 2026-04-03T12:39:41.289Z
9584677 9584677 20260325213516_RH9Lh UK0022 2026-03-27T12:15:57.282Z 2026-04-03T12:39:26.294Z
9584659 9584659 20260325213230_7di4n UK0022 2026-03-27T12:15:55.370Z 2026-04-03T12:39:25.743Z
9584575 9584575 20260325204702_c30gE UK0022 2026-03-27T12:15:41.761Z 2026-04-03T12:39:22.457Z
9584415 9584415 20260325195034_FFQv6 UK0022 2026-03-27T12:15:14.418Z 2026-04-03T12:39:13.484Z
9582184 9582184 20260326044930_mRbtV UK0022 2026-03-27T12:04:51.082Z 2026-04-04T12:39:40.774Z
9582142 9582142 20260326044210_xbVIN UK0022 2026-03-27T12:04:43.557Z 2026-04-04T12:39:38.750Z
9581964 9581964 20260326041617_B5tBl UK0022 2026-03-27T12:04:16.607Z 2026-04-04T12:39:33.011Z
9581834 9581834 20260326040209_qYvff UK0022 2026-03-27T12:03:56.080Z 2026-04-04T12:39:21.997Z
9581705 9581705 20260326034648_I3GDI UK0022 2026-03-27T12:03:43.251Z 2026-04-04T12:39:16.071Z
9581660 9581660 20260326034109_dvHg6 UK0022 2026-03-27T12:03:35.795Z 2026-04-04T12:39:13.809Z
9581598 9581598 20260326033403_dtOb6 UK0022 2026-03-27T12:03:28.469Z 2026-04-04T12:39:11.702Z
9581508 9581508 20260326032323_etxby UK0022 2026-03-27T12:03:19.051Z 2026-04-04T12:39:09.242Z
9581305 9581305 20260326024808_9Epol UK0022 2026-03-27T12:02:41.041Z 2026-04-04T12:38:52.161Z
9581272 9581272 20260326024528_SocHO UK0022 2026-03-27T12:02:36.395Z 2026-04-04T12:38:51.307Z
9580572 9580572 20260326010430_gJg98 UK0022 2026-03-27T12:00:50.124Z 2026-04-04T12:38:14.519Z
9580500 9580500 20260326005712_yqcNF UK0022 2026-03-27T12:00:40.046Z 2026-04-04T12:38:12.553Z
9580443 9580443 20260326004951_TBMOf UK0022 2026-03-27T12:00:30.255Z 2026-04-04T12:38:10.666Z
9579893 9579893 20260324231228_JKZSY UK0022 2026-03-26T12:14:38.242Z 2026-04-02T12:37:33.860Z
9579843 9579843 20260324230920_FLJIq UK0022 2026-03-26T12:14:34.562Z 2026-04-02T12:37:32.679Z
9579752 9579752 20260324224243_6Yp3m UK0022 2026-03-26T12:14:20.388Z 2026-04-02T12:37:28.763Z
9577233 9577233 20260325042240_aVGN2 UK0022 2026-03-26T12:04:30.435Z 2026-04-03T12:36:52.741Z
9577161 9577161 20260325040548_3cC4j UK0022 2026-03-26T12:04:17.265Z 2026-04-03T12:36:36.769Z
9577134 9577134 20260325040157_2SvL6 UK0022 2026-03-26T12:04:14.074Z 2026-04-03T12:36:35.999Z
9577046 9577046 20260325034528_y0JE7 UK0022 2026-03-26T12:03:58.846Z 2026-04-03T12:36:30.877Z
9577039 9577039 20260325034406_xF9ir UK0022 2026-03-26T12:03:58.124Z 2026-04-03T12:36:30.572Z
9576874 9576874 20260325032226_fJrbT UK0022 2026-03-26T12:03:32.803Z 2026-04-03T12:36:24.330Z
9576775 9576775 20260325030754_Kk3TI UK0022 2026-03-26T12:03:16.387Z 2026-04-03T12:36:20.775Z
9576706 9576706 20260325025747_QHkG9 UK0022 2026-03-26T12:03:03.988Z 2026-04-03T12:36:18.436Z
9576487 9576487 20260325021934_L12Ek UK0022 2026-03-26T12:02:25.834Z 2026-04-03T12:36:01.383Z
9576397 9576397 20260325020121_hyQ3V UK0022 2026-03-26T12:02:07.200Z 2026-04-03T12:35:57.394Z
9576387 9576387 20260325015917_rRlkh UK0022 2026-03-26T12:02:05.045Z 2026-04-03T12:35:56.950Z
9576050 9576050 20260325010701_5hmI4 UK0022 2026-03-26T12:01:07.424Z 2026-04-03T12:35:42.482Z
9576014 9576014 20260325005835_OiIcc UK0022 2026-03-26T12:00:58.444Z 2026-04-03T12:35:40.856Z
9562868 9562868 20260323033042_2nqij UK0022 2026-03-24T12:04:19.272Z 2026-03-31T12:26:28.291Z
9562702 9562702 20260323030325_RvKsq UK0022 2026-03-24T12:03:49.320Z 2026-03-31T12:26:23.611Z
9562662 9562662 20260323025839_c1PCH UK0022 2026-03-24T12:03:43.247Z 2026-03-31T12:26:16.976Z
9562532 9562532 20260323022934_8L1uY UK0022 2026-03-24T12:03:20.505Z 2026-03-31T12:26:13.549Z
9562351 9562351 20260323021328_1xCHG UK0022 2026-03-24T12:02:54.393Z 2026-03-31T12:26:08.509Z
9562148 9562148 20260323013745_5sBi6 UK0022 2026-03-24T12:02:18.619Z 2026-03-31T12:26:02.395Z
9561457 9561457 20260321233614_EOD3o UK0022 2026-03-23T12:12:19.843Z 2026-03-29T12:21:07.434Z
9561412 9561412 20260321233128_SP63y UK0022 2026-03-23T12:12:18.619Z 2026-03-29T12:21:07.126Z
9561265 9561265 20260321231405_3z2iH UK0022 2026-03-23T12:12:15.123Z 2026-03-29T12:21:06.037Z
9561170 9561170 20260321230504_Y3t13 UK0022 2026-03-23T12:12:12.827Z 2026-03-29T12:21:05.467Z
9560720 9560720 20260321220520_HhDDh UK0022 2026-03-23T12:12:01.790Z 2026-03-29T12:21:02.362Z
9560709 9560709 20260321220511_62hTb UK0022 2026-03-23T12:12:01.529Z 2026-03-29T12:21:02.328Z
9560702 9560702 20260321220511_XIWQY UK0022 2026-03-23T12:12:01.453Z 2026-03-29T12:21:02.292Z
9560329 9560329 20260321210322_lC3DN UK0022 2026-03-23T12:11:43.017Z 2026-03-29T12:20:59.324Z
9560107 9560107 20260321203259_DUxv6 UK0022 2026-03-23T12:11:38.230Z 2026-03-29T12:20:58.033Z
9560078 9560078 20260321203119_mYzA2 UK0022 2026-03-23T12:11:37.564Z 2026-03-29T12:20:57.819Z

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