participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,346 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 |
---|---|---|---|---|---|
5457907 | 5457907 | 20241102153841_ckm1r | NZ003T | 2024-11-03T14:08:20.113Z | 2024-11-03T14:08:20.113Z |
5457801 | 5457801 | 20241102152419_gP2Rb | NZ003T | 2024-11-03T14:08:11.934Z | 2024-11-03T14:08:11.934Z |
5457624 | 5457624 | 20241102145501_EswmU | NZ003T | 2024-11-03T14:07:44.759Z | 2024-11-03T14:07:44.759Z |
5457395 | 5457395 | 20241102142311_FW4LR | NZ003T | 2024-11-03T14:07:13.459Z | 2024-11-03T14:07:13.459Z |
5457013 | 5457013 | 20241102131330_Yhqlk | NZ003T | 2024-11-03T14:06:22.059Z | 2024-11-03T14:06:22.059Z |
5456348 | 5456348 | 20241102110331_tmrIy | NZ003T | 2024-11-03T14:04:16.411Z | 2024-11-03T14:04:16.411Z |
5456271 | 5456271 | 20241102105133_8Hviq | NZ003T | 2024-11-03T14:04:04.537Z | 2024-11-03T14:04:04.537Z |
5456079 | 5456079 | 20241102101743_dnWmA | NZ003T | 2024-11-03T14:03:17.069Z | 2024-11-03T14:03:17.069Z |
5455886 | 5455886 | 20241102093805_3yhpy | NZ003T | 2024-11-03T14:02:34.461Z | 2024-11-03T14:02:34.461Z |
5455837 | 5455837 | 20241102092922_dkcdZ | NZ003T | 2024-11-03T14:02:27.454Z | 2024-11-03T14:02:27.454Z |
5455568 | 5455568 | 20241102082943_BJGYW | NZ003T | 2024-11-03T14:01:26.055Z | 2024-11-03T14:01:26.055Z |
5449569 | 5449569 | 20241031155454_xG99F | NZ003T | 2024-11-02T12:13:07.012Z | 2024-11-03T14:20:54.951Z |
5446241 | 5446241 | 20241031094010_Jma2P | NZ003T | 2024-11-02T12:04:40.550Z | 2024-11-03T14:19:58.887Z |
5446131 | 5446131 | 20241031093003_23eKn | NZ003T | 2024-11-02T12:04:19.838Z | 2024-11-03T14:19:55.808Z |
5445787 | 5445787 | 20241031084931_uUB33 | NZ003T | 2024-11-02T12:03:13.468Z | 2024-11-03T14:19:49.992Z |
5436563 | 5436563 | 20241030132120_mSDUU | NZ003T | 2024-11-01T12:07:52.400Z | 2024-11-03T14:22:37.069Z |
5435693 | 5435693 | 20241030114936_0dVm6 | NZ003T | 2024-11-01T12:05:45.963Z | 2024-11-03T14:22:33.511Z |
5435653 | 5435653 | 20241030114715_WSIBU | NZ003T | 2024-11-01T12:05:43.258Z | 2024-11-03T14:22:33.436Z |
5435400 | 5435400 | 20241030112605_qa2Rc | NZ003T | 2024-11-01T12:05:05.911Z | 2024-11-03T14:22:32.494Z |
5435371 | 5435371 | 20241030112152_XBOkZ | NZ003T | 2024-11-01T12:05:01.794Z | 2024-11-03T14:22:32.347Z |
5427986 | 5427986 | 20241028160945_X9gTQ | NZ003T | 2024-10-31T12:14:22.104Z | 2024-11-03T14:24:49.421Z |
5427496 | 5427496 | 20241028151056_AqXNE | NZ003T | 2024-10-31T12:13:34.636Z | 2024-11-03T14:24:47.960Z |
5427378 | 5427378 | 20241028150120_60X2u | NZ003T | 2024-10-31T12:13:29.039Z | 2024-11-03T14:24:47.587Z |
5427100 | 5427100 | 20241028143115_o2627 | NZ003T | 2024-10-31T12:13:07.660Z | 2024-11-03T14:24:45.824Z |
5427011 | 5427011 | 20241028142036_dRj8V | NZ003T | 2024-10-31T12:12:51.876Z | 2024-11-03T14:24:45.648Z |
5426960 | 5426960 | 20241028141546_bVdyB | NZ003T | 2024-10-31T12:12:43.540Z | 2024-11-03T14:24:45.535Z |
5426940 | 5426940 | 20241028141258_Ttq7L | NZ003T | 2024-10-31T12:12:41.061Z | 2024-11-03T14:24:45.462Z |
5426789 | 5426789 | 20241028135652_093xN | NZ003T | 2024-10-31T12:12:28.305Z | 2024-11-03T14:24:45.039Z |
5425206 | 5425206 | 20241029160944_zkmUG | NZ003T | 2024-10-31T12:07:14.044Z | 2024-11-03T14:23:41.295Z |
5425072 | 5425072 | 20241029154706_1Xjt0 | NZ003T | 2024-10-31T12:06:46.112Z | 2024-11-03T14:23:40.734Z |
5424893 | 5424893 | 20241029152828_cEA8k | NZ003T | 2024-10-31T12:06:20.634Z | 2024-11-03T14:23:39.643Z |
5424215 | 5424215 | 20241029133953_qdU80 | NZ003T | 2024-10-31T12:04:18.109Z | 2024-11-03T14:23:35.431Z |
5424211 | 5424211 | 20241029133845_oM58T | NZ003T | 2024-10-31T12:04:17.713Z | 2024-11-03T14:23:35.431Z |
5424071 | 5424071 | 20241029125527_376VP | NZ003T | 2024-10-31T12:03:42.998Z | 2024-11-03T14:23:34.083Z |
5424059 | 5424059 | 20241029124959_6JtKG | NZ003T | 2024-10-31T12:03:40.774Z | 2024-11-03T14:23:34.012Z |
5424040 | 5424040 | 20241029124650_Vwrx0 | NZ003T | 2024-10-31T12:03:37.330Z | 2024-11-03T14:23:33.952Z |
5423615 | 5423615 | 20241029111203_RrddT | NZ003T | 2024-10-31T12:02:09.472Z | 2024-11-03T14:23:28.899Z |
5416413 | 5416413 | 20241027154951_ygYT3 | NZ003T | 2024-10-30T12:11:33.794Z | 2024-11-03T14:25:42.171Z |
5416393 | 5416393 | 20241027154734_I5Pk3 | NZ003T | 2024-10-30T12:11:32.546Z | 2024-11-03T14:25:42.157Z |
5416388 | 5416388 | 20241027154712_zj8uh | NZ003T | 2024-10-30T12:11:32.033Z | 2024-11-03T14:25:42.152Z |
5416383 | 5416383 | 20241027154637_Jd50n | NZ003T | 2024-10-30T12:11:31.495Z | 2024-11-03T14:25:42.148Z |
5416106 | 5416106 | 20241027151425_QL2i7 | NZ003T | 2024-10-30T12:10:59.978Z | 2024-11-03T14:25:41.484Z |
5415957 | 5415957 | 20241027145358_HwixS | NZ003T | 2024-10-30T12:10:40.722Z | 2024-11-03T14:25:41.301Z |
5415630 | 5415630 | 20241027141822_3da21 | NZ003T | 2024-10-30T12:10:08.426Z | 2024-11-03T14:25:39.964Z |
5415230 | 5415230 | 20241027132404_k5hU1 | NZ003T | 2024-10-30T12:09:20.874Z | 2024-11-03T14:25:39.352Z |
5413180 | 5413180 | 20241028090500_V2bIK | NZ003T | 2024-10-30T12:02:10.570Z | 2024-11-03T14:24:32.735Z |
5392185 | 5392185 | 20241026152710_8W3f2 | NZ003T | 2024-10-28T12:07:18.860Z | 2024-11-03T14:26:16.824Z |
5392148 | 5392148 | 20241026152021_pVyU1 | NZ003T | 2024-10-28T12:07:14.111Z | 2024-11-03T14:26:16.781Z |
5392054 | 5392054 | 20241026144950_cgXMN | NZ003T | 2024-10-28T12:07:05.051Z | 2024-11-03T14:26:16.525Z |
5380623 | 5380623 | 20241025112045_KYcgs | NZ003T | 2024-10-27T12:06:22.351Z | 2024-11-03T14:27:11.692Z |
5358157 | 5358157 | 20241023110610_Z9TJ9 | NZ003T | 2024-10-25T12:05:31.072Z | 2024-11-01T12:26:42.166Z |
5336312 | 5336312 | 20241022080917_KK6BE | NZ003T | 2024-10-23T12:02:06.226Z | 2024-10-31T12:29:39.665Z |
5336241 | 5336241 | 20241022075746_4YAKr | NZ003T | 2024-10-23T12:01:51.815Z | 2024-10-31T12:29:39.548Z |
5329898 | 5329898 | 20241021110541_DJZOc | NZ003T | 2024-10-22T12:05:34.061Z | 2024-10-30T12:26:35.751Z |
5325400 | 5325400 | 20241020151531_X2YrF | NZ003T | 2024-10-21T12:05:46.916Z | 2024-10-29T12:26:31.112Z |
5325398 | 5325398 | 20241020151357_6bccx | NZ003T | 2024-10-21T12:05:46.843Z | 2024-10-29T12:26:31.111Z |
5325355 | 5325355 | 20241020144347_fJX2Q | NZ003T | 2024-10-21T12:05:31.866Z | 2024-10-29T12:26:31.006Z |
5325308 | 5325308 | 20241020143158_5L5Bq | NZ003T | 2024-10-21T12:05:23.586Z | 2024-10-29T12:26:30.920Z |
5325274 | 5325274 | 20241020142004_y4JIx | NZ003T | 2024-10-21T12:05:19.424Z | 2024-10-29T12:26:30.887Z |
5325270 | 5325270 | 20241020141451_AvIzD | NZ003T | 2024-10-21T12:05:18.390Z | 2024-10-29T12:26:30.877Z |
5325259 | 5325259 | 20241020141023_j6N24 | NZ003T | 2024-10-21T12:05:17.003Z | 2024-10-29T12:26:30.840Z |
5325245 | 5325245 | 20241020140343_49nih | NZ003T | 2024-10-21T12:05:15.552Z | 2024-10-29T12:26:30.831Z |
5325187 | 5325187 | 20241020133849_mfvm5 | NZ003T | 2024-10-21T12:05:09.235Z | 2024-10-29T12:26:30.731Z |
5324259 | 5324259 | 20241020090913_BiSGv | NZ003T | 2024-10-21T12:02:11.439Z | 2024-10-29T12:26:28.412Z |
5322525 | 5322525 | 20241019131830_ASFCZ | NZ003T | 2024-10-20T12:02:18.396Z | 2024-10-28T12:26:40.925Z |
5322471 | 5322471 | 20241019124742_YU3pH | NZ003T | 2024-10-20T12:02:10.394Z | 2024-10-28T12:26:40.825Z |
5322412 | 5322412 | 20241019120917_q4UbA | NZ003T | 2024-10-20T12:01:57.982Z | 2024-10-28T12:26:40.624Z |
5322407 | 5322407 | 20241019120456_mu3tA | NZ003T | 2024-10-20T12:01:56.626Z | 2024-10-28T12:26:40.621Z |
5322358 | 5322358 | 20241019113706_kAS5D | NZ003T | 2024-10-20T12:01:47.131Z | 2024-10-28T12:26:40.430Z |
5322302 | 5322302 | 20241019105353_JRL9C | NZ003T | 2024-10-20T12:01:37.734Z | 2024-10-28T12:26:40.329Z |
5322224 | 5322224 | 20241019100531_d4u3t | NZ003T | 2024-10-20T12:01:25.138Z | 2024-10-28T12:26:40.102Z |
5321962 | 5321962 | 20241019080340_px0uq | NZ003T | 2024-10-20T12:00:34.419Z | 2024-10-28T12:26:39.460Z |
5315975 | 5315975 | 20241015160358_RqxaC | NZ003T | 2024-10-17T12:05:37.547Z | 2024-10-24T12:27:55.078Z |
5315950 | 5315950 | 20241015155812_0LDW1 | NZ003T | 2024-10-17T12:05:35.154Z | 2024-10-24T12:27:55.044Z |
5315814 | 5315814 | 20241015152007_R8YpS | NZ003T | 2024-10-17T12:05:27.441Z | 2024-10-24T12:27:54.641Z |
5315765 | 5315765 | 20241015150750_nfSY0 | NZ003T | 2024-10-17T12:05:23.994Z | 2024-10-24T12:27:54.355Z |
5315662 | 5315662 | 20241015143757_iqvAy | NZ003T | 2024-10-17T12:05:16.479Z | 2024-10-24T12:27:53.845Z |
5315581 | 5315581 | 20241015141307_yiUn9 | NZ003T | 2024-10-17T12:05:03.782Z | 2024-10-24T12:27:53.419Z |
5314857 | 5314857 | 20241016161812_oVMGq | NZ003T | 2024-10-17T12:03:01.998Z | 2024-10-25T12:24:32.633Z |
5314808 | 5314808 | 20241016160101_ZXZCn | NZ003T | 2024-10-17T12:02:53.114Z | 2024-10-25T12:24:32.348Z |
5314647 | 5314647 | 20241016144608_LaeIx | NZ003T | 2024-10-17T12:02:38.057Z | 2024-10-25T12:24:31.490Z |
5314597 | 5314597 | 20241016142912_zsSSo | NZ003T | 2024-10-17T12:02:34.950Z | 2024-10-25T12:24:31.313Z |
5314509 | 5314509 | 20241016133425_vcEif | NZ003T | 2024-10-17T12:02:29.677Z | 2024-10-25T12:24:31.044Z |
5314450 | 5314450 | 20241016130231_lAyOo | NZ003T | 2024-10-17T12:02:24.819Z | 2024-10-25T12:24:30.406Z |
5314428 | 5314428 | 20241016125603_GdYU5 | NZ003T | 2024-10-17T12:02:20.912Z | 2024-10-25T12:24:30.365Z |
5314309 | 5314309 | 20241016122044_SYKjP | NZ003T | 2024-10-17T12:02:03.279Z | 2024-10-25T12:24:29.587Z |
5314000 | 5314000 | 20241016110147_yE8tX | NZ003T | 2024-10-17T12:01:32.813Z | 2024-10-25T12:24:28.306Z |
5313939 | 5313939 | 20241016104822_cg00x | NZ003T | 2024-10-17T12:01:22.254Z | 2024-10-25T12:24:28.015Z |
5310408 | 5310408 | 20241014163231_l1iWA | NZ003T | 2024-10-16T12:06:50.860Z | 2024-10-23T12:24:32.548Z |
5310267 | 5310267 | 20241014161330_wteLn | NZ003T | 2024-10-16T12:06:37.490Z | 2024-10-23T12:24:31.816Z |
5310236 | 5310236 | 20241014160942_V5TBJ | NZ003T | 2024-10-16T12:06:34.867Z | 2024-10-23T12:24:31.657Z |
5310133 | 5310133 | 20241014155029_9zy8C | NZ003T | 2024-10-16T12:06:29.374Z | 2024-10-23T12:24:31.007Z |
5310110 | 5310110 | 20241014154727_3Dnps | NZ003T | 2024-10-16T12:06:27.758Z | 2024-10-23T12:24:30.633Z |
5310083 | 5310083 | 20241014154131_rLey0 | NZ003T | 2024-10-16T12:06:26.120Z | 2024-10-23T12:24:30.554Z |
5310050 | 5310050 | 20241014153409_nB1qp | NZ003T | 2024-10-16T12:06:24.932Z | 2024-10-23T12:24:30.497Z |
5309880 | 5309880 | 20241014144205_AvLws | NZ003T | 2024-10-16T12:06:08.477Z | 2024-10-23T12:24:28.985Z |
5309861 | 5309861 | 20241014143248_lwhJJ | NZ003T | 2024-10-16T12:06:05.578Z | 2024-10-23T12:24:28.744Z |
5309736 | 5309736 | 20241014140358_HrFBF | NZ003T | 2024-10-16T12:05:50.015Z | 2024-10-23T12:24:27.471Z |
5309623 | 5309623 | 20241014131758_iLXxb | NZ003T | 2024-10-16T12:05:41.322Z | 2024-10-23T12:24:26.790Z |
5309612 | 5309612 | 20241014131617_ybUm2 | NZ003T | 2024-10-16T12:05:40.286Z | 2024-10-23T12:24:26.640Z |
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);