participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,689,338 rows 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 |
---|---|---|---|---|---|
4689338 | 4689338 | 20240720012738_bdTQc | FR0011 | 2024-07-26T12:15:46.047Z | 2024-07-26T12:15:46.047Z |
4689337 | 4689337 | 20240720012738_bdTQc | FR0006 | 2024-07-26T12:15:46.047Z | 2024-07-26T12:15:46.047Z |
4689336 | 4689336 | 20240720012738_bdTQc | BE0001 | 2024-07-26T12:15:46.047Z | 2024-07-26T12:15:46.047Z |
4689335 | 4689335 | 20240720012118_s71t9 | NL000S | 2024-07-26T12:15:45.450Z | 2024-07-26T12:15:45.450Z |
4689334 | 4689334 | 20240720012118_s71t9 | FR0006 | 2024-07-26T12:15:45.450Z | 2024-07-26T12:15:45.450Z |
4689333 | 4689333 | 20240720011557_qbC2n | NL0001 | 2024-07-26T12:15:44.807Z | 2024-07-26T12:15:44.807Z |
4689332 | 4689332 | 20240720011557_qbC2n | FR0011 | 2024-07-26T12:15:44.807Z | 2024-07-26T12:15:44.807Z |
4689331 | 4689331 | 20240720011557_qbC2n | FR000Y | 2024-07-26T12:15:44.807Z | 2024-07-26T12:15:44.807Z |
4689330 | 4689330 | 20240720011557_qbC2n | FR0006 | 2024-07-26T12:15:44.807Z | 2024-07-26T12:15:44.807Z |
4689329 | 4689329 | 20240720011557_qbC2n | BE000E | 2024-07-26T12:15:44.807Z | 2024-07-26T12:15:44.807Z |
4689328 | 4689328 | 20240720011557_qbC2n | BE0007 | 2024-07-26T12:15:44.807Z | 2024-07-26T12:15:44.807Z |
4689327 | 4689327 | 20240720010613_Y51PL | FR0006 | 2024-07-26T12:15:41.676Z | 2024-07-26T12:15:41.676Z |
4689326 | 4689326 | 20240720010613_Y51PL | BE000U | 2024-07-26T12:15:41.676Z | 2024-07-26T12:15:41.676Z |
4689325 | 4689325 | 20240720000032_8xeTl | FR000V | 2024-07-26T12:15:30.065Z | 2024-07-26T12:15:30.065Z |
4689324 | 4689324 | 20240720000032_8xeTl | FR0006 | 2024-07-26T12:15:30.065Z | 2024-07-26T12:15:30.065Z |
4689323 | 4689323 | 20240724182924_3AQSa | KR002N | 2024-07-26T12:11:29.433Z | 2024-07-26T12:12:25.065Z |
4689322 | 4689322 | 20240724182924_3AQSa | KR001E | 2024-07-26T12:11:29.433Z | 2024-07-26T12:12:25.065Z |
4689321 | 4689321 | 20240724182851_ZiMal | NZ003Z | 2024-07-26T12:11:28.915Z | 2024-07-26T12:12:25.064Z |
4689320 | 4689320 | 20240724182851_ZiMal | NZ003V | 2024-07-26T12:11:28.915Z | 2024-07-26T12:12:25.064Z |
4689319 | 4689319 | 20240724182851_ZiMal | NZ002F | 2024-07-26T12:11:28.915Z | 2024-07-26T12:12:25.064Z |
4689318 | 4689318 | 20240724182851_ZiMal | NZ0015 | 2024-07-26T12:11:28.915Z | 2024-07-26T12:12:25.064Z |
4689317 | 4689317 | 20240724182851_ZiMal | NZ000T | 2024-07-26T12:11:28.915Z | 2024-07-26T12:12:25.064Z |
4689316 | 4689316 | 20240724182659_MkGMN | NZ004C | 2024-07-26T12:11:28.394Z | 2024-07-26T12:12:25.063Z |
4689315 | 4689315 | 20240724182659_MkGMN | NZ000T | 2024-07-26T12:11:28.394Z | 2024-07-26T12:12:25.063Z |
4689314 | 4689314 | 20240724182635_Df1JJ | NZ0051 | 2024-07-26T12:11:28.080Z | 2024-07-26T12:12:25.062Z |
4689313 | 4689313 | 20240724182635_Df1JJ | NZ003U | 2024-07-26T12:11:28.080Z | 2024-07-26T12:12:25.062Z |
4689312 | 4689312 | 20240724182635_Df1JJ | NZ0035 | 2024-07-26T12:11:28.080Z | 2024-07-26T12:12:25.062Z |
4689311 | 4689311 | 20240724182606_pQ2TO | NZ002T | 2024-07-26T12:11:27.866Z | 2024-07-26T12:12:25.061Z |
4689310 | 4689310 | 20240724182606_pQ2TO | NZ000J | 2024-07-26T12:11:27.866Z | 2024-07-26T12:12:25.061Z |
4689309 | 4689309 | 20240724182430_3FUSg | KR002N | 2024-07-26T12:11:27.824Z | 2024-07-26T12:12:25.060Z |
4689308 | 4689308 | 20240724182430_3FUSg | KR001E | 2024-07-26T12:11:27.824Z | 2024-07-26T12:12:25.060Z |
4689307 | 4689307 | 20240724182312_CHeNR | NZ003Z | 2024-07-26T12:11:26.548Z | 2024-07-26T12:12:25.059Z |
4689306 | 4689306 | 20240724182312_CHeNR | NZ002T | 2024-07-26T12:11:26.548Z | 2024-07-26T12:12:25.059Z |
4689305 | 4689305 | 20240724182312_CHeNR | NZ0003 | 2024-07-26T12:11:26.548Z | 2024-07-26T12:12:25.059Z |
4689304 | 4689304 | 20240724182049_bDYYS | NZ004H | 2024-07-26T12:11:26.090Z | 2024-07-26T12:12:25.058Z |
4689303 | 4689303 | 20240724182049_bDYYS | NZ003C | 2024-07-26T12:11:26.090Z | 2024-07-26T12:12:25.058Z |
4689302 | 4689302 | 20240724182049_bDYYS | NZ001Q | 2024-07-26T12:11:26.090Z | 2024-07-26T12:12:25.058Z |
4689301 | 4689301 | 20240724182049_bDYYS | NZ000X | 2024-07-26T12:11:26.090Z | 2024-07-26T12:12:25.058Z |
4689300 | 4689300 | 20240724182049_bDYYS | NZ0004 | 2024-07-26T12:11:26.090Z | 2024-07-26T12:12:25.058Z |
4689299 | 4689299 | 20240724182013_RP3dD | NZ002T | 2024-07-26T12:11:25.757Z | 2024-07-26T12:12:25.057Z |
4689298 | 4689298 | 20240724182013_RP3dD | NZ0007 | 2024-07-26T12:11:25.757Z | 2024-07-26T12:12:25.057Z |
4689297 | 4689297 | 20240724181958_vQfrY | NZ003C | 2024-07-26T12:11:25.386Z | 2024-07-26T12:12:25.056Z |
4689296 | 4689296 | 20240724181958_vQfrY | NZ0004 | 2024-07-26T12:11:25.386Z | 2024-07-26T12:12:25.056Z |
4689295 | 4689295 | 20240724181920_8m0d6 | NZ004V | 2024-07-26T12:11:25.186Z | 2024-07-26T12:12:25.055Z |
4689294 | 4689294 | 20240724181920_8m0d6 | NZ003U | 2024-07-26T12:11:25.186Z | 2024-07-26T12:12:25.055Z |
4689293 | 4689293 | 20240724181831_grzLG | NZ004T | 2024-07-26T12:11:24.859Z | 2024-07-26T12:12:25.054Z |
4689292 | 4689292 | 20240724181831_grzLG | NZ0042 | 2024-07-26T12:11:24.859Z | 2024-07-26T12:12:25.054Z |
4689291 | 4689291 | 20240724181831_grzLG | NZ003N | 2024-07-26T12:11:24.859Z | 2024-07-26T12:12:25.054Z |
4689290 | 4689290 | 20240724181831_grzLG | NZ0014 | 2024-07-26T12:11:24.859Z | 2024-07-26T12:12:25.054Z |
4689289 | 4689289 | 20240724181830_TtnXA | KR002N | 2024-07-26T12:11:24.371Z | 2024-07-26T12:12:25.053Z |
4689288 | 4689288 | 20240724181830_TtnXA | KR0014 | 2024-07-26T12:11:24.371Z | 2024-07-26T12:12:25.053Z |
4689287 | 4689287 | 20240724181807_KrCmo | NZ004E | 2024-07-26T12:11:24.199Z | 2024-07-26T12:12:25.052Z |
4689286 | 4689286 | 20240724181807_KrCmo | NZ003U | 2024-07-26T12:11:24.199Z | 2024-07-26T12:12:25.052Z |
4689285 | 4689285 | 20240724181807_KrCmo | NZ003B | 2024-07-26T12:11:24.199Z | 2024-07-26T12:12:25.052Z |
4689284 | 4689284 | 20240724181717_OmzfV | NZ003Z | 2024-07-26T12:11:24.196Z | 2024-07-26T12:12:25.051Z |
4689283 | 4689283 | 20240724181717_OmzfV | NZ002T | 2024-07-26T12:11:24.196Z | 2024-07-26T12:12:25.051Z |
4689282 | 4689282 | 20240724181717_OmzfV | NZ0015 | 2024-07-26T12:11:24.196Z | 2024-07-26T12:12:25.051Z |
4689281 | 4689281 | 20240724181717_OmzfV | NZ000T | 2024-07-26T12:11:24.196Z | 2024-07-26T12:12:25.051Z |
4689280 | 4689280 | 20240724181717_OmzfV | NZ0003 | 2024-07-26T12:11:24.196Z | 2024-07-26T12:12:25.051Z |
4689279 | 4689279 | 20240724181625_bBqpg | NZ003R | 2024-07-26T12:11:24.035Z | 2024-07-26T12:12:25.050Z |
4689278 | 4689278 | 20240724181625_bBqpg | NZ0037 | 2024-07-26T12:11:24.035Z | 2024-07-26T12:12:25.050Z |
4689277 | 4689277 | 20240724181625_bBqpg | NZ002N | 2024-07-26T12:11:24.035Z | 2024-07-26T12:12:25.050Z |
4689276 | 4689276 | 20240724181625_bBqpg | NZ002K | 2024-07-26T12:11:24.035Z | 2024-07-26T12:12:25.050Z |
4689275 | 4689275 | 20240724181527_Hwycv | AU001K | 2024-07-26T12:11:24.019Z | 2024-07-26T12:12:25.049Z |
4689274 | 4689274 | 20240724181527_Hwycv | AU000T | 2024-07-26T12:11:24.019Z | 2024-07-26T12:12:25.049Z |
4689273 | 4689273 | 20240724181515_yZwNG | NZ002T | 2024-07-26T12:11:23.429Z | 2024-07-26T12:12:25.048Z |
4689272 | 4689272 | 20240724181515_yZwNG | NZ0007 | 2024-07-26T12:11:23.428Z | 2024-07-26T12:12:25.048Z |
4689271 | 4689271 | 20240724181442_PFuDn | NZ004H | 2024-07-26T12:11:23.362Z | 2024-07-26T12:12:25.047Z |
4689270 | 4689270 | 20240724181442_PFuDn | NZ0049 | 2024-07-26T12:11:23.362Z | 2024-07-26T12:12:25.047Z |
4689269 | 4689269 | 20240724181442_PFuDn | NZ003C | 2024-07-26T12:11:23.362Z | 2024-07-26T12:12:25.047Z |
4689268 | 4689268 | 20240724181442_PFuDn | NZ001Q | 2024-07-26T12:11:23.362Z | 2024-07-26T12:12:25.047Z |
4689267 | 4689267 | 20240724181442_PFuDn | NZ000X | 2024-07-26T12:11:23.362Z | 2024-07-26T12:12:25.047Z |
4689266 | 4689266 | 20240724181442_PFuDn | NZ0004 | 2024-07-26T12:11:23.362Z | 2024-07-26T12:12:25.047Z |
4689265 | 4689265 | 20240724181409_uMe8k | NZ0037 | 2024-07-26T12:11:23.246Z | 2024-07-26T12:12:25.046Z |
4689264 | 4689264 | 20240724181409_uMe8k | NZ002K | 2024-07-26T12:11:23.246Z | 2024-07-26T12:12:25.046Z |
4689263 | 4689263 | 20240724181409_uMe8k | NZ002J | 2024-07-26T12:11:23.246Z | 2024-07-26T12:12:25.046Z |
4689262 | 4689262 | 20240724181350_jpo7T | NZ003B | 2024-07-26T12:11:23.127Z | 2024-07-26T12:12:25.046Z |
4689261 | 4689261 | 20240724181350_jpo7T | NZ002B | 2024-07-26T12:11:23.127Z | 2024-07-26T12:12:25.046Z |
4689260 | 4689260 | 20240724181350_jpo7T | NZ000W | 2024-07-26T12:11:23.127Z | 2024-07-26T12:12:25.045Z |
4689259 | 4689259 | 20240724181350_jpo7T | NZ0002 | 2024-07-26T12:11:23.127Z | 2024-07-26T12:12:25.045Z |
4689258 | 4689258 | 20240724181350_jpo7T | NZ0001 | 2024-07-26T12:11:23.127Z | 2024-07-26T12:12:25.045Z |
4689257 | 4689257 | 20240724181111_K3QNq | NZ003Z | 2024-07-26T12:11:23.068Z | 2024-07-26T12:12:25.044Z |
4689256 | 4689256 | 20240724181111_K3QNq | NZ0007 | 2024-07-26T12:11:23.068Z | 2024-07-26T12:12:25.044Z |
4689255 | 4689255 | 20240724181031_nQlvY | NZ004T | 2024-07-26T12:11:23.043Z | 2024-07-26T12:12:25.044Z |
4689254 | 4689254 | 20240724181031_nQlvY | NZ0042 | 2024-07-26T12:11:23.043Z | 2024-07-26T12:12:25.044Z |
4689253 | 4689253 | 20240724181031_nQlvY | NZ003R | 2024-07-26T12:11:23.043Z | 2024-07-26T12:12:25.044Z |
4689252 | 4689252 | 20240724181031_nQlvY | NZ002N | 2024-07-26T12:11:23.043Z | 2024-07-26T12:12:25.044Z |
4689251 | 4689251 | 20240724181031_nQlvY | NZ0014 | 2024-07-26T12:11:23.043Z | 2024-07-26T12:12:25.044Z |
4689250 | 4689250 | 20240724181031_nQlvY | NZ000Y | 2024-07-26T12:11:23.043Z | 2024-07-26T12:12:25.044Z |
4689249 | 4689249 | 20240724181015_B67OK | KR001K | 2024-07-26T12:11:22.862Z | 2024-07-26T12:12:25.042Z |
4689248 | 4689248 | 20240724181015_B67OK | KR0017 | 2024-07-26T12:11:22.862Z | 2024-07-26T12:12:25.042Z |
4689247 | 4689247 | 20240724180940_Cn6hK | AU0030 | 2024-07-26T12:11:22.061Z | 2024-07-26T12:12:25.042Z |
4689246 | 4689246 | 20240724180940_Cn6hK | AU001D | 2024-07-26T12:11:22.061Z | 2024-07-26T12:12:25.042Z |
4689245 | 4689245 | 20240724180907_qTs6p | NZ003W | 2024-07-26T12:11:21.901Z | 2024-07-26T12:12:25.041Z |
4689244 | 4689244 | 20240724180907_qTs6p | NZ001G | 2024-07-26T12:11:21.901Z | 2024-07-26T12:12:25.041Z |
4689243 | 4689243 | 20240724180906_vq1bo | NZ003T | 2024-07-26T12:11:21.808Z | 2024-07-26T12:12:25.040Z |
4689242 | 4689242 | 20240724180906_vq1bo | NZ0038 | 2024-07-26T12:11:21.808Z | 2024-07-26T12:12:25.040Z |
4689241 | 4689241 | 20240724180906_vq1bo | NZ0023 | 2024-07-26T12:11:21.808Z | 2024-07-26T12:12:25.040Z |
4689240 | 4689240 | 20240724180852_xbEVJ | NZ0029 | 2024-07-26T12:11:21.366Z | 2024-07-26T12:12:25.039Z |
4689239 | 4689239 | 20240724180852_xbEVJ | NZ0007 | 2024-07-26T12:11:21.366Z | 2024-07-26T12:12:25.039Z |
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);