participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,415 rows where station_code = "NZ003T" 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 |
---|---|---|---|---|---|
5569517 | 5569517 | 20241121154813_bbmTj | NZ003T | 2024-11-22T14:11:00.868Z | 2024-11-22T14:11:00.868Z |
5569440 | 5569440 | 20241121153034_LQhk3 | NZ003T | 2024-11-22T14:10:53.225Z | 2024-11-22T14:10:53.225Z |
5569208 | 5569208 | 20241121145240_ejHtw | NZ003T | 2024-11-22T14:10:37.880Z | 2024-11-22T14:10:37.880Z |
5569206 | 5569206 | 20241121145156_5ysbK | NZ003T | 2024-11-22T14:10:36.273Z | 2024-11-22T14:10:36.273Z |
5569108 | 5569108 | 20241121143723_CQK01 | NZ003T | 2024-11-22T14:10:21.727Z | 2024-11-22T14:10:21.727Z |
5568992 | 5568992 | 20241121141407_30bnl | NZ003T | 2024-11-22T14:10:09.511Z | 2024-11-22T14:10:09.511Z |
5568957 | 5568957 | 20241121140953_IdksL | NZ003T | 2024-11-22T14:10:06.890Z | 2024-11-22T14:10:06.890Z |
5568829 | 5568829 | 20241121134403_j8YDP | NZ003T | 2024-11-22T14:09:53.647Z | 2024-11-22T14:09:53.647Z |
5568769 | 5568769 | 20241121133131_vcyKK | NZ003T | 2024-11-22T14:09:40.909Z | 2024-11-22T14:09:40.909Z |
5568738 | 5568738 | 20241121132915_dVNbP | NZ003T | 2024-11-22T14:09:38.482Z | 2024-11-22T14:09:38.482Z |
5568538 | 5568538 | 20241121125701_5VRhP | NZ003T | 2024-11-22T14:09:18.060Z | 2024-11-22T14:09:18.060Z |
5568366 | 5568366 | 20241121123136_eAfH2 | NZ003T | 2024-11-22T14:08:48.456Z | 2024-11-22T14:08:48.456Z |
5568268 | 5568268 | 20241121121548_FrQA0 | NZ003T | 2024-11-22T14:08:37.176Z | 2024-11-22T14:08:37.176Z |
5568059 | 5568059 | 20241121114507_HA7jj | NZ003T | 2024-11-22T14:08:01.976Z | 2024-11-22T14:08:01.976Z |
5567905 | 5567905 | 20241121112802_KHkHM | NZ003T | 2024-11-22T14:07:33.642Z | 2024-11-22T14:07:33.642Z |
5567671 | 5567671 | 20241121105103_4FJtH | NZ003T | 2024-11-22T14:06:49.227Z | 2024-11-22T14:06:49.227Z |
5567616 | 5567616 | 20241121104502_XNUeb | NZ003T | 2024-11-22T14:06:40.008Z | 2024-11-22T14:06:40.008Z |
5567604 | 5567604 | 20241121104309_snM1K | NZ003T | 2024-11-22T14:06:36.732Z | 2024-11-22T14:06:36.732Z |
5567534 | 5567534 | 20241121103215_WqLbW | NZ003T | 2024-11-22T14:06:28.152Z | 2024-11-22T14:06:28.152Z |
5551716 | 5551716 | 20241118145416_vr0CM | NZ003T | 2024-11-19T14:05:17.709Z | 2024-11-22T14:22:12.223Z |
5551659 | 5551659 | 20241118143956_sY8pt | NZ003T | 2024-11-19T14:05:08.262Z | 2024-11-22T14:22:11.958Z |
5551565 | 5551565 | 20241118141320_i317e | NZ003T | 2024-11-19T14:04:59.775Z | 2024-11-22T14:22:11.429Z |
5551471 | 5551471 | 20241118134828_UOc24 | NZ003T | 2024-11-19T14:04:50.815Z | 2024-11-22T14:22:10.899Z |
5551196 | 5551196 | 20241118124350_2WCLV | NZ003T | 2024-11-19T14:04:05.831Z | 2024-11-22T14:22:09.096Z |
5551111 | 5551111 | 20241118122716_JQhZO | NZ003T | 2024-11-19T14:03:55.738Z | 2024-11-22T14:22:08.356Z |
5547267 | 5547267 | 20241117152400_TDxag | NZ003T | 2024-11-18T14:05:23.913Z | 2024-11-22T14:22:38.298Z |
5547222 | 5547222 | 20241117150851_YhECW | NZ003T | 2024-11-18T14:05:18.235Z | 2024-11-22T14:22:38.089Z |
5547167 | 5547167 | 20241117150304_Pemgo | NZ003T | 2024-11-18T14:05:12.942Z | 2024-11-22T14:22:37.791Z |
5542839 | 5542839 | 20241115134258_FTZ7z | NZ003T | 2024-11-16T14:02:43.964Z | 2024-11-22T14:23:31.630Z |
5542655 | 5542655 | 20241115113557_ye3mY | NZ003T | 2024-11-16T14:02:07.587Z | 2024-11-22T14:23:29.698Z |
5536155 | 5536155 | 20241112155553_ZuKaq | NZ003T | 2024-11-14T14:09:15.797Z | 2024-11-21T14:25:57.076Z |
5536153 | 5536153 | 20241112155343_IgpTs | NZ003T | 2024-11-14T14:09:15.566Z | 2024-11-21T14:25:57.061Z |
5535879 | 5535879 | 20241112144005_dgXY2 | NZ003T | 2024-11-14T14:08:56.559Z | 2024-11-21T14:25:54.221Z |
5535852 | 5535852 | 20241112143730_gMerp | NZ003T | 2024-11-14T14:08:54.602Z | 2024-11-21T14:25:53.832Z |
5535692 | 5535692 | 20241112134234_YuwGl | NZ003T | 2024-11-14T14:08:23.223Z | 2024-11-21T14:25:51.173Z |
5535643 | 5535643 | 20241112132310_akJRt | NZ003T | 2024-11-14T14:08:15.123Z | 2024-11-21T14:25:50.803Z |
5535349 | 5535349 | 20241112121819_jUShL | NZ003T | 2024-11-14T14:07:50.430Z | 2024-11-21T14:25:46.526Z |
5526834 | 5526834 | 20241112102051_UyRJt | NZ003T | 2024-11-13T14:04:18.947Z | 2024-11-21T14:25:38.916Z |
5520439 | 5520439 | 20241111155619_NRET1 | NZ003T | 2024-11-12T14:06:20.829Z | 2024-11-20T14:25:09.772Z |
5520212 | 5520212 | 20241111145829_hhRtS | NZ003T | 2024-11-12T14:05:58.257Z | 2024-11-20T14:25:05.823Z |
5519787 | 5519787 | 20241111130049_X532m | NZ003T | 2024-11-12T14:04:59.183Z | 2024-11-20T14:24:57.862Z |
5519647 | 5519647 | 20241111122037_IJibr | NZ003T | 2024-11-12T14:04:39.576Z | 2024-11-20T14:24:54.451Z |
5519475 | 5519475 | 20241111113402_EKiz6 | NZ003T | 2024-11-12T14:04:08.464Z | 2024-11-20T14:24:50.872Z |
5514119 | 5514119 | 20241110143410_zirJf | NZ003T | 2024-11-11T14:06:14.044Z | 2024-11-19T14:21:43.792Z |
5514115 | 5514115 | 20241110143200_lSkz8 | NZ003T | 2024-11-11T14:06:13.539Z | 2024-11-19T14:21:43.692Z |
5514101 | 5514101 | 20241110142655_vAwJy | NZ003T | 2024-11-11T14:06:08.449Z | 2024-11-19T14:21:43.397Z |
5500422 | 5500422 | 20241108153952_wca5J | NZ003T | 2024-11-09T14:06:15.558Z | 2024-11-17T14:23:22.544Z |
5493881 | 5493881 | 20241107142446_3PU92 | NZ003T | 2024-11-08T14:04:48.664Z | 2024-11-16T14:27:42.765Z |
5493701 | 5493701 | 20241107130501_hu0rS | NZ003T | 2024-11-08T14:04:30.490Z | 2024-11-16T14:27:39.121Z |
5493371 | 5493371 | 20241107115919_eVOOq | NZ003T | 2024-11-08T14:03:38.127Z | 2024-11-16T14:27:33.820Z |
5493351 | 5493351 | 20241107115224_DLxpV | NZ003T | 2024-11-08T14:03:35.698Z | 2024-11-16T14:27:33.655Z |
5493338 | 5493338 | 20241107115022_4EUS1 | NZ003T | 2024-11-08T14:03:34.575Z | 2024-11-16T14:27:33.598Z |
5493258 | 5493258 | 20241107112824_I1Cmu | NZ003T | 2024-11-08T14:03:21.686Z | 2024-11-16T14:27:33.191Z |
5493129 | 5493129 | 20241107110052_uMjeE | NZ003T | 2024-11-08T14:02:55.735Z | 2024-11-16T14:27:32.203Z |
5493124 | 5493124 | 20241107110006_o6Cv5 | NZ003T | 2024-11-08T14:02:54.611Z | 2024-11-16T14:27:32.158Z |
5492496 | 5492496 | 20241107084305_NVbws | NZ003T | 2024-11-08T14:01:17.475Z | 2024-11-16T14:27:25.982Z |
5492452 | 5492452 | 20241107083627_iO6ig | NZ003T | 2024-11-08T14:01:12.853Z | 2024-11-16T14:27:25.417Z |
5473555 | 5473555 | 20241103143202_weoMc | NZ003T | 2024-11-05T14:09:05.988Z | 2024-11-12T14:27:49.708Z |
5473417 | 5473417 | 20241103141259_hHX23 | NZ003T | 2024-11-05T14:08:54.634Z | 2024-11-12T14:27:49.514Z |
5473277 | 5473277 | 20241103135303_LjEQ7 | NZ003T | 2024-11-05T14:08:44.371Z | 2024-11-12T14:27:48.419Z |
5473177 | 5473177 | 20241103133648_xMX38 | NZ003T | 2024-11-05T14:08:28.617Z | 2024-11-12T14:27:48.130Z |
5472955 | 5472955 | 20241103130351_nrZ73 | NZ003T | 2024-11-05T14:07:54.646Z | 2024-11-12T14:27:47.338Z |
5472737 | 5472737 | 20241103123120_CrFiK | NZ003T | 2024-11-05T14:07:38.306Z | 2024-11-12T14:27:46.489Z |
5465453 | 5465453 | 20241103120632_PNVO6 | NZ003T | 2024-11-04T14:03:45.226Z | 2024-11-12T14:27:46.235Z |
5465304 | 5465304 | 20241103112135_FmbWj | NZ003T | 2024-11-04T14:03:17.305Z | 2024-11-12T14:27:45.895Z |
5465298 | 5465298 | 20241103111939_zlxAm | NZ003T | 2024-11-04T14:03:16.401Z | 2024-11-12T14:27:45.892Z |
5465147 | 5465147 | 20241103104939_i5wEr | NZ003T | 2024-11-04T14:02:56.452Z | 2024-11-12T14:27:45.235Z |
5465054 | 5465054 | 20241103103015_uUzv0 | NZ003T | 2024-11-04T14:02:36.148Z | 2024-11-12T14:27:44.348Z |
5464897 | 5464897 | 20241103094911_65Qjg | NZ003T | 2024-11-04T14:02:07.233Z | 2024-11-12T14:27:43.842Z |
5457907 | 5457907 | 20241102153841_ckm1r | NZ003T | 2024-11-03T14:08:20.113Z | 2024-11-11T14:22:37.242Z |
5457801 | 5457801 | 20241102152419_gP2Rb | NZ003T | 2024-11-03T14:08:11.934Z | 2024-11-11T14:22:36.780Z |
5457624 | 5457624 | 20241102145501_EswmU | NZ003T | 2024-11-03T14:07:44.759Z | 2024-11-11T14:22:35.722Z |
5457395 | 5457395 | 20241102142311_FW4LR | NZ003T | 2024-11-03T14:07:13.459Z | 2024-11-11T14:22:34.443Z |
5457013 | 5457013 | 20241102131330_Yhqlk | NZ003T | 2024-11-03T14:06:22.059Z | 2024-11-11T14:22:32.360Z |
5456348 | 5456348 | 20241102110331_tmrIy | NZ003T | 2024-11-03T14:04:16.411Z | 2024-11-11T14:22:27.899Z |
5456271 | 5456271 | 20241102105133_8Hviq | NZ003T | 2024-11-03T14:04:04.537Z | 2024-11-11T14:22:27.477Z |
5456079 | 5456079 | 20241102101743_dnWmA | NZ003T | 2024-11-03T14:03:17.069Z | 2024-11-11T14:22:26.344Z |
5455886 | 5455886 | 20241102093805_3yhpy | NZ003T | 2024-11-03T14:02:34.461Z | 2024-11-11T14:22:24.703Z |
5455837 | 5455837 | 20241102092922_dkcdZ | NZ003T | 2024-11-03T14:02:27.454Z | 2024-11-11T14:22:24.457Z |
5455568 | 5455568 | 20241102082943_BJGYW | NZ003T | 2024-11-03T14:01:26.055Z | 2024-11-11T14:22:22.386Z |
5449569 | 5449569 | 20241031155454_xG99F | NZ003T | 2024-11-02T12:13:07.012Z | 2024-11-09T14:24:11.174Z |
5446241 | 5446241 | 20241031094010_Jma2P | NZ003T | 2024-11-02T12:04:40.550Z | 2024-11-09T14:23:53.903Z |
5446131 | 5446131 | 20241031093003_23eKn | NZ003T | 2024-11-02T12:04:19.838Z | 2024-11-09T14:23:53.066Z |
5445787 | 5445787 | 20241031084931_uUB33 | NZ003T | 2024-11-02T12:03:13.468Z | 2024-11-09T14:23:51.346Z |
5436563 | 5436563 | 20241030132120_mSDUU | NZ003T | 2024-11-01T12:07:52.400Z | 2024-11-08T14:22:54.306Z |
5435693 | 5435693 | 20241030114936_0dVm6 | NZ003T | 2024-11-01T12:05:45.963Z | 2024-11-08T14:22:51.375Z |
5435653 | 5435653 | 20241030114715_WSIBU | NZ003T | 2024-11-01T12:05:43.258Z | 2024-11-08T14:22:51.338Z |
5435400 | 5435400 | 20241030112605_qa2Rc | NZ003T | 2024-11-01T12:05:05.911Z | 2024-11-08T14:22:50.398Z |
5435371 | 5435371 | 20241030112152_XBOkZ | NZ003T | 2024-11-01T12:05:01.794Z | 2024-11-08T14:22:50.316Z |
5427986 | 5427986 | 20241028160945_X9gTQ | NZ003T | 2024-10-31T12:14:22.104Z | 2024-11-06T14:27:12.871Z |
5427496 | 5427496 | 20241028151056_AqXNE | NZ003T | 2024-10-31T12:13:34.636Z | 2024-11-06T14:27:11.829Z |
5427378 | 5427378 | 20241028150120_60X2u | NZ003T | 2024-10-31T12:13:29.039Z | 2024-11-06T14:27:11.709Z |
5427100 | 5427100 | 20241028143115_o2627 | NZ003T | 2024-10-31T12:13:07.660Z | 2024-11-06T14:27:11.386Z |
5427011 | 5427011 | 20241028142036_dRj8V | NZ003T | 2024-10-31T12:12:51.876Z | 2024-11-06T14:27:11.268Z |
5426960 | 5426960 | 20241028141546_bVdyB | NZ003T | 2024-10-31T12:12:43.540Z | 2024-11-06T14:27:11.114Z |
5426940 | 5426940 | 20241028141258_Ttq7L | NZ003T | 2024-10-31T12:12:41.061Z | 2024-11-06T14:27:10.971Z |
5426789 | 5426789 | 20241028135652_093xN | NZ003T | 2024-10-31T12:12:28.305Z | 2024-11-06T14:27:10.621Z |
5425206 | 5425206 | 20241029160944_zkmUG | NZ003T | 2024-10-31T12:07:14.044Z | 2024-11-07T14:26:33.931Z |
5425072 | 5425072 | 20241029154706_1Xjt0 | NZ003T | 2024-10-31T12:06:46.112Z | 2024-11-07T14:26:33.688Z |
5424893 | 5424893 | 20241029152828_cEA8k | NZ003T | 2024-10-31T12:06:20.634Z | 2024-11-07T14:26:33.182Z |
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);