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 = "HR0007" 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
8667556 8667556 20251130021157_dI5d2 HR0007 2025-12-02T14:38:52.096Z 2025-12-06T14:47:56.424Z
8667484 8667484 20251130015144_tq111 HR0007 2025-12-02T14:38:39.939Z 2025-12-06T14:47:48.392Z
8667435 8667435 20251130012049_YzlG6 HR0007 2025-12-02T14:38:08.818Z 2025-12-06T14:47:39.278Z
8667332 8667332 20251129235521_7hcgm HR0007 2025-12-02T14:37:17.988Z 2025-12-06T14:46:48.310Z
8656697 8656697 20251130050621_Y8vey HR0007 2025-12-01T14:28:54.704Z 2025-12-06T14:49:39.065Z
8656651 8656651 20251130050459_L33rB HR0007 2025-12-01T14:28:51.857Z 2025-12-06T14:49:38.237Z
8656617 8656617 20251130050211_Q37iM HR0007 2025-12-01T14:28:48.722Z 2025-12-01T14:28:48.722Z
8656273 8656273 20251130044627_cv0ex HR0007 2025-12-01T14:28:15.434Z 2025-12-06T14:49:33.006Z
8655635 8655635 20251130041025_IYogw HR0007 2025-12-01T14:27:19.317Z 2025-12-01T14:27:19.317Z
8655615 8655615 20251130040916_KXtX9 HR0007 2025-12-01T14:27:17.819Z 2025-12-01T14:27:17.819Z
8655553 8655553 20251130040707_9RUtx HR0007 2025-12-01T14:27:03.220Z 2025-12-06T14:49:25.245Z
8655494 8655494 20251130040436_WU67i HR0007 2025-12-01T14:27:00.292Z 2025-12-06T14:49:23.965Z
8655382 8655382 20251130040009_uPdEU HR0007 2025-12-01T14:26:52.376Z 2025-12-06T14:49:11.264Z
8655309 8655309 20251130035421_jaYoF HR0007 2025-12-01T14:26:45.344Z 2025-12-01T14:26:45.344Z
8655192 8655192 20251130034827_IsYwG HR0007 2025-12-01T14:26:38.245Z 2025-12-06T14:48:53.308Z
8654856 8654856 20251130033609_3fd3r HR0007 2025-12-01T14:26:07.250Z 2025-12-01T14:26:07.250Z
8654849 8654849 20251130033608_kgDrW HR0007 2025-12-01T14:26:06.458Z 2025-12-01T14:26:06.458Z
8654805 8654805 20251130033339_OYF4A HR0007 2025-12-01T14:26:03.534Z 2025-12-06T14:48:48.728Z
8654776 8654776 20251130033232_2L427 HR0007 2025-12-01T14:26:00.406Z 2025-12-06T14:48:48.279Z
8654747 8654747 20251130033054_nn3NG HR0007 2025-12-01T14:25:57.782Z 2025-12-06T14:48:47.836Z
8654623 8654623 20251130032312_suIRq HR0007 2025-12-01T14:25:38.405Z 2025-12-06T14:48:45.030Z
8654482 8654482 20251130031809_wSip2 HR0007 2025-12-01T14:25:27.995Z 2025-12-06T14:48:43.087Z
8654325 8654325 20251130031105_pa9tC HR0007 2025-12-01T14:25:09.597Z 2025-12-06T14:48:40.922Z
8654311 8654311 20251130031031_bvoai HR0007 2025-12-01T14:25:08.790Z 2025-12-06T14:48:40.757Z
8654293 8654293 20251130030742_vCmg5 HR0007 2025-12-01T14:25:06.445Z 2025-12-06T14:48:40.095Z
8654213 8654213 20251130030331_N190F HR0007 2025-12-01T14:24:58.249Z 2025-12-06T14:48:38.855Z
8654159 8654159 20251130030141_Fxm8N HR0007 2025-12-01T14:24:55.568Z 2025-12-06T14:48:38.270Z
8654105 8654105 20251130025914_I9qRf HR0007 2025-12-01T14:24:52.224Z 2025-12-06T14:48:37.643Z
8653953 8653953 20251130024855_2wKsZ HR0007 2025-12-01T14:24:32.281Z 2025-12-06T14:48:35.002Z
8653528 8653528 20251130022324_Qn329 HR0007 2025-12-01T14:23:39.568Z 2025-12-06T14:48:11.511Z
8653519 8653519 20251130022234_7JZY0 HR0007 2025-12-01T14:23:38.698Z 2025-12-06T14:48:08.214Z
8653505 8653505 20251130022140_FgfhX HR0007 2025-12-01T14:23:37.394Z 2025-12-06T14:48:05.280Z
8653468 8653468 20251130021742_H5AkD HR0007 2025-12-01T14:23:33.123Z 2025-12-06T14:47:59.656Z
8653057 8653057 20251130015331_ZgSJS HR0007 2025-12-01T14:22:43.194Z 2025-12-06T14:47:48.968Z
8652955 8652955 20251130014722_La89u HR0007 2025-12-01T14:22:35.108Z 2025-12-06T14:47:46.974Z
8652884 8652884 20251130014338_FnhQa HR0007 2025-12-01T14:22:28.415Z 2025-12-06T14:47:44.589Z
8652880 8652880 20251130014249_Nvirt HR0007 2025-12-01T14:22:27.921Z 2025-12-06T14:47:44.414Z
8652868 8652868 20251130014154_2CnJC HR0007 2025-12-01T14:22:17.379Z 2025-12-06T14:47:43.921Z
8652746 8652746 20251130012955_T7hsb HR0007 2025-12-01T14:22:03.919Z 2025-12-06T14:47:41.779Z
8652638 8652638 20251130012547_KtJ33 HR0007 2025-12-01T14:21:54.241Z 2025-12-06T14:47:40.479Z
8652317 8652317 20251130010250_ipgRI HR0007 2025-12-01T14:21:15.597Z 2025-12-06T14:47:35.384Z
8652177 8652177 20251130005256_Gw1sc HR0007 2025-12-01T14:20:52.094Z 2025-12-06T14:47:27.392Z
8652167 8652167 20251130005122_GLPt6 HR0007 2025-12-01T14:20:50.816Z 2025-12-06T14:47:25.911Z
8652146 8652146 20251130005049_ZF4QK HR0007 2025-12-01T14:20:48.959Z 2025-12-06T14:47:23.752Z
8652076 8652076 20251130004455_K9dGS HR0007 2025-12-01T14:20:40.848Z 2025-12-06T14:47:13.130Z
8652068 8652068 20251130004425_qX3GI HR0007 2025-12-01T14:20:39.732Z 2025-12-06T14:47:11.275Z
8652053 8652053 20251130004331_Y635Q HR0007 2025-12-01T14:20:32.372Z 2025-12-06T14:47:07.140Z
8651972 8651972 20251130003846_clxoM HR0007 2025-12-01T14:20:22.222Z 2025-12-06T14:46:57.102Z
8651924 8651924 20251130003507_jhZkm HR0007 2025-12-01T14:20:17.001Z 2025-12-06T14:46:56.338Z
8651869 8651869 20251130002949_9J8OL HR0007 2025-12-01T14:20:09.693Z 2025-12-06T14:46:55.417Z
8651741 8651741 20251130001621_z5LN6 HR0007 2025-12-01T14:19:48.744Z 2025-12-06T14:46:53.376Z
8651630 8651630 20251130000633_3q0NX HR0007 2025-12-01T14:19:35.913Z 2025-12-06T14:46:49.781Z
8651611 8651611 20251130000152_Kqjz7 HR0007 2025-12-01T14:19:27.835Z 2025-12-06T14:46:49.447Z
8651540 8651540 20251129235402_5skyE HR0007 2025-12-01T14:19:17.969Z 2025-12-06T14:46:48.018Z
8651383 8651383 20251129233509_62LYH HR0007 2025-12-01T14:18:56.323Z 2025-12-06T14:46:45.242Z
8651326 8651326 20251129232718_bXlon HR0007 2025-12-01T14:18:46.056Z 2025-12-06T14:46:43.935Z
8651308 8651308 20251129232515_6Jap2 HR0007 2025-12-01T14:18:43.719Z 2025-12-06T14:46:43.731Z
8651291 8651291 20251129232157_pGbgW HR0007 2025-12-01T14:18:41.540Z 2025-12-06T14:46:43.393Z
8651267 8651267 20251129231609_OuuIm HR0007 2025-12-01T14:18:31.202Z 2025-12-06T14:46:42.909Z
8651185 8651185 20251129230207_iiyyu HR0007 2025-12-01T14:18:19.674Z 2025-12-06T14:46:41.584Z
8651079 8651079 20251129224025_Z37Zx HR0007 2025-12-01T14:17:58.474Z 2025-12-06T14:46:39.541Z
8650844 8650844 20251129214052_GhdVQ HR0007 2025-12-01T14:17:18.170Z 2025-12-06T14:46:34.682Z
8650841 8650841 20251129214022_GdB20 HR0007 2025-12-01T14:17:17.731Z 2025-12-06T14:46:34.618Z
8650754 8650754 20251129212200_8iUA2 HR0007 2025-12-01T14:17:05.908Z 2025-12-06T14:46:33.167Z
8650574 8650574 20251129204331_TQw0d HR0007 2025-12-01T14:16:31.935Z 2025-12-06T14:46:14.003Z
8650406 8650406 20251129201044_2Ftb4 HR0007 2025-12-01T14:16:03.560Z 2025-12-06T14:45:55.717Z
8650032 8650032 20251129191004_8ZVM4 HR0007 2025-12-01T14:14:45.094Z 2025-12-06T14:45:45.966Z
8649729 8649729 20251129181334_d5I5G HR0007 2025-12-01T14:13:38.740Z 2025-12-06T14:45:37.976Z
8649712 8649712 20251129181130_P8RbT HR0007 2025-12-01T14:13:35.604Z 2025-12-06T14:45:37.268Z
8649399 8649399 20251129172156_PuiRK HR0007 2025-12-01T14:12:25.960Z 2025-12-06T14:45:14.646Z
8649244 8649244 20251129164939_mKzrI HR0007 2025-12-01T14:11:41.059Z 2025-12-06T14:44:53.443Z
8646963 8646963 20251129032054_x4cDQ HR0007 2025-11-30T14:27:11.745Z 2025-12-06T14:56:28.876Z
8646937 8646937 20251129031523_JcvNs HR0007 2025-11-30T14:27:09.140Z 2025-12-06T14:56:28.243Z
8646811 8646811 20251129025924_zwC0u HR0007 2025-11-30T14:26:59.526Z 2025-12-06T14:56:25.726Z
8646775 8646775 20251129025241_WoRRK HR0007 2025-11-30T14:26:56.733Z 2025-12-06T14:56:24.975Z
8646727 8646727 20251129024403_g3t0Z HR0007 2025-11-30T14:26:43.298Z 2025-12-06T14:56:24.116Z
8646725 8646725 20251129024329_l5K7C HR0007 2025-11-30T14:26:43.051Z 2025-12-06T14:56:24.094Z
8646593 8646593 20251129022647_hLjr2 HR0007 2025-11-30T14:26:14.552Z 2025-12-06T14:56:17.720Z
8646573 8646573 20251129022330_aGXwP HR0007 2025-11-30T14:26:12.648Z 2025-12-06T14:56:15.211Z
8646545 8646545 20251129021956_O6Tqf HR0007 2025-11-30T14:26:08.781Z 2025-12-06T14:56:13.860Z
8646439 8646439 20251129020643_Qu1uP HR0007 2025-11-30T14:25:59.461Z 2025-12-06T14:56:07.515Z
8646430 8646430 20251129020454_dtZfU HR0007 2025-11-30T14:25:58.742Z 2025-12-06T14:56:06.615Z
8646417 8646417 20251129020343_3aHyt HR0007 2025-11-30T14:25:57.848Z 2025-12-06T14:56:05.338Z
8646413 8646413 20251129020338_YZDoB HR0007 2025-11-30T14:25:57.590Z 2025-12-06T14:56:05.235Z
8646099 8646099 20251129010525_2xZg1 HR0007 2025-11-30T14:25:11.614Z 2025-12-06T14:55:33.093Z
8646014 8646014 20251129004739_X832W HR0007 2025-11-30T14:25:04.297Z 2025-12-06T14:55:25.741Z
8645964 8645964 20251129003546_fOj46 HR0007 2025-11-30T14:24:59.716Z 2025-12-06T14:55:20.314Z
8645960 8645960 20251129003528_INyEN HR0007 2025-11-30T14:24:59.352Z 2025-12-06T14:55:20.119Z
8645910 8645910 20251129002443_RRVw3 HR0007 2025-11-30T14:24:53.924Z 2025-12-06T14:55:14.515Z
8645857 8645857 20251129000557_Hpb9T HR0007 2025-11-30T14:24:37.978Z 2025-12-06T14:55:11.256Z
8645843 8645843 20251129000237_vR5dQ HR0007 2025-11-30T14:24:37.069Z 2025-12-06T14:55:10.650Z
8645804 8645804 20251128235148_2yb0o HR0007 2025-11-30T14:24:34.321Z 2025-12-06T14:55:08.576Z
8645800 8645800 20251128235133_kQrLf HR0007 2025-11-30T14:24:33.205Z 2025-12-06T14:55:08.159Z
8645780 8645780 20251128234925_N08fm HR0007 2025-11-30T14:24:31.397Z 2025-12-06T14:55:07.455Z
8645766 8645766 20251128234610_3VmKB HR0007 2025-11-30T14:24:30.258Z 2025-12-06T14:55:05.809Z
8645749 8645749 20251128234357_XGEyd HR0007 2025-11-30T14:24:28.804Z 2025-12-06T14:55:04.796Z
8645710 8645710 20251128233442_WVDaK HR0007 2025-11-30T14:24:25.755Z 2025-12-06T14:55:02.790Z
8645637 8645637 20251128231405_MH1tw HR0007 2025-11-30T14:24:19.348Z 2025-12-06T14:55:01.369Z
8645619 8645619 20251128230654_pJuw2 HR0007 2025-11-30T14:24:17.439Z 2025-12-06T14:55:01.134Z
8645606 8645606 20251128230426_z9SeA HR0007 2025-11-30T14:24:16.181Z 2025-12-06T14:55:00.924Z

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