participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,727 rows where station_code = "BR000G" sorted by created_at descending
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 |
---|---|---|---|---|---|
5206728 | 5206728 | 20241002051608_yR2qD | BR000G | 2024-10-03T12:03:22.489Z | 2024-10-11T12:23:23.767Z |
4692335 | 4692335 | 20240726083928_Go9t1 | BR000G | 2024-07-27T12:07:33.005Z | 2024-08-03T12:21:33.052Z |
4692078 | 4692078 | 20240726071422_zrH56 | BR000G | 2024-07-27T12:06:59.109Z | 2024-08-03T12:21:30.223Z |
4692057 | 4692057 | 20240726070841_Pt8GS | BR000G | 2024-07-27T12:06:56.999Z | 2024-08-03T12:21:30.086Z |
4692011 | 4692011 | 20240726065027_UnQOW | BR000G | 2024-07-27T12:06:50.106Z | 2024-08-03T12:21:29.102Z |
4691668 | 4691668 | 20240726022454_2j0At | BR000G | 2024-07-27T12:05:58.896Z | 2024-08-03T12:21:23.043Z |
4691640 | 4691640 | 20240726022117_BV3T9 | BR000G | 2024-07-27T12:05:56.086Z | 2024-08-03T12:21:22.796Z |
4691568 | 4691568 | 20240726021152_35JQW | BR000G | 2024-07-27T12:05:50.680Z | 2024-08-03T12:21:21.842Z |
4691301 | 4691301 | 20240726013341_jGz6A | BR000G | 2024-07-27T12:05:15.362Z | 2024-08-03T12:21:18.994Z |
4690966 | 4690966 | 20240726005832_aqy4Q | BR000G | 2024-07-27T12:04:28.371Z | 2024-08-03T12:21:14.881Z |
4690008 | 4690008 | 20240725230055_hnqaq | BR000G | 2024-07-27T12:02:16.531Z | 2024-08-03T12:21:06.552Z |
4685303 | 4685303 | 20240725085306_28L29 | BR000G | 2024-07-26T12:05:20.924Z | 2024-08-02T12:24:40.970Z |
4684883 | 4684883 | 20240725070647_zBe9s | BR000G | 2024-07-26T12:04:38.368Z | 2024-08-02T12:24:33.395Z |
4684878 | 4684878 | 20240725070401_DtAZL | BR000G | 2024-07-26T12:04:37.915Z | 2024-08-02T12:24:33.235Z |
4684861 | 4684861 | 20240725065844_KsGHc | BR000G | 2024-07-26T12:04:36.444Z | 2024-08-02T12:24:32.880Z |
4684787 | 4684787 | 20240725064130_GuMGJ | BR000G | 2024-07-26T12:04:30.639Z | 2024-08-02T12:24:30.852Z |
4684242 | 4684242 | 20240725004955_uQ01x | BR000G | 2024-07-26T12:02:48.474Z | 2024-08-02T12:24:11.707Z |
4684014 | 4684014 | 20240724232919_S5SP8 | BR000G | 2024-07-26T12:02:01.324Z | 2024-08-02T12:24:03.265Z |
4681622 | 4681622 | 20240724081856_zJwmO | BR000G | 2024-07-25T12:04:18.479Z | 2024-08-01T12:12:04.952Z |
4681574 | 4681574 | 20240724080510_fbu4q | BR000G | 2024-07-25T12:04:14.472Z | 2024-08-01T12:12:04.844Z |
4681362 | 4681362 | 20240724065542_X52YH | BR000G | 2024-07-25T12:03:56.334Z | 2024-08-01T12:12:04.365Z |
4681290 | 4681290 | 20240724064017_O3DNv | BR000G | 2024-07-25T12:03:52.077Z | 2024-08-01T12:12:04.203Z |
4681259 | 4681259 | 20240724062710_tzXIp | BR000G | 2024-07-25T12:03:49.305Z | 2024-08-01T12:12:04.098Z |
4681196 | 4681196 | 20240724052551_l0HWQ | BR000G | 2024-07-25T12:03:43.162Z | 2024-08-01T12:12:03.835Z |
4678457 | 4678457 | 20240723083925_0wVfH | BR000G | 2024-07-24T12:03:55.554Z | 2024-07-31T12:18:00.373Z |
4678274 | 4678274 | 20240723072946_CDWfy | BR000G | 2024-07-24T12:03:27.803Z | 2024-07-31T12:17:59.254Z |
4678117 | 4678117 | 20240723055738_ASGOo | BR000G | 2024-07-24T12:03:10.871Z | 2024-07-31T12:17:58.183Z |
4678084 | 4678084 | 20240723043658_3atnm | BR000G | 2024-07-24T12:03:01.801Z | 2024-07-31T12:17:57.815Z |
4677485 | 4677485 | 20240722221438_N3om3 | BR000G | 2024-07-24T12:01:04.713Z | 2024-07-31T12:17:51.286Z |
4677466 | 4677466 | 20240722221000_3OZXb | BR000G | 2024-07-24T12:01:01.853Z | 2024-07-31T12:17:51.096Z |
4676270 | 4676270 | 20240722080815_9TPn5 | BR000G | 2024-07-23T12:02:25.871Z | 2024-07-30T12:18:13.462Z |
4676223 | 4676223 | 20240722071900_SMMmW | BR000G | 2024-07-23T12:02:22.078Z | 2024-07-30T12:18:13.133Z |
4676143 | 4676143 | 20240722063853_MIwGi | BR000G | 2024-07-23T12:02:15.271Z | 2024-07-30T12:18:12.332Z |
4674534 | 4674534 | 20240721073701_k392T | BR000G | 2024-07-22T12:01:57.116Z | 2024-07-29T12:17:16.143Z |
4669204 | 4669204 | 20240719084906_KXNyD | BR000G | 2024-07-20T12:05:41.926Z | 2024-07-27T12:17:23.905Z |
4669102 | 4669102 | 20240719075029_xYd6r | BR000G | 2024-07-20T12:05:31.229Z | 2024-07-27T12:17:22.920Z |
4667907 | 4667907 | 20240719011347_VW3UV | BR000G | 2024-07-20T12:04:07.223Z | 2024-07-27T12:17:13.665Z |
4667830 | 4667830 | 20240719010738_VuMnh | BR000G | 2024-07-20T12:04:03.940Z | 2024-07-27T12:17:13.262Z |
4663305 | 4663305 | 20240718084500_U2CaP | BR000G | 2024-07-19T12:05:52.211Z | 2024-07-26T12:17:51.969Z |
4663290 | 4663290 | 20240718083727_l1PPd | BR000G | 2024-07-19T12:05:51.532Z | 2024-07-26T12:17:51.856Z |
4663240 | 4663240 | 20240718080100_5dmr1 | BR000G | 2024-07-19T12:05:48.985Z | 2024-07-26T12:17:51.289Z |
4662815 | 4662815 | 20240718020042_YFW73 | BR000G | 2024-07-19T12:05:11.515Z | 2024-07-26T12:17:45.513Z |
4662684 | 4662684 | 20240718013926_sptSB | BR000G | 2024-07-19T12:04:57.035Z | 2024-07-26T12:17:44.671Z |
4659343 | 4659343 | 20240715074308_6Or83 | BR000G | 2024-07-18T12:13:26.336Z | 2024-07-23T12:08:50.615Z |
4651379 | 4651379 | 20240715080239_IlXce | BR000G | 2024-07-17T12:10:02.059Z | 2024-07-23T12:08:50.974Z |
4580389 | 4580389 | 20240707082139_CNVh2 | BR000G | 2024-07-09T12:03:23.598Z | 2024-07-15T12:12:11.749Z |
4571895 | 4571895 | 20240706080554_GRs4u | BR000G | 2024-07-08T12:04:44.989Z | 2024-07-14T12:13:59.573Z |
4570954 | 4570954 | 20240706040453_torKl | BR000G | 2024-07-08T12:03:18.723Z | 2024-07-14T12:13:54.657Z |
4570947 | 4570947 | 20240706040132_NtkbC | BR000G | 2024-07-08T12:03:18.074Z | 2024-07-14T12:13:54.644Z |
4570883 | 4570883 | 20240706024533_6VEF3 | BR000G | 2024-07-08T12:03:10.491Z | 2024-07-14T12:13:54.236Z |
4570870 | 4570870 | 20240706020901_GNjuc | BR000G | 2024-07-08T12:03:08.797Z | 2024-07-14T12:13:54.135Z |
4555167 | 4555167 | 20240704082153_OD8Np | BR000G | 2024-07-06T12:05:41.182Z | 2024-07-12T12:08:55.899Z |
4538444 | 4538444 | 20240703005304_eGKF5 | BR000G | 2024-07-04T12:02:17.931Z | 2024-07-11T12:14:35.925Z |
4534922 | 4534922 | 20240702031611_tzfIe | BR000G | 2024-07-03T12:02:00.269Z | 2024-07-10T12:15:26.520Z |
4534800 | 4534800 | 20240702012415_2JgYZ | BR000G | 2024-07-03T12:01:44.709Z | 2024-07-10T12:15:25.855Z |
4534725 | 4534725 | 20240702001157_OyXn3 | BR000G | 2024-07-03T12:01:35.007Z | 2024-07-10T12:15:24.804Z |
4504969 | 4504969 | 20240626002833_jMGfh | BR000G | 2024-06-27T12:04:17.885Z | 2024-07-04T12:08:53.577Z |
4504757 | 4504757 | 20240625235935_2Gr8X | BR000G | 2024-06-27T12:04:00.411Z | 2024-07-04T12:08:52.737Z |
4492774 | 4492774 | 20240618051141_6bxMC | BR000G | 2024-06-22T12:09:10.018Z | 2024-06-27T12:11:00.638Z |
4489949 | 4489949 | 20240621082951_X0ScN | BR000G | 2024-06-22T12:00:31.166Z | 2024-06-30T12:09:34.028Z |
4489780 | 4489780 | 20240619025909_wOlVw | BR000G | 2024-06-21T12:08:24.821Z | 2024-06-27T12:11:35.846Z |
4489771 | 4489771 | 20240619024020_dmrFG | BR000G | 2024-06-21T12:08:24.017Z | 2024-06-27T12:11:35.806Z |
4489767 | 4489767 | 20240619023627_zpFIM | BR000G | 2024-06-21T12:08:23.586Z | 2024-06-27T12:11:35.800Z |
4489750 | 4489750 | 20240619021451_vcEAW | BR000G | 2024-06-21T12:08:22.672Z | 2024-06-27T12:11:35.716Z |
4489694 | 4489694 | 20240619014922_Lvitu | BR000G | 2024-06-21T12:08:19.305Z | 2024-06-27T12:11:35.498Z |
4486157 | 4486157 | 20240619083426_26S3r | BR000G | 2024-06-21T12:02:03.607Z | 2024-06-28T12:09:27.380Z |
4486122 | 4486122 | 20240619081835_5L9dE | BR000G | 2024-06-21T12:02:00.273Z | 2024-06-28T12:09:27.196Z |
4486095 | 4486095 | 20240619081308_q07UW | BR000G | 2024-06-21T12:01:58.020Z | 2024-06-28T12:09:27.069Z |
4486062 | 4486062 | 20240619075601_4RbMk | BR000G | 2024-06-21T12:01:55.361Z | 2024-06-28T12:09:26.882Z |
4485992 | 4485992 | 20240619071314_LJPZf | BR000G | 2024-06-21T12:01:48.244Z | 2024-06-28T12:09:26.395Z |
4485954 | 4485954 | 20240619065823_M6xWu | BR000G | 2024-06-21T12:01:45.603Z | 2024-06-28T12:09:26.265Z |
4485833 | 4485833 | 20240619060502_7rpfQ | BR000G | 2024-06-21T12:01:32.534Z | 2024-06-28T12:09:25.428Z |
4485831 | 4485831 | 20240619055906_YmCoq | BR000G | 2024-06-21T12:01:31.339Z | 2024-06-28T12:09:25.409Z |
4485786 | 4485786 | 20240619053146_ZnX2f | BR000G | 2024-06-21T12:01:21.170Z | 2024-06-28T12:09:25.113Z |
4485774 | 4485774 | 20240619050643_LsP2Q | BR000G | 2024-06-21T12:01:19.850Z | 2024-06-28T12:09:25.034Z |
4485769 | 4485769 | 20240619045729_G45DK | BR000G | 2024-06-21T12:01:19.380Z | 2024-06-28T12:09:25.009Z |
4485721 | 4485721 | 20240619041320_dkmD6 | BR000G | 2024-06-21T12:01:14.945Z | 2024-06-28T12:09:24.726Z |
4485717 | 4485717 | 20240619041306_7AbFB | BR000G | 2024-06-21T12:01:14.740Z | 2024-06-28T12:09:24.722Z |
4485711 | 4485711 | 20240619040805_hK3pb | BR000G | 2024-06-21T12:01:14.020Z | 2024-06-28T12:09:24.661Z |
4485703 | 4485703 | 20240619035531_uZS5U | BR000G | 2024-06-21T12:01:12.975Z | 2024-06-28T12:09:24.585Z |
4485350 | 4485350 | 20240620085315_1YVEj | BR000G | 2024-06-21T12:00:35.988Z | 2024-06-29T12:13:20.365Z |
4485337 | 4485337 | 20240620085030_JaATD | BR000G | 2024-06-21T12:00:35.077Z | 2024-06-29T12:13:20.313Z |
4485307 | 4485307 | 20240620083117_HEZs0 | BR000G | 2024-06-21T12:00:32.140Z | 2024-06-29T12:13:20.143Z |
4485241 | 4485241 | 20240620075629_T4jFJ | BR000G | 2024-06-21T12:00:25.785Z | 2024-06-29T12:13:19.261Z |
4485127 | 4485127 | 20240620060805_kB2W7 | BR000G | 2024-06-21T12:00:13.495Z | 2024-06-29T12:13:17.929Z |
4485095 | 4485095 | 20240620044445_7u1t3 | BR000G | 2024-06-21T12:00:09.753Z | 2024-06-29T12:13:17.693Z |
4481401 | 4481401 | 20240618082858_iIad8 | BR000G | 2024-06-20T12:00:52.012Z | 2024-06-27T12:11:06.817Z |
4479303 | 4479303 | 20240618005802_dtkBk | BR000G | 2024-06-19T12:07:55.360Z | 2024-06-26T12:14:54.111Z |
4478948 | 4478948 | 20240617233939_4zomx | BR000G | 2024-06-19T12:07:21.876Z | 2024-06-26T12:14:48.835Z |
4475697 | 4475697 | 20240617082250_21uu5 | BR000G | 2024-06-19T12:02:19.315Z | 2024-06-26T12:14:13.484Z |
4475622 | 4475622 | 20240617080801_Ef1UO | BR000G | 2024-06-19T12:02:11.464Z | 2024-06-26T12:14:12.978Z |
4475591 | 4475591 | 20240617080219_F1xeU | BR000G | 2024-06-19T12:02:09.745Z | 2024-06-26T12:14:12.828Z |
4475580 | 4475580 | 20240617075018_59v9n | BR000G | 2024-06-19T12:02:08.838Z | 2024-06-26T12:14:12.766Z |
4475320 | 4475320 | 20240617053355_DyDpZ | BR000G | 2024-06-19T12:01:34.995Z | 2024-06-26T12:14:09.807Z |
4475302 | 4475302 | 20240617051511_W9Yla | BR000G | 2024-06-19T12:01:33.111Z | 2024-06-26T12:14:09.659Z |
4475247 | 4475247 | 20240617041510_5M0vw | BR000G | 2024-06-19T12:01:21.020Z | 2024-06-26T12:14:08.997Z |
4475216 | 4475216 | 20240617025733_0uoDh | BR000G | 2024-06-19T12:01:16.475Z | 2024-06-26T12:14:07.919Z |
4475203 | 4475203 | 20240617022253_hArcC | BR000G | 2024-06-19T12:01:13.951Z | 2024-06-26T12:14:07.653Z |
4474635 | 4474635 | 20240618052335_82KV7 | BR000G | 2024-06-19T12:00:19.844Z | 2024-06-27T12:11:00.711Z |
4474628 | 4474628 | 20240618051030_IoC8R | BR000G | 2024-06-19T12:00:18.683Z | 2024-06-27T12:11:00.634Z |
Advanced export
JSON shape: default, array, newline-delimited
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);