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

4,376 rows where station_code = "RU0009" 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
8690481 8690481 20251204235344_46Z2o RU0009 2025-12-06T14:14:29.804Z 2025-12-06T14:18:00.890Z
8690388 8690388 20251204231801_9rQ7I RU0009 2025-12-06T14:14:08.545Z 2025-12-06T14:18:00.870Z
8690131 8690131 20251204211326_ICbfd RU0009 2025-12-06T14:13:27.438Z 2025-12-06T14:18:00.821Z
8689974 8689974 20251204191718_yzYiX RU0009 2025-12-06T14:12:49.243Z 2025-12-06T14:18:00.775Z
8689942 8689942 20251204185453_gju3q RU0009 2025-12-06T14:12:38.051Z 2025-12-06T14:18:00.766Z
8689901 8689901 20251204175700_AcAeR RU0009 2025-12-06T14:12:29.800Z 2025-12-06T14:18:00.752Z
8689817 8689817 20251204160934_u0Uli RU0009 2025-12-06T14:12:07.107Z 2025-12-06T14:18:00.712Z
8687078 8687078 20251204031551_Ou83B RU0009 2025-12-05T14:13:49.965Z 2025-12-06T14:22:29.066Z
8686235 8686235 20251203191337_MCeiT RU0009 2025-12-05T14:11:19.311Z 2025-12-06T14:21:36.733Z
8654432 8654432 20251130031615_JktlM RU0009 2025-12-01T14:25:24.477Z 2025-12-06T14:48:42.286Z
8653762 8653762 20251130023909_iW6gQ RU0009 2025-12-01T14:24:11.926Z 2025-12-06T14:48:31.601Z
8652973 8652973 20251130014833_aT1zI RU0009 2025-12-01T14:22:35.998Z 2025-12-06T14:47:47.211Z
8652814 8652814 20251130013623_HFcG3 RU0009 2025-12-01T14:22:09.963Z 2025-12-06T14:47:42.919Z
8651995 8651995 20251130004000_V7baH RU0009 2025-12-01T14:20:25.124Z 2025-12-06T14:46:57.435Z
8651739 8651739 20251130001550_jlXYg RU0009 2025-12-01T14:19:48.243Z 2025-12-06T14:46:53.265Z
8651487 8651487 20251129234657_ysO2V RU0009 2025-12-01T14:19:12.272Z 2025-12-06T14:46:47.424Z
8651430 8651430 20251129234150_LLucT RU0009 2025-12-01T14:19:06.794Z 2025-12-06T14:46:46.106Z
8651204 8651204 20251129230500_H5YIO RU0009 2025-12-01T14:18:23.227Z 2025-12-06T14:46:41.865Z
8651054 8651054 20251129223508_sNPrN RU0009 2025-12-01T14:17:54.872Z 2025-12-06T14:46:39.032Z
8650953 8650953 20251129221124_3KzM8 RU0009 2025-12-01T14:17:36.662Z 2025-12-06T14:46:36.566Z
8650586 8650586 20251129204454_FqxGx RU0009 2025-12-01T14:16:33.185Z 2025-12-06T14:46:16.992Z
8650530 8650530 20251129203618_iiYdT RU0009 2025-12-01T14:16:24.077Z 2025-12-06T14:46:02.292Z
8650402 8650402 20251129200932_2ZuEn RU0009 2025-12-01T14:16:02.348Z 2025-12-06T14:45:55.665Z
8649824 8649824 20251129183614_D5Hgs RU0009 2025-12-01T14:14:03.690Z 2025-12-06T14:45:40.687Z
8646480 8646480 20251129021013_R1o4N RU0009 2025-11-30T14:26:03.785Z 2025-12-06T14:56:09.789Z
8646307 8646307 20251129014351_yZ3mH RU0009 2025-11-30T14:25:49.190Z 2025-12-06T14:55:56.210Z
8646235 8646235 20251129013004_R9kQa RU0009 2025-11-30T14:25:34.147Z 2025-12-06T14:55:48.014Z
8644360 8644360 20251128192335_K4ZJk RU0009 2025-11-30T14:21:52.525Z 2025-12-06T14:54:41.324Z
8642883 8642883 20251128170017_tcDRT RU0009 2025-11-30T14:18:50.082Z 2025-12-06T14:53:37.473Z
8636074 8636074 20251128031256_y9Xaf RU0009 2025-11-29T14:24:52.153Z 2025-12-06T15:02:55.896Z
8635624 8635624 20251128023329_zsjj5 RU0009 2025-11-29T14:23:57.327Z 2025-12-06T15:02:47.360Z
8634750 8634750 20251128011631_rMjpw RU0009 2025-11-29T14:22:01.033Z 2025-12-06T15:02:35.141Z
8634702 8634702 20251128011102_VMmZD RU0009 2025-11-29T14:21:57.468Z 2025-12-06T15:02:31.838Z
8634687 8634687 20251128011038_uhUBV RU0009 2025-11-29T14:21:56.024Z 2025-12-06T15:02:29.965Z
8633943 8633943 20251128000803_uDZTk RU0009 2025-11-29T14:20:32.584Z 2025-12-06T15:01:49.854Z
8633906 8633906 20251128000340_SV2ba RU0009 2025-11-29T14:20:29.966Z 2025-12-06T15:01:49.401Z
8632820 8632820 20251127220039_lqyov RU0009 2025-11-29T14:18:26.382Z 2025-12-06T15:01:33.862Z
8632818 8632818 20251127220020_qLsfc RU0009 2025-11-29T14:18:25.960Z 2025-12-06T15:01:33.822Z
8632641 8632641 20251127212841_EIh75 RU0009 2025-11-29T14:17:55.441Z 2025-12-06T15:01:31.795Z
8632487 8632487 20251127211304_dQRxt RU0009 2025-11-29T14:17:43.602Z 2025-12-06T15:01:21.362Z
8632383 8632383 20251127205928_Zbo1M RU0009 2025-11-29T14:17:23.627Z 2025-12-06T15:01:14.556Z
8631927 8631927 20251127201528_3TH7B RU0009 2025-11-29T14:16:34.685Z 2025-12-06T15:00:46.933Z
8631614 8631614 20251127193408_ZzZV2 RU0009 2025-11-29T14:15:50.957Z 2025-12-06T15:00:25.732Z
8631378 8631378 20251127185619_NPuOK RU0009 2025-11-29T14:15:11.661Z 2025-12-06T15:00:07.200Z
8630739 8630739 20251127171133_1igW2 RU0009 2025-11-29T14:13:38.563Z 2025-12-06T14:59:23.701Z
8630537 8630537 20251127163850_k2YNl RU0009 2025-11-29T14:12:53.670Z 2025-12-06T14:59:10.187Z
8630473 8630473 20251127162500_sj81f RU0009 2025-11-29T14:12:45.603Z 2025-12-06T14:59:07.425Z
8630218 8630218 20251127152115_cO0Xv RU0009 2025-11-29T14:12:07.207Z 2025-12-06T14:59:00.460Z
8624091 8624091 20251127030435_nGHIF RU0009 2025-11-28T14:23:45.656Z 2025-12-05T15:04:43.989Z
8623923 8623923 20251127022758_opqPj RU0009 2025-11-28T14:23:06.846Z 2025-12-05T15:04:26.183Z
8623853 8623853 20251127021610_7VfGs RU0009 2025-11-28T14:22:59.793Z 2025-12-05T15:04:21.040Z
8606711 8606711 20251125193041_xpCPf RU0009 2025-11-27T14:11:00.739Z 2025-12-04T15:06:49.089Z
8606680 8606680 20251125192347_mlzn0 RU0009 2025-11-27T14:10:53.208Z 2025-12-04T15:06:48.655Z
8600204 8600204 20251125024813_Gf5Xf RU0009 2025-11-26T14:22:08.704Z 2025-12-02T15:08:39.915Z
8599095 8599095 20251125014651_lexAV RU0009 2025-11-26T14:20:26.405Z 2025-12-02T15:08:19.902Z
8598626 8598626 20251125011057_pkIaD RU0009 2025-11-26T14:19:21.542Z 2025-12-02T15:08:01.429Z
8598389 8598389 20251125005357_ioGPr RU0009 2025-11-26T14:18:44.166Z 2025-12-02T15:07:53.517Z
8596907 8596907 20251124223142_8LlXZ RU0009 2025-11-26T14:15:45.281Z 2025-12-02T15:07:17.434Z
8596434 8596434 20251124210701_pTn4l RU0009 2025-11-26T14:14:33.541Z 2025-12-02T15:06:55.095Z
8596169 8596169 20251124201223_UQKou RU0009 2025-11-26T14:13:53.037Z 2025-12-02T15:06:48.666Z
8596105 8596105 20251124195644_1n01i RU0009 2025-11-26T14:13:34.435Z 2025-12-02T15:06:40.813Z
8595964 8595964 20251124191457_hNPTH RU0009 2025-11-26T14:13:12.234Z 2025-12-02T15:06:23.727Z
8595804 8595804 20251124183235_XIHjp RU0009 2025-11-26T14:12:31.580Z 2025-12-02T15:06:11.532Z
8595621 8595621 20251124171603_4gT2C RU0009 2025-11-26T14:11:47.447Z 2025-12-02T15:06:02.572Z
8595442 8595442 20251124155439_EUAyz RU0009 2025-11-26T14:11:05.966Z 2025-12-02T15:05:57.012Z
8590757 8590757 20251124030841_ZmhJ7 RU0009 2025-11-25T14:22:32.765Z 2025-12-02T15:12:55.199Z
8590665 8590665 20251124030147_aFhsp RU0009 2025-11-25T14:22:21.721Z 2025-12-02T15:12:53.941Z
8590481 8590481 20251124024521_Sfxb7 RU0009 2025-11-25T14:22:06.732Z 2025-12-02T15:12:49.042Z
8589562 8589562 20251124014118_C9CCg RU0009 2025-11-25T14:20:12.732Z 2025-12-02T15:12:32.417Z
8588890 8588890 20251124004122_AXEzN RU0009 2025-11-25T14:18:43.261Z 2025-12-02T15:11:58.704Z
8588523 8588523 20251124000530_k5vMm RU0009 2025-11-25T14:17:42.928Z 2025-12-02T15:11:48.799Z
8588254 8588254 20251123233612_K23vr RU0009 2025-11-25T14:17:09.485Z 2025-12-02T15:11:38.799Z
8588047 8588047 20251123231719_Gz8fu RU0009 2025-11-25T14:16:40.109Z 2025-12-02T15:11:24.430Z
8586527 8586527 20251123200043_05Avm RU0009 2025-11-25T14:13:08.016Z 2025-12-02T15:10:52.477Z
8586231 8586231 20251123190058_NUdyO RU0009 2025-11-25T14:12:20.266Z 2025-12-02T15:10:45.240Z
8585828 8585828 20251123175301_8u4CC RU0009 2025-11-25T14:11:04.617Z 2025-12-02T15:10:21.067Z
8585823 8585823 20251123174906_lrMTn RU0009 2025-11-25T14:11:03.762Z 2025-12-02T15:10:21.024Z
8576664 8576664 20251122153720_oSnuP RU0009 2025-11-24T14:06:21.537Z 2025-12-01T15:18:38.895Z
8572717 8572717 20251122013334_3immX RU0009 2025-11-23T14:39:39.938Z 2025-11-30T15:05:56.846Z
8572036 8572036 20251121232105_G2uPt RU0009 2025-11-23T14:37:55.976Z 2025-11-30T15:05:34.029Z
8571959 8571959 20251121230023_SWAa7 RU0009 2025-11-23T14:37:52.569Z 2025-11-30T15:05:26.855Z
8571434 8571434 20251121204532_EaV5C RU0009 2025-11-23T14:36:26.145Z 2025-11-30T15:05:05.585Z
8571090 8571090 20251121190105_J23iB RU0009 2025-11-23T14:35:57.419Z 2025-11-30T15:04:27.787Z
8571057 8571057 20251121184557_vJOOv RU0009 2025-11-23T14:35:55.641Z 2025-11-30T15:04:25.082Z
8570791 8570791 20251121170133_JVq1p RU0009 2025-11-23T14:34:33.342Z 2025-11-30T15:03:42.904Z
8566832 8566832 20251122023505_qHqLS RU0009 2025-11-23T14:17:40.556Z 2025-11-30T15:06:11.270Z
8566757 8566757 20251122021422_myiML RU0009 2025-11-23T14:17:17.529Z 2025-11-30T15:06:08.025Z
8566519 8566519 20251122005902_cWagN RU0009 2025-11-23T14:16:29.270Z 2025-11-30T15:05:51.093Z
8566175 8566175 20251121232141_mC2W2 RU0009 2025-11-23T14:15:22.638Z 2025-11-30T15:05:34.701Z
8566089 8566089 20251121224432_GLlmV RU0009 2025-11-23T14:15:01.967Z 2025-11-30T15:05:25.215Z
8566081 8566081 20251121224105_uyYcz RU0009 2025-11-23T14:15:01.016Z 2025-11-30T15:05:24.827Z
8565782 8565782 20251121211403_cOXe0 RU0009 2025-11-23T14:14:03.509Z 2025-11-30T15:05:08.738Z
8564919 8564919 20251121193345_8Vkxz RU0009 2025-11-23T14:12:07.869Z 2025-11-30T15:04:34.342Z
8564409 8564409 20251121182717_02nSa RU0009 2025-11-23T14:10:42.963Z 2025-11-30T15:04:18.569Z
8563116 8563116 20251121151707_HNrco RU0009 2025-11-23T14:07:24.072Z 2025-11-30T15:03:35.576Z
8556900 8556900 20251121021946_Fx2qK RU0009 2025-11-22T14:39:46.452Z 2025-11-29T14:54:33.141Z
8534311 8534311 20251119230019_PiNH6 RU0009 2025-11-21T14:13:30.708Z 2025-11-28T14:55:41.020Z
8530027 8530027 20251116023122_246f2 RU0009 2025-11-20T15:00:12.382Z 2025-11-24T15:05:02.047Z
8530000 8530000 20251115215320_xDANo RU0009 2025-11-20T14:59:59.930Z 2025-11-24T15:04:53.514Z
8511986 8511986 20251117210258_QVkLU RU0009 2025-11-19T14:34:28.286Z 2025-11-26T15:07:40.654Z

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