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,245 rows where station_code = "UK0004" 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
9273371 9273371 20260128055439_ihrXX UK0004 2026-01-29T14:29:29.384Z 2026-01-29T14:30:25.797Z
9273042 9273042 20260128042721_8DhL0 UK0004 2026-01-29T14:28:32.386Z 2026-01-29T14:30:25.740Z
9272984 9272984 20260128041506_ixChu UK0004 2026-01-29T14:28:22.422Z 2026-01-29T14:30:25.729Z
9272856 9272856 20260128035108_3VaGp UK0004 2026-01-29T14:28:03.673Z 2026-01-29T14:30:25.583Z
9272826 9272826 20260128034244_av1hv UK0004 2026-01-29T14:27:55.392Z 2026-01-29T14:30:25.578Z
9272791 9272791 20260128033820_vf4lS UK0004 2026-01-29T14:27:50.580Z 2026-01-29T14:30:25.562Z
9272787 9272787 20260128033737_xO30v UK0004 2026-01-29T14:27:49.672Z 2026-01-29T14:30:25.561Z
9272749 9272749 20260128031610_QyJGA UK0004 2026-01-29T14:27:42.111Z 2026-01-29T14:30:25.447Z
9272740 9272740 20260128031330_Pdmew UK0004 2026-01-29T14:27:39.946Z 2026-01-29T14:30:25.445Z
9272715 9272715 20260128031058_EX559 UK0004 2026-01-29T14:27:37.627Z 2026-01-29T14:30:25.442Z
9272499 9272499 20260128021831_Ge4OP UK0004 2026-01-29T14:26:59.854Z 2026-01-29T14:30:25.356Z
9272397 9272397 20260128015556_R37vM UK0004 2026-01-29T14:26:35.735Z 2026-01-29T14:30:25.342Z
9272301 9272301 20260128012940_HLLk2 UK0004 2026-01-29T14:26:21.961Z 2026-01-29T14:30:25.324Z
9272264 9272264 20260128010754_J9l4b UK0004 2026-01-29T14:26:09.380Z 2026-01-29T14:30:25.318Z
9272208 9272208 20260128004829_Kka6d UK0004 2026-01-29T14:25:56.773Z 2026-01-29T14:30:25.308Z
9272185 9272185 20260128003802_Jzh0t UK0004 2026-01-29T14:25:53.252Z 2026-01-29T14:30:25.296Z
9272113 9272113 20260128000306_n2Iyc UK0004 2026-01-29T14:25:39.257Z 2026-01-29T14:30:25.282Z
9272032 9272032 20260127231054_3TOsT UK0004 2026-01-29T14:25:21.445Z 2026-01-29T14:30:25.267Z
9272004 9272004 20260127225628_T9mkn UK0004 2026-01-29T14:25:17.216Z 2026-01-29T14:30:25.263Z
9271999 9271999 20260127225541_PIXBx UK0004 2026-01-29T14:25:16.603Z 2026-01-29T14:30:25.262Z
9271858 9271858 20260127211520_N7pPx UK0004 2026-01-29T14:24:37.773Z 2026-01-29T14:30:25.215Z
9256247 9256247 20260124062917_563K7 UK0004 2026-01-25T14:16:18.190Z 2026-01-29T14:48:30.796Z
9256223 9256223 20260124062412_ZL4wX UK0004 2026-01-25T14:16:15.516Z 2026-01-29T14:48:29.818Z
9255880 9255880 20260124051127_DTfze UK0004 2026-01-25T14:15:02.504Z 2026-01-29T14:48:03.118Z
9255877 9255877 20260124051121_G7x4s UK0004 2026-01-25T14:15:01.838Z 2026-01-29T14:48:02.761Z
9255850 9255850 20260124050917_ylGs6 UK0004 2026-01-25T14:14:59.255Z 2026-01-29T14:48:01.694Z
9255816 9255816 20260124050301_jExt1 UK0004 2026-01-25T14:14:53.967Z 2026-01-29T14:47:59.706Z
9255796 9255796 20260124045709_Apw8r UK0004 2026-01-25T14:14:45.122Z 2026-01-29T14:47:58.294Z
9255681 9255681 20260124042944_NsbL4 UK0004 2026-01-25T14:14:16.971Z 2026-01-29T14:47:50.851Z
9255630 9255630 20260124042240_OAv2G UK0004 2026-01-25T14:14:08.478Z 2026-01-29T14:47:48.387Z
9255610 9255610 20260124041934_lP5px UK0004 2026-01-25T14:14:06.308Z 2026-01-29T14:47:42.683Z
9255575 9255575 20260124041525_cuoME UK0004 2026-01-25T14:14:00.633Z 2026-01-29T14:47:40.859Z
9255457 9255457 20260124034159_SAmsY UK0004 2026-01-25T14:13:30.563Z 2026-01-29T14:47:31.794Z
9255442 9255442 20260124033600_0HU8T UK0004 2026-01-25T14:13:28.180Z 2026-01-29T14:47:31.084Z
9255381 9255381 20260124031549_agVOi UK0004 2026-01-25T14:13:08.837Z 2026-01-29T14:47:27.118Z
9255234 9255234 20260124015935_mUDcT UK0004 2026-01-25T14:12:29.265Z 2026-01-29T14:47:11.716Z
9254901 9254901 20260123222609_jrzin UK0004 2026-01-25T14:11:11.329Z 2026-01-29T14:46:54.378Z
9254827 9254827 20260123214040_TpAKx UK0004 2026-01-25T14:10:52.349Z 2026-01-29T14:46:44.450Z
9254795 9254795 20260123212411_Sidw2 UK0004 2026-01-25T14:10:46.515Z 2026-01-29T14:46:43.041Z
9254689 9254689 20260123204534_w6ky9 UK0004 2026-01-25T14:10:22.387Z 2026-01-29T14:46:35.904Z
9254666 9254666 20260123204125_NgFjt UK0004 2026-01-25T14:10:18.327Z 2026-01-29T14:46:34.805Z
9254622 9254622 20260123203101_rmhbu UK0004 2026-01-25T14:10:05.271Z 2026-01-29T14:46:32.784Z
9252365 9252365 20260123022814_z6d1v UK0004 2026-01-24T14:15:16.096Z 2026-01-29T14:52:46.957Z
9252338 9252338 20260123022216_8lOcw UK0004 2026-01-24T14:15:11.564Z 2026-01-29T14:52:45.875Z
9252315 9252315 20260123021333_yfzty UK0004 2026-01-24T14:15:05.755Z 2026-01-29T14:52:44.853Z
9252268 9252268 20260123020025_HeWhw UK0004 2026-01-24T14:14:53.327Z 2026-01-29T14:52:42.835Z
9252255 9252255 20260123015822_Vtc6C UK0004 2026-01-24T14:14:51.988Z 2026-01-29T14:52:42.264Z
9252229 9252229 20260123015251_PrTZU UK0004 2026-01-24T14:14:48.477Z 2026-01-29T14:52:40.971Z
9252226 9252226 20260123014946_wrJ4r UK0004 2026-01-24T14:14:47.465Z 2026-01-29T14:52:40.550Z
9252184 9252184 20260123013439_RLHKU UK0004 2026-01-24T14:14:40.918Z 2026-01-29T14:52:38.462Z
9251982 9251982 20260123001924_FHuAE UK0004 2026-01-24T14:13:52.837Z 2026-01-29T14:52:20.093Z
9237628 9237628 20260120054522_5p90k UK0004 2026-01-21T14:27:09.604Z 2026-01-28T15:01:33.771Z
9237384 9237384 20260120050912_ODFmy UK0004 2026-01-21T14:26:23.121Z 2026-01-28T15:01:23.017Z
9237206 9237206 20260120045034_VqYrW UK0004 2026-01-21T14:25:40.420Z 2026-01-28T15:01:02.776Z
9237139 9237139 20260120044122_L123H UK0004 2026-01-21T14:25:21.161Z 2026-01-28T15:00:59.608Z
9228793 9228793 20260118235231_LKETX UK0004 2026-01-20T14:19:33.325Z 2026-01-27T15:02:35.553Z
9228446 9228446 20260118222346_x6Ydi UK0004 2026-01-20T14:17:51.220Z 2026-01-27T15:02:01.617Z
9228345 9228345 20260118214653_mvxkY UK0004 2026-01-20T14:17:21.523Z 2026-01-27T15:01:55.099Z
9213234 9213234 20260116024220_ide4t UK0004 2026-01-17T14:16:00.976Z 2026-01-24T15:11:50.678Z
9213226 9213226 20260116024023_fbP1k UK0004 2026-01-17T14:15:59.466Z 2026-01-24T15:11:50.384Z
9213068 9213068 20260116020635_Xtxmy UK0004 2026-01-17T14:15:16.579Z 2026-01-24T15:11:39.306Z
9212982 9212982 20260116014531_qeoOO UK0004 2026-01-17T14:14:49.680Z 2026-01-24T15:11:36.393Z
9212953 9212953 20260116014242_kjkze UK0004 2026-01-17T14:14:44.330Z 2026-01-24T15:11:35.595Z
9212926 9212926 20260116014028_cnMhe UK0004 2026-01-17T14:14:38.186Z 2026-01-24T15:11:34.527Z
9212906 9212906 20260116013707_zYTNb UK0004 2026-01-17T14:14:30.961Z 2026-01-24T15:11:33.642Z
9212697 9212697 20260116002707_iTwWc UK0004 2026-01-17T14:13:21.097Z 2026-01-24T15:11:10.447Z
9212651 9212651 20260116000516_sKtP3 UK0004 2026-01-17T14:13:08.289Z 2026-01-24T15:11:08.974Z
9207538 9207538 20260115021307_ShxMc UK0004 2026-01-16T14:09:09.282Z 2026-01-22T15:03:24.517Z
9204239 9204239 20260114061741_ZzRS7 UK0004 2026-01-15T14:26:52.971Z 2026-01-22T15:10:22.793Z
9204186 9204186 20260114061408_9ClZb UK0004 2026-01-15T14:26:37.779Z 2026-01-22T15:10:21.979Z
9203986 9203986 20260114060230_y1zPY UK0004 2026-01-15T14:26:09.283Z 2026-01-22T15:10:16.646Z
9203844 9203844 20260114054440_VmhaT UK0004 2026-01-15T14:25:40.933Z 2026-01-22T15:10:14.318Z
9203841 9203841 20260114054440_vsrK2 UK0004 2026-01-15T14:25:40.460Z 2026-01-22T15:10:14.294Z
9203683 9203683 20260114052855_KbsHh UK0004 2026-01-15T14:25:11.086Z 2026-01-22T15:10:12.132Z
9203590 9203590 20260114052118_JZLHU UK0004 2026-01-15T14:24:58.820Z 2026-01-22T15:10:10.599Z
9203379 9203379 20260114045330_6qnOR UK0004 2026-01-15T14:24:12.407Z 2026-01-22T15:10:06.622Z
9194458 9194458 20260112205302_BqYaT UK0004 2026-01-14T14:09:20.761Z 2026-01-21T15:04:11.193Z
9194433 9194433 20260112204344_eGito UK0004 2026-01-14T14:09:13.340Z 2026-01-21T15:04:03.730Z
9182527 9182527 20260111053644_tp1RO UK0004 2026-01-12T14:14:51.947Z 2026-01-19T15:18:48.281Z
9180801 9180801 20260110224021_o8p8C UK0004 2026-01-12T14:08:25.273Z 2026-01-19T15:16:33.240Z
9180479 9180479 20260110203213_Q7rxD UK0004 2026-01-12T14:07:15.133Z 2026-01-19T15:16:12.327Z
9180471 9180471 20260110203115_Ylg2L UK0004 2026-01-12T14:07:13.265Z 2026-01-19T15:16:09.227Z
9176879 9176879 20260110063502_Djo1u UK0004 2026-01-11T14:10:15.232Z 2026-01-18T15:09:06.044Z
9176176 9176176 20260110045821_9q3g8 UK0004 2026-01-11T14:08:22.648Z 2026-01-18T15:08:22.979Z
9166914 9166914 20260107210010_q306f UK0004 2026-01-09T14:05:27.969Z 2026-01-16T15:10:29.982Z
9166403 9166403 20260107181501_9jpha UK0004 2026-01-09T14:03:03.716Z 2026-01-16T15:09:52.300Z
9163278 9163278 20260107061623_gmDc1 UK0004 2026-01-08T14:08:39.664Z 2026-01-13T15:03:07.894Z
9163039 9163039 20260107053344_X0kR0 UK0004 2026-01-08T14:07:54.170Z 2026-01-13T15:02:59.139Z
9160665 9160665 20260106064445_SBFYL UK0004 2026-01-07T14:13:21.244Z 2026-01-13T15:09:45.228Z
9160662 9160662 20260106064444_Aw3v4 UK0004 2026-01-07T14:13:20.610Z 2026-01-13T15:09:45.026Z
9160597 9160597 20260106063116_yXUjG UK0004 2026-01-07T14:13:07.157Z 2026-01-13T15:09:34.584Z
9160404 9160404 20260106054621_KvRGM UK0004 2026-01-07T14:12:30.430Z 2026-01-13T15:09:24.918Z
9160169 9160169 20260106045618_V07L1 UK0004 2026-01-07T14:11:37.992Z 2026-01-13T15:09:05.786Z
9160101 9160101 20260106044712_iwAi1 UK0004 2026-01-07T14:11:24.927Z 2026-01-13T15:09:00.830Z
9160059 9160059 20260106043819_ZJ1KX UK0004 2026-01-07T14:11:15.155Z 2026-01-13T15:08:58.618Z
9160001 9160001 20260106042847_fvdii UK0004 2026-01-07T14:11:03.377Z 2026-01-13T15:08:56.060Z
9159979 9159979 20260106042424_hYTCQ UK0004 2026-01-07T14:10:59.346Z 2026-01-13T15:08:55.072Z
9159973 9159973 20260106042345_Cx2jQ UK0004 2026-01-07T14:10:57.947Z 2026-01-13T15:08:54.663Z
9159951 9159951 20260106042114_2Qw14 UK0004 2026-01-07T14:10:55.694Z 2026-01-13T15:08:54.091Z
9159859 9159859 20260106040921_33W8T UK0004 2026-01-07T14:10:39.859Z 2026-01-13T15:08:50.858Z

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