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 = "UK00AN" 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
9272963 9272963 20260128041132_JT3M2 UK00AN 2026-01-29T14:28:19.086Z 2026-01-29T14:30:25.724Z
9272906 9272906 20260128035850_h0dbG UK00AN 2026-01-29T14:28:13.326Z 2026-01-29T14:30:25.705Z
9272886 9272886 20260128035751_oYe63 UK00AN 2026-01-29T14:28:12.002Z 2026-01-29T14:30:25.703Z
9272868 9272868 20260128035401_sM26T UK00AN 2026-01-29T14:28:04.592Z 2026-01-29T14:30:25.700Z
9272683 9272683 20260128030051_2Ey2F UK00AN 2026-01-29T14:27:27.840Z 2026-01-29T14:30:25.438Z
9272633 9272633 20260128025020_wgSPd UK00AN 2026-01-29T14:27:16.009Z 2026-01-29T14:30:25.403Z
9272621 9272621 20260128024909_Af6ae UK00AN 2026-01-29T14:27:14.824Z 2026-01-29T14:30:25.383Z
9272064 9272064 20260127233250_c6930 UK00AN 2026-01-29T14:25:26.351Z 2026-01-29T14:30:25.273Z
9272010 9272010 20260127225628_T9mkn UK00AN 2026-01-29T14:25:17.217Z 2026-01-29T14:30:25.263Z
9271948 9271948 20260127221520_IKNGN UK00AN 2026-01-29T14:25:01.595Z 2026-01-29T14:30:25.234Z
9271934 9271934 20260127220413_aSkFF UK00AN 2026-01-29T14:24:59.645Z 2026-01-29T14:30:25.232Z
9271881 9271881 20260127212449_H81Jq UK00AN 2026-01-29T14:24:42.286Z 2026-01-29T14:30:25.217Z
9271872 9271872 20260127211707_DsgGa UK00AN 2026-01-29T14:24:41.219Z 2026-01-29T14:30:25.216Z
9271861 9271861 20260127211520_N7pPx UK00AN 2026-01-29T14:24:37.805Z 2026-01-29T14:30:25.215Z
9256176 9256176 20260124060620_s8L4z UK00AN 2026-01-25T14:16:06.475Z 2026-01-29T14:48:27.133Z
9256121 9256121 20260124055909_eXz27 UK00AN 2026-01-25T14:15:55.040Z 2026-01-29T14:48:24.340Z
9256085 9256085 20260124055058_djUpU UK00AN 2026-01-25T14:15:44.661Z 2026-01-29T14:48:21.926Z
9256039 9256039 20260124054633_Pijqm UK00AN 2026-01-25T14:15:36.894Z 2026-01-29T14:48:19.265Z
9255945 9255945 20260124052954_3l5d0 UK00AN 2026-01-25T14:15:13.519Z 2026-01-29T14:48:09.143Z
9255884 9255884 20260124051127_DTfze UK00AN 2026-01-25T14:15:02.505Z 2026-01-29T14:48:03.118Z
9255845 9255845 20260124050859_gb8GQ UK00AN 2026-01-25T14:14:58.256Z 2026-01-29T14:48:01.377Z
9255826 9255826 20260124050400_093ac UK00AN 2026-01-25T14:14:55.048Z 2026-01-29T14:48:00.091Z
9255797 9255797 20260124045709_Apw8r UK00AN 2026-01-25T14:14:45.122Z 2026-01-29T14:47:58.294Z
9255709 9255709 20260124043644_gpi6d UK00AN 2026-01-25T14:14:27.234Z 2026-01-29T14:47:53.211Z
9255666 9255666 20260124042822_ObJ4f UK00AN 2026-01-25T14:14:13.976Z 2026-01-29T14:47:50.040Z
9255652 9255652 20260124042413_OiFge UK00AN 2026-01-25T14:14:10.761Z 2026-01-29T14:47:49.356Z
9255631 9255631 20260124042240_OAv2G UK00AN 2026-01-25T14:14:08.478Z 2026-01-29T14:47:48.387Z
9255611 9255611 20260124041934_lP5px UK00AN 2026-01-25T14:14:06.308Z 2026-01-29T14:47:42.683Z
9255494 9255494 20260124035105_fDLtJ UK00AN 2026-01-25T14:13:37.824Z 2026-01-29T14:47:34.146Z
9255194 9255194 20260124013517_Wu3RD UK00AN 2026-01-25T14:12:14.896Z 2026-01-29T14:47:07.407Z
9255178 9255178 20260124012814_aW03q UK00AN 2026-01-25T14:12:10.003Z 2026-01-29T14:47:06.369Z
9255127 9255127 20260124010258_jf3XM UK00AN 2026-01-25T14:11:58.447Z 2026-01-29T14:47:03.632Z
9255064 9255064 20260124003730_fvqu6 UK00AN 2026-01-25T14:11:45.525Z 2026-01-29T14:47:01.022Z
9255046 9255046 20260124003226_ZgOma UK00AN 2026-01-25T14:11:43.415Z 2026-01-29T14:47:00.453Z
9255036 9255036 20260124002827_TWGF5 UK00AN 2026-01-25T14:11:42.590Z 2026-01-29T14:47:00.288Z
9255019 9255019 20260124002237_YcetE UK00AN 2026-01-25T14:11:38.963Z 2026-01-29T14:46:59.818Z
9254952 9254952 20260123232704_YHvlO UK00AN 2026-01-25T14:11:26.569Z 2026-01-29T14:46:57.008Z
9254923 9254923 20260123230115_mP0PV UK00AN 2026-01-25T14:11:17.207Z 2026-01-29T14:46:55.300Z
9252779 9252779 20260123061953_sDn9R UK00AN 2026-01-24T14:17:06.745Z 2026-01-29T14:53:24.520Z
9252754 9252754 20260123060741_w9aKm UK00AN 2026-01-24T14:17:01.363Z 2026-01-29T14:53:22.897Z
9252625 9252625 20260123044931_0xh25 UK00AN 2026-01-24T14:16:29.496Z 2026-01-29T14:53:12.225Z
9252615 9252615 20260123044605_1RGew UK00AN 2026-01-24T14:16:28.101Z 2026-01-29T14:53:11.799Z
9252572 9252572 20260123041810_JL6Me UK00AN 2026-01-24T14:16:13.735Z 2026-01-29T14:53:09.072Z
9252518 9252518 20260123034611_nC92u UK00AN 2026-01-24T14:15:59.749Z 2026-01-29T14:53:05.334Z
9252492 9252492 20260123033134_hHrxg UK00AN 2026-01-24T14:15:51.933Z 2026-01-29T14:53:04.130Z
9252197 9252197 20260123014011_12Xx4 UK00AN 2026-01-24T14:14:42.739Z 2026-01-29T14:52:38.895Z
9244169 9244169 20260121062747_CNPxf UK00AN 2026-01-22T14:24:30.457Z 2026-01-29T15:05:54.526Z
9244111 9244111 20260121061337_sFBil UK00AN 2026-01-22T14:24:10.341Z 2026-01-29T15:05:52.057Z
9244014 9244014 20260121055543_f1G0L UK00AN 2026-01-22T14:23:56.017Z 2026-01-29T15:05:47.458Z
9243918 9243918 20260121053307_b6dIZ UK00AN 2026-01-22T14:23:30.844Z 2026-01-29T15:05:34.440Z
9243875 9243875 20260121052854_VgEfZ UK00AN 2026-01-22T14:23:24.122Z 2026-01-29T15:05:30.828Z
9243754 9243754 20260121051231_9qaXR UK00AN 2026-01-22T14:22:54.984Z 2026-01-29T15:05:26.057Z
9243697 9243697 20260121050618_asgG6 UK00AN 2026-01-22T14:22:46.776Z 2026-01-29T15:05:23.798Z
9243672 9243672 20260121050404_MPh3p UK00AN 2026-01-22T14:22:42.863Z 2026-01-29T15:05:22.753Z
9243600 9243600 20260121045103_RcwD1 UK00AN 2026-01-22T14:22:18.601Z 2026-01-29T15:05:19.482Z
9243569 9243569 20260121044838_Iaeak UK00AN 2026-01-22T14:22:13.750Z 2026-01-29T15:05:18.267Z
9243562 9243562 20260121044809_GYHe6 UK00AN 2026-01-22T14:22:13.069Z 2026-01-29T15:05:18.058Z
9243370 9243370 20260121042306_jlCpP UK00AN 2026-01-22T14:21:33.238Z 2026-01-29T15:04:57.283Z
9243359 9243359 20260121042101_asesF UK00AN 2026-01-22T14:21:31.568Z 2026-01-29T15:04:56.885Z
9243225 9243225 20260121040045_M9eBq UK00AN 2026-01-22T14:20:59.447Z 2026-01-29T15:04:51.443Z
9243220 9243220 20260121040033_ftUZ7 UK00AN 2026-01-22T14:20:59.021Z 2026-01-29T15:04:51.393Z
9243155 9243155 20260121034937_swgHw UK00AN 2026-01-22T14:20:48.189Z 2026-01-29T15:04:48.695Z
9236868 9236868 20260120041228_2dwXC UK00AN 2026-01-21T14:24:24.373Z 2026-01-28T15:00:40.129Z
9223157 9223157 20260117233005_QCW2V UK00AN 2026-01-19T14:17:57.252Z 2026-01-26T15:01:55.940Z
9217924 9217924 20260116204738_irElL UK00AN 2026-01-18T14:09:36.878Z 2026-01-25T14:57:52.153Z
9217896 9217896 20260116202356_T8wgu UK00AN 2026-01-18T14:09:30.622Z 2026-01-25T14:57:51.135Z
9217800 9217800 20260116195235_KkotQ UK00AN 2026-01-18T14:09:04.093Z 2026-01-25T14:57:48.146Z
9217593 9217593 20260116181641_hhYGg UK00AN 2026-01-18T14:08:06.692Z 2026-01-25T14:57:27.407Z
9213883 9213883 20260116045714_Fj5oJ UK00AN 2026-01-17T14:18:59.653Z 2026-01-24T15:12:50.292Z
9213738 9213738 20260116043315_I2YqU UK00AN 2026-01-17T14:18:18.097Z 2026-01-24T15:12:32.887Z
9213521 9213521 20260116035310_ch866 UK00AN 2026-01-17T14:17:20.242Z 2026-01-24T15:12:19.435Z
9213496 9213496 20260116034704_YhsxW UK00AN 2026-01-17T14:17:10.542Z 2026-01-24T15:12:18.110Z
9213481 9213481 20260116034645_lwVk5 UK00AN 2026-01-17T14:17:08.859Z 2026-01-24T15:12:17.462Z
9213432 9213432 20260116033006_hTtFS UK00AN 2026-01-17T14:16:52.124Z 2026-01-24T15:12:13.618Z
9213421 9213421 20260116032739_28FHN UK00AN 2026-01-17T14:16:50.722Z 2026-01-24T15:12:13.224Z
9213367 9213367 20260116031838_lZu8f UK00AN 2026-01-17T14:16:38.477Z 2026-01-24T15:12:10.964Z
9213282 9213282 20260116030249_o073e UK00AN 2026-01-17T14:16:16.507Z 2026-01-24T15:12:07.242Z
9213221 9213221 20260116023915_MZiOd UK00AN 2026-01-17T14:15:58.267Z 2026-01-24T15:11:50.100Z
9213055 9213055 20260116020211_Zqa2e UK00AN 2026-01-17T14:15:11.560Z 2026-01-24T15:11:38.828Z
9212910 9212910 20260116013708_X4rQx UK00AN 2026-01-17T14:14:31.480Z 2026-01-24T15:11:33.804Z
9212633 9212633 20260115234951_0CbzI UK00AN 2026-01-17T14:13:02.373Z 2026-01-24T15:11:07.914Z
9208194 9208194 20260115043207_3jquF UK00AN 2026-01-16T14:11:39.362Z 2026-01-22T15:04:03.705Z
9208122 9208122 20260115041800_seD6y UK00AN 2026-01-16T14:11:24.203Z 2026-01-22T15:04:01.935Z
9208094 9208094 20260115041238_Heq5Q UK00AN 2026-01-16T14:11:18.183Z 2026-01-22T15:04:01.016Z
9208030 9208030 20260115040137_7FFEY UK00AN 2026-01-16T14:11:03.563Z 2026-01-22T15:03:59.294Z
9208020 9208020 20260115035735_Mkj84 UK00AN 2026-01-16T14:11:00.707Z 2026-01-22T15:03:58.702Z
9208017 9208017 20260115035735_aEp9H UK00AN 2026-01-16T14:10:59.561Z 2026-01-22T15:03:58.652Z
9207998 9207998 20260115035107_FiRVp UK00AN 2026-01-16T14:10:56.299Z 2026-01-22T15:03:58.229Z
9207452 9207452 20260115014256_RzUhj UK00AN 2026-01-16T14:08:48.306Z 2026-01-22T15:03:22.288Z
9207422 9207422 20260115013348_qhYz1 UK00AN 2026-01-16T14:08:41.720Z 2026-01-22T15:03:21.502Z
9207366 9207366 20260115011135_eoqyg UK00AN 2026-01-16T14:08:26.544Z 2026-01-22T15:03:19.929Z
9204381 9204381 20260114063432_jOntL UK00AN 2026-01-15T14:27:11.040Z 2026-01-22T15:10:26.670Z
9204364 9204364 20260114063012_sQYhw UK00AN 2026-01-15T14:27:08.175Z 2026-01-22T15:10:25.378Z
9204317 9204317 20260114062557_0wd6j UK00AN 2026-01-15T14:27:02.379Z 2026-01-22T15:10:24.698Z
9204287 9204287 20260114062514_nVxvP UK00AN 2026-01-15T14:27:00.691Z 2026-01-22T15:10:24.499Z
9204223 9204223 20260114061616_qhG6f UK00AN 2026-01-15T14:26:50.702Z 2026-01-22T15:10:22.516Z
9204117 9204117 20260114060824_PUpaF UK00AN 2026-01-15T14:26:26.612Z 2026-01-22T15:10:18.323Z
9204022 9204022 20260114060337_Buh3O UK00AN 2026-01-15T14:26:16.497Z 2026-01-22T15:10:17.029Z
9203831 9203831 20260114054131_Cbnqr UK00AN 2026-01-15T14:25:38.169Z 2026-01-22T15:10:13.992Z
9203700 9203700 20260114053051_jYNp7 UK00AN 2026-01-15T14:25:13.099Z 2026-01-22T15:10:12.404Z

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