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

553 rows where station_code = "UK00DJ" 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
8686073 8686073 20251203182643_oPO9i UK00DJ 2025-12-05T14:10:59.355Z 2025-12-05T14:14:35.291Z
8686015 8686015 20251203180907_eRLt9 UK00DJ 2025-12-05T14:10:43.005Z 2025-12-05T14:14:35.279Z
8680789 8680789 20251203012022_OGZCw UK00DJ 2025-12-04T14:12:55.834Z 2025-12-05T14:21:01.106Z
8680770 8680770 20251203011451_ZcvL3 UK00DJ 2025-12-04T14:12:53.198Z 2025-12-05T14:21:00.180Z
8680673 8680673 20251203005740_Tmsc4 UK00DJ 2025-12-04T14:12:37.060Z 2025-12-05T14:20:51.584Z
8680573 8680573 20251203003045_aLtii UK00DJ 2025-12-04T14:12:22.393Z 2025-12-05T14:20:44.869Z
8680549 8680549 20251203002722_d3XaX UK00DJ 2025-12-04T14:12:19.465Z 2025-12-05T14:20:43.954Z
8680171 8680171 20251202220038_3ZJVT UK00DJ 2025-12-04T14:11:20.523Z 2025-12-05T14:20:22.288Z
8677109 8677109 20251202065224_q12ZO UK00DJ 2025-12-03T14:26:18.712Z 2025-12-05T14:29:21.443Z
8676919 8676919 20251202063105_e249x UK00DJ 2025-12-03T14:25:56.183Z 2025-12-05T14:29:16.160Z
8676905 8676905 20251202063049_mlP9C UK00DJ 2025-12-03T14:25:55.509Z 2025-12-05T14:29:15.874Z
8676807 8676807 20251202062646_6ELPl UK00DJ 2025-12-03T14:25:47.323Z 2025-12-05T14:29:14.159Z
8676591 8676591 20251202060414_X52Ag UK00DJ 2025-12-03T14:25:20.321Z 2025-12-05T14:29:08.330Z
8676405 8676405 20251202055134_uPzBy UK00DJ 2025-12-03T14:25:11.278Z 2025-12-05T14:28:55.980Z
8676105 8676105 20251202053701_ezluA UK00DJ 2025-12-03T14:24:42.235Z 2025-12-05T14:28:48.593Z
8675906 8675906 20251202052254_3tSqW UK00DJ 2025-12-03T14:24:29.605Z 2025-12-05T14:28:43.853Z
8675877 8675877 20251202051953_YS4Pt UK00DJ 2025-12-03T14:24:27.986Z 2025-12-05T14:28:43.134Z
8675288 8675288 20251202042551_jyIyC UK00DJ 2025-12-03T14:23:29.301Z 2025-12-05T14:28:19.004Z
8675121 8675121 20251202040254_sNTtp UK00DJ 2025-12-03T14:23:04.523Z 2025-12-05T14:28:11.762Z
8675069 8675069 20251202035815_gxKCe UK00DJ 2025-12-03T14:22:59.696Z 2025-12-05T14:28:10.402Z
8675049 8675049 20251202035519_DVknV UK00DJ 2025-12-03T14:22:52.634Z 2025-12-05T14:28:09.948Z
8674940 8674940 20251202034221_pWiWq UK00DJ 2025-12-03T14:22:44.590Z 2025-12-05T14:28:07.155Z
8674926 8674926 20251202033952_JxcoJ UK00DJ 2025-12-03T14:22:43.588Z 2025-12-05T14:28:06.770Z
8674920 8674920 20251202033919_fAKpX UK00DJ 2025-12-03T14:22:43.254Z 2025-12-05T14:28:06.612Z
8674750 8674750 20251202031922_N2aBj UK00DJ 2025-12-03T14:22:17.693Z 2025-12-05T14:28:01.881Z
8674744 8674744 20251202031907_ukCzG UK00DJ 2025-12-03T14:22:17.247Z 2025-12-05T14:28:01.712Z
8674662 8674662 20251202030358_dR1KR UK00DJ 2025-12-03T14:22:11.198Z 2025-12-05T14:27:59.170Z
8674644 8674644 20251202030208_ehnZs UK00DJ 2025-12-03T14:22:10.311Z 2025-12-05T14:27:58.665Z
8674591 8674591 20251202025413_fyYTz UK00DJ 2025-12-03T14:22:05.822Z 2025-12-05T14:27:57.068Z
8674494 8674494 20251202023320_nrckE UK00DJ 2025-12-03T14:21:42.245Z 2025-12-05T14:27:43.859Z
8674385 8674385 20251202021440_J9OrS UK00DJ 2025-12-03T14:21:34.271Z 2025-12-05T14:27:40.015Z
8674265 8674265 20251202015509_tper3 UK00DJ 2025-12-03T14:21:18.177Z 2025-12-05T14:27:34.154Z
8674188 8674188 20251202014411_jBvNF UK00DJ 2025-12-03T14:21:08.064Z 2025-12-05T14:27:31.648Z
8674165 8674165 20251202014106_MvtLc UK00DJ 2025-12-03T14:21:06.695Z 2025-12-05T14:27:31.231Z
8674150 8674150 20251202013424_x0s7u UK00DJ 2025-12-03T14:21:00.527Z 2025-12-05T14:27:30.571Z
8674105 8674105 20251202012838_GGdn9 UK00DJ 2025-12-03T14:20:56.067Z 2025-12-05T14:27:28.713Z
8674018 8674018 20251202010905_4GH5q UK00DJ 2025-12-03T14:20:45.094Z 2025-12-05T14:27:26.310Z
8667454 8667454 20251130013431_xxseE UK00DJ 2025-12-02T14:38:15.120Z 2025-12-05T14:42:52.347Z
8662110 8662110 20251130175922_i6sht UK00DJ 2025-12-02T14:14:20.751Z 2025-12-05T14:33:06.797Z
8658655 8658655 20251125014135_2irP9 UK00DJ 2025-12-01T15:09:33.872Z 2025-12-02T15:08:17.136Z
8658608 8658608 20251126054031_Ugu2B UK00DJ 2025-12-01T15:05:02.646Z 2025-12-04T15:11:35.872Z
8658026 8658026 20251130062941_ERpmy UK00DJ 2025-12-01T14:34:51.672Z 2025-12-05T14:46:00.856Z
8657984 8657984 20251130062416_HXXzu UK00DJ 2025-12-01T14:34:48.657Z 2025-12-05T14:45:59.878Z
8657971 8657971 20251130062412_xBPmL UK00DJ 2025-12-01T14:34:48.402Z 2025-12-05T14:45:59.822Z
8656135 8656135 20251130043928_fnf9t UK00DJ 2025-12-01T14:28:05.579Z 2025-12-05T14:44:46.435Z
8655775 8655775 20251130041716_FBBEC UK00DJ 2025-12-01T14:27:27.600Z 2025-12-05T14:44:38.667Z
8655726 8655726 20251130041347_iRM2E UK00DJ 2025-12-01T14:27:23.284Z 2025-12-05T14:44:37.603Z
8655657 8655657 20251130041050_2J30U UK00DJ 2025-12-01T14:27:20.142Z 2025-12-05T14:44:36.726Z
8655282 8655282 20251130035215_3jaMh UK00DJ 2025-12-01T14:26:42.925Z 2025-12-05T14:44:31.000Z
8655227 8655227 20251130034918_b7qNd UK00DJ 2025-12-01T14:26:40.097Z 2025-12-05T14:44:29.974Z
8655061 8655061 20251130034210_NHNlI UK00DJ 2025-12-01T14:26:19.485Z 2025-12-05T14:44:27.268Z
8654893 8654893 20251130033806_RcZaC UK00DJ 2025-12-01T14:26:09.570Z 2025-12-05T14:44:25.578Z
8654802 8654802 20251130033318_7YSAb UK00DJ 2025-12-01T14:26:03.066Z 2025-12-05T14:44:24.022Z
8654249 8654249 20251130030514_ncKPb UK00DJ 2025-12-01T14:25:01.291Z 2025-12-05T14:43:51.776Z
8654055 8654055 20251130025513_3jfEo UK00DJ 2025-12-01T14:24:47.005Z 2025-12-05T14:43:45.686Z
8653989 8653989 20251130025036_Jz3bE UK00DJ 2025-12-01T14:24:34.352Z 2025-12-05T14:43:44.243Z
8653560 8653560 20251130022529_oBxi1 UK00DJ 2025-12-01T14:23:42.050Z 2025-12-05T14:43:34.921Z
8653426 8653426 20251130021511_5SLTE UK00DJ 2025-12-01T14:23:27.251Z 2025-12-05T14:43:31.061Z
8653315 8653315 20251130021009_lLHsm UK00DJ 2025-12-01T14:23:12.837Z 2025-12-05T14:43:28.667Z
8653095 8653095 20251130015540_3dMTR UK00DJ 2025-12-01T14:22:46.007Z 2025-12-05T14:43:03.177Z
8653081 8653081 20251130015456_v1ang UK00DJ 2025-12-01T14:22:45.254Z 2025-12-05T14:43:02.791Z
8653066 8653066 20251130015339_LXacU UK00DJ 2025-12-01T14:22:43.607Z 2025-12-05T14:43:02.286Z
8652786 8652786 20251130013433_387aK UK00DJ 2025-12-01T14:22:07.102Z 2025-12-05T14:42:52.410Z
8652595 8652595 20251130012247_4nBP2 UK00DJ 2025-12-01T14:21:50.775Z 2025-12-05T14:42:48.516Z
8652411 8652411 20251130010711_bedfD UK00DJ 2025-12-01T14:21:21.403Z 2025-12-05T14:42:43.934Z
8652335 8652335 20251130010316_tv79o UK00DJ 2025-12-01T14:21:16.476Z 2025-12-05T14:42:42.895Z
8652015 8652015 20251130004042_08Qt7 UK00DJ 2025-12-01T14:20:28.057Z 2025-12-05T14:42:13.463Z
8651992 8651992 20251130003955_uiEkR UK00DJ 2025-12-01T14:20:23.710Z 2025-12-05T14:42:12.869Z
8651884 8651884 20251130003027_TYuQR UK00DJ 2025-12-01T14:20:11.143Z 2025-12-05T14:42:10.360Z
8651805 8651805 20251130002015_CO0ZN UK00DJ 2025-12-01T14:19:57.255Z 2025-12-05T14:42:06.545Z
8651662 8651662 20251130000854_C6I2K UK00DJ 2025-12-01T14:19:39.238Z 2025-12-05T14:42:02.975Z
8644899 8644899 20251128201213_NrzDY UK00DJ 2025-11-30T14:22:50.847Z 2025-12-05T14:50:28.929Z
8644658 8644658 20251128194031_qNLYp UK00DJ 2025-11-30T14:22:12.687Z 2025-12-05T14:50:25.272Z
8644559 8644559 20251128193230_uKIZE UK00DJ 2025-11-30T14:22:06.163Z 2025-12-05T14:50:23.633Z
8643889 8643889 20251128183555_ueIx5 UK00DJ 2025-11-30T14:20:47.157Z 2025-12-05T14:49:58.629Z
8637601 8637601 20251128055855_NKgzk UK00DJ 2025-11-29T14:27:37.037Z 2025-12-05T15:00:09.843Z
8637516 8637516 20251128054633_enWIe UK00DJ 2025-11-29T14:27:31.699Z 2025-12-05T14:59:56.883Z
8637261 8637261 20251128052115_wwYzW UK00DJ 2025-11-29T14:27:01.682Z 2025-12-05T14:59:39.459Z
8637019 8637019 20251128045019_jXGYC UK00DJ 2025-11-29T14:26:33.493Z 2025-12-05T14:59:36.090Z
8636951 8636951 20251128044028_ZyvFy UK00DJ 2025-11-29T14:26:23.052Z 2025-12-05T14:59:33.024Z
8636807 8636807 20251128042904_1x33C UK00DJ 2025-11-29T14:26:13.162Z 2025-12-05T14:59:30.061Z
8636670 8636670 20251128041543_GV55y UK00DJ 2025-11-29T14:26:03.578Z 2025-12-05T14:59:27.872Z
8636621 8636621 20251128040946_OiXGa UK00DJ 2025-11-29T14:25:46.001Z 2025-12-05T14:59:26.945Z
8636512 8636512 20251128035445_0uOmv UK00DJ 2025-11-29T14:25:36.038Z 2025-12-05T14:59:25.263Z
8635126 8635126 20251128014443_00n2t UK00DJ 2025-11-29T14:22:42.044Z 2025-12-05T14:58:30.798Z
8635093 8635093 20251128014017_gVM2S UK00DJ 2025-11-29T14:22:39.884Z 2025-12-05T14:58:30.311Z
8635067 8635067 20251128013825_J6gUB UK00DJ 2025-11-29T14:22:37.330Z 2025-12-05T14:58:28.606Z
8634542 8634542 20251128005557_XTLpj UK00DJ 2025-11-29T14:21:31.264Z 2025-12-05T14:58:21.659Z
8634516 8634516 20251128005457_6ienv UK00DJ 2025-11-29T14:21:26.523Z 2025-12-05T14:58:21.464Z
8634105 8634105 20251128002113_R4Db4 UK00DJ 2025-11-29T14:20:45.375Z 2025-12-05T14:58:16.379Z
8633972 8633972 20251128000848_Db7vL UK00DJ 2025-11-29T14:20:33.692Z 2025-12-05T14:58:14.720Z
8633875 8633875 20251128000045_WgAbt UK00DJ 2025-11-29T14:20:27.725Z 2025-12-05T14:58:13.531Z
8633436 8633436 20251127231710_36VZM UK00DJ 2025-11-29T14:19:43.263Z 2025-12-05T14:57:38.309Z
8633036 8633036 20251127223245_bbDc4 UK00DJ 2025-11-29T14:18:53.015Z 2025-12-05T14:56:58.159Z
8633003 8633003 20251127222847_GkgTM UK00DJ 2025-11-29T14:18:48.488Z 2025-12-05T14:56:55.477Z
8632787 8632787 20251127215431_x0lP4 UK00DJ 2025-11-29T14:18:22.578Z 2025-12-05T14:56:42.283Z
8632693 8632693 20251127213931_6Efm7 UK00DJ 2025-11-29T14:18:01.386Z 2025-12-05T14:56:32.884Z
8632656 8632656 20251127213108_dc6LI UK00DJ 2025-11-29T14:17:57.316Z 2025-12-05T14:56:29.166Z
8632624 8632624 20251127212705_Eji2K UK00DJ 2025-11-29T14:17:53.730Z 2025-12-05T14:56:27.822Z
8632241 8632241 20251127204421_V3GAI UK00DJ 2025-11-29T14:17:10.795Z 2025-12-05T14:56:18.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