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

2,907 rows where station_code = "BR000Q" 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
8683276 8683276 20251203064913_H5vBX BR000Q 2025-12-04T14:19:03.237Z 2025-12-06T14:29:48.943Z
8683260 8683260 20251203064709_HxmQr BR000Q 2025-12-04T14:19:00.835Z 2025-12-06T14:29:48.383Z
8677187 8677187 20251203070257_bhBvq BR000Q 2025-12-04T14:00:17.924Z 2025-12-06T14:18:09.834Z
8677185 8677185 20251203070231_nt34Y BR000Q 2025-12-04T14:00:17.471Z 2025-12-06T14:18:09.023Z
8668496 8668496 20251129070047_ifP8X BR000Q 2025-12-02T14:49:17.575Z 2025-12-06T14:57:21.632Z
8668457 8668457 20251129052809_oBLBA BR000Q 2025-12-02T14:48:29.612Z 2025-12-06T14:56:47.547Z
8668408 8668408 20251129014923_qS2V1 BR000Q 2025-12-02T14:47:20.400Z 2025-12-06T14:56:01.166Z
8668406 8668406 20251129014723_4FPLY BR000Q 2025-12-02T14:47:20.182Z 2025-12-06T14:56:00.178Z
8648653 8648653 20251128000857_UKggH BR000Q 2025-11-30T14:36:02.391Z 2025-12-06T15:01:50.060Z
8648218 8648218 20251129070321_d5zsg BR000Q 2025-11-30T14:29:58.190Z 2025-12-06T14:57:22.338Z
8648216 8648216 20251129070158_yERQd BR000Q 2025-11-30T14:29:58.004Z 2025-12-06T14:57:21.783Z
8648185 8648185 20251129065258_kMACo BR000Q 2025-11-30T14:29:54.492Z 2025-12-06T14:57:17.891Z
8647102 8647102 20251129034315_yRFM2 BR000Q 2025-11-30T14:27:40.941Z 2025-12-06T14:56:31.942Z
8625455 8625455 20251126012346_XMKyK BR000Q 2025-11-28T14:33:35.141Z 2025-12-04T15:08:52.637Z
8625405 8625405 20251126002302_IGAsZ BR000Q 2025-11-28T14:32:56.912Z 2025-12-04T15:08:02.334Z
8610840 8610840 20251126010930_g1hp2 BR000Q 2025-11-27T14:20:52.637Z 2025-12-04T15:08:43.270Z
8609601 8609601 20251125235020_JNSpS BR000Q 2025-11-27T14:18:29.991Z 2025-12-04T15:07:55.627Z
8574475 8574475 20251122070212_K7mDX BR000Q 2025-11-23T14:43:37.148Z 2025-11-30T15:07:09.986Z
8574382 8574382 20251122061139_RpWmE BR000Q 2025-11-23T14:43:20.982Z 2025-11-30T15:07:07.844Z
8573044 8573044 20251122022126_4IUK0 BR000Q 2025-11-23T14:40:41.181Z 2025-11-30T15:06:08.874Z
8572223 8572223 20251122000507_vCSqH BR000Q 2025-11-23T14:38:08.145Z 2025-11-30T15:05:41.774Z
8552852 8552852 20251120043611_Mwf3t BR000Q 2025-11-22T14:33:08.150Z 2025-11-28T14:57:41.962Z
8551950 8551950 20251120032435_32eSc BR000Q 2025-11-22T14:31:35.689Z 2025-11-28T14:57:18.817Z
8551685 8551685 20251120030528_Uhkc6 BR000Q 2025-11-22T14:31:02.218Z 2025-11-28T14:57:10.182Z
8551532 8551532 20251120024840_dLhIu BR000Q 2025-11-22T14:30:51.318Z 2025-11-28T14:56:59.083Z
8551399 8551399 20251120000201_qUNGb BR000Q 2025-11-22T14:27:31.545Z 2025-11-28T14:55:55.170Z
8549832 8549832 20251120225845_B3mTp BR000Q 2025-11-22T14:19:39.554Z 2025-11-29T14:54:25.670Z
8540204 8540204 20251120004451_X9GbH BR000Q 2025-11-21T14:35:55.042Z 2025-11-28T14:56:08.544Z
8537248 8537248 20251119022626_hXkhJ BR000Q 2025-11-21T14:25:40.289Z 2025-11-27T15:12:24.167Z
8529331 8529331 20251119065613_Pmwu8 BR000Q 2025-11-20T14:44:51.227Z 2025-11-27T15:13:26.558Z
8529311 8529311 20251119064926_Af5rK BR000Q 2025-11-20T14:44:50.559Z 2025-11-27T15:13:26.168Z
8529286 8529286 20251119063656_uWNq3 BR000Q 2025-11-20T14:44:48.946Z 2025-11-27T15:13:24.837Z
8529274 8529274 20251119063116_nilXV BR000Q 2025-11-20T14:44:48.248Z 2025-11-27T15:13:24.697Z
8529239 8529239 20251119062038_HjImh BR000Q 2025-11-20T14:44:46.722Z 2025-11-20T14:44:46.722Z
8529231 8529231 20251119061635_WQWhJ BR000Q 2025-11-20T14:44:46.183Z 2025-11-27T15:13:23.306Z
8529227 8529227 20251119061444_XWblt BR000Q 2025-11-20T14:44:45.898Z 2025-11-27T15:13:23.300Z
8529181 8529181 20251119060417_hQZog BR000Q 2025-11-20T14:44:44.379Z 2025-11-20T14:44:44.379Z
8528934 8528934 20251119052811_jmxDW BR000Q 2025-11-20T14:44:19.166Z 2025-11-27T15:13:16.381Z
8528637 8528637 20251119044203_zMKgQ BR000Q 2025-11-20T14:43:29.029Z 2025-11-27T15:13:08.183Z
8528623 8528623 20251119044108_dq1Sq BR000Q 2025-11-20T14:43:28.108Z 2025-11-27T15:13:08.023Z
8528479 8528479 20251119042007_knKiT BR000Q 2025-11-20T14:43:00.406Z 2025-11-27T15:13:03.952Z
8528453 8528453 20251119041758_uHYRm BR000Q 2025-11-20T14:42:56.278Z 2025-11-20T14:42:56.278Z
8528424 8528424 20251119041535_52PV1 BR000Q 2025-11-20T14:42:50.515Z 2025-11-27T15:13:03.655Z
8528134 8528134 20251119032811_3EIES BR000Q 2025-11-20T14:42:08.289Z 2025-11-20T14:42:08.289Z
8528083 8528083 20251119032228_pGyMD BR000Q 2025-11-20T14:42:05.936Z 2025-11-27T15:12:47.468Z
8526929 8526929 20251119002352_e3jfv BR000Q 2025-11-20T14:40:13.416Z 2025-11-27T15:12:03.655Z
8441810 8441810 20251112032225_POkv2 BR000Q 2025-11-13T14:33:41.468Z 2025-11-20T15:25:11.566Z
8441789 8441789 20251112021220_1wQ2w BR000Q 2025-11-13T14:31:50.827Z 2025-11-20T15:24:40.100Z
8441776 8441776 20251112001032_EWpqr BR000Q 2025-11-13T14:31:45.832Z 2025-11-20T15:23:37.437Z
8441774 8441774 20251112000154_gRIwf BR000Q 2025-11-13T14:31:44.027Z 2025-11-20T15:23:32.861Z
8438934 8438934 20251112025252_LkGxI BR000Q 2025-11-13T14:25:10.640Z 2025-11-20T15:24:52.285Z
8438902 8438902 20251112024953_n34SY BR000Q 2025-11-13T14:25:08.105Z 2025-11-20T15:24:50.715Z
8438835 8438835 20251112024409_Aynxa BR000Q 2025-11-13T14:25:01.027Z 2025-11-20T15:24:49.186Z
8438701 8438701 20251112023011_YI1E0 BR000Q 2025-11-13T14:24:31.683Z 2025-11-20T15:24:45.752Z
8438305 8438305 20251112014311_fMU62 BR000Q 2025-11-13T14:23:16.556Z 2025-11-20T15:24:24.359Z
8437506 8437506 20251112001207_Rm5rB BR000Q 2025-11-13T14:21:13.624Z 2025-11-20T15:23:37.573Z
8436866 8436866 20251111224440_uhDJE BR000Q 2025-11-13T14:19:28.965Z 2025-11-20T15:23:02.304Z
8428635 8428635 20251111072011_wkPN9 BR000Q 2025-11-12T14:30:54.909Z 2025-11-19T15:18:22.451Z
8428615 8428615 20251111071605_QNBDd BR000Q 2025-11-12T14:30:53.476Z 2025-11-19T15:18:22.213Z
8428330 8428330 20251111062500_tBe2e BR000Q 2025-11-12T14:30:31.953Z 2025-11-19T15:18:16.830Z
8428181 8428181 20251111060347_NRrar BR000Q 2025-11-12T14:30:02.366Z 2025-11-19T15:18:10.413Z
8428157 8428157 20251111055818_PyU3s BR000Q 2025-11-12T14:29:59.968Z 2025-11-19T15:18:10.212Z
8428106 8428106 20251111055150_bjZv0 BR000Q 2025-11-12T14:29:57.192Z 2025-11-19T15:18:09.789Z
8428103 8428103 20251111055150_2ua33 BR000Q 2025-11-12T14:29:57.016Z 2025-11-12T14:29:57.016Z
8428029 8428029 20251111054009_IXVLn BR000Q 2025-11-12T14:29:49.381Z 2025-11-19T15:18:08.570Z
8427983 8427983 20251111053421_tDumZ BR000Q 2025-11-12T14:29:46.547Z 2025-11-19T15:18:08.005Z
8427905 8427905 20251111052318_zd3ZW BR000Q 2025-11-12T14:29:25.735Z 2025-11-19T15:18:06.976Z
8427596 8427596 20251111045527_ZOxXm BR000Q 2025-11-12T14:28:48.684Z 2025-11-19T15:17:57.654Z
8427463 8427463 20251111044253_v3Nwq BR000Q 2025-11-12T14:28:10.833Z 2025-11-19T15:17:54.059Z
8427416 8427416 20251111043713_RcP82 BR000Q 2025-11-12T14:28:05.572Z 2025-11-19T15:17:52.926Z
8427041 8427041 20251111040149_DzyUr BR000Q 2025-11-12T14:27:07.926Z 2025-11-19T15:17:41.777Z
8426366 8426366 20251111025752_KDUrX BR000Q 2025-11-12T14:25:08.310Z 2025-11-19T15:17:06.074Z
8426172 8426172 20251111024124_dhiRW BR000Q 2025-11-12T14:24:35.243Z 2025-11-19T15:16:58.874Z
8426116 8426116 20251111023748_B1RIp BR000Q 2025-11-12T14:24:28.097Z 2025-11-19T15:16:57.130Z
8425786 8425786 20251111021255_cquUO BR000Q 2025-11-12T14:23:36.562Z 2025-11-19T15:16:47.269Z
8425708 8425708 20251111020742_Hif7t BR000Q 2025-11-12T14:23:30.313Z 2025-11-19T15:16:45.759Z
8425360 8425360 20251111013833_oTjUv BR000Q 2025-11-12T14:22:43.801Z 2025-11-19T15:16:39.535Z
8425056 8425056 20251111011151_iVf1R BR000Q 2025-11-12T14:22:00.604Z 2025-11-19T15:16:33.072Z
8424641 8424641 20251111003736_kOqB2 BR000Q 2025-11-12T14:20:41.426Z 2025-11-19T15:16:20.020Z
8413782 8413782 20251110004338_rYpx1 BR000Q 2025-11-11T14:18:31.977Z 2025-11-18T15:20:24.435Z
8413709 8413709 20251110002843_KSjh2 BR000Q 2025-11-11T14:18:09.546Z 2025-11-18T15:20:23.639Z
8413679 8413679 20251110001827_vWEYz BR000Q 2025-11-11T14:18:05.282Z 2025-11-18T15:20:23.400Z
8413369 8413369 20251109230948_8F83X BR000Q 2025-11-11T14:17:12.190Z 2025-11-18T15:20:21.013Z
8242232 8242232 20251025035943_zVdyl BR000Q 2025-10-27T12:34:45.793Z 2025-11-02T15:05:37.172Z
8242218 8242218 20251025035844_3gal2 BR000Q 2025-10-27T12:34:45.159Z 2025-11-02T15:05:37.143Z
8242077 8242077 20251025034635_RC26M BR000Q 2025-10-27T12:34:40.221Z 2025-11-02T15:05:36.748Z
8241999 8241999 20251025033912_ZtIbF BR000Q 2025-10-27T12:34:36.950Z 2025-11-02T15:05:36.422Z
8241982 8241982 20251025033837_Tk1ln BR000Q 2025-10-27T12:34:36.509Z 2025-11-02T15:05:36.307Z
8224862 8224862 20251024071531_et3DU BR000Q 2025-10-26T12:42:53.739Z 2025-11-01T13:11:20.429Z
8224833 8224833 20251024071247_9Su3g BR000Q 2025-10-26T12:42:52.860Z 2025-11-01T13:11:20.337Z
8224733 8224733 20251024070428_A52MP BR000Q 2025-10-26T12:42:39.402Z 2025-11-01T13:11:20.100Z
8224705 8224705 20251024070129_fAjlu BR000Q 2025-10-26T12:42:35.335Z 2025-11-01T13:11:19.991Z
8224617 8224617 20251024065307_Xa20E BR000Q 2025-10-26T12:42:16.097Z 2025-11-01T13:11:19.728Z
8224108 8224108 20251024060540_tjVyP BR000Q 2025-10-26T12:41:16.679Z 2025-11-01T13:11:18.239Z
8222456 8222456 20251024045143_1hpab BR000Q 2025-10-26T12:39:48.327Z 2025-11-01T13:11:14.498Z
8221480 8221480 20251024042714_2Fm9z BR000Q 2025-10-26T12:38:27.084Z 2025-11-01T13:11:09.348Z
8220828 8220828 20251024041210_OKOB0 BR000Q 2025-10-26T12:38:08.258Z 2025-11-01T13:11:06.692Z
8219537 8219537 20251024033525_tcW0K BR000Q 2025-10-26T12:36:25.286Z 2025-11-01T13:10:57.879Z
8219408 8219408 20251024033127_uFeZC BR000Q 2025-10-26T12:36:21.455Z 2025-11-01T13:10:57.261Z
8218751 8218751 20251024031130_wr70a BR000Q 2025-10-26T12:35:23.997Z 2025-11-01T13:10:51.234Z

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