participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,312 rows where station_code = "NZ0023" 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 |
---|---|---|---|---|---|
5458593 | 5458593 | 20241101084754_KWVyj | NZ0023 | 2024-11-03T14:10:03.491Z | 2024-11-03T14:19:33.156Z |
5457799 | 5457799 | 20241102152419_gP2Rb | NZ0023 | 2024-11-03T14:08:11.934Z | 2024-11-03T14:08:11.934Z |
5456650 | 5456650 | 20241102115815_My3Po | NZ0023 | 2024-11-03T14:05:13.706Z | 2024-11-03T14:05:13.706Z |
5456345 | 5456345 | 20241102110331_tmrIy | NZ0023 | 2024-11-03T14:04:16.387Z | 2024-11-03T14:04:16.387Z |
5456270 | 5456270 | 20241102105133_8Hviq | NZ0023 | 2024-11-03T14:04:04.513Z | 2024-11-03T14:04:04.513Z |
5449701 | 5449701 | 20241031161049_OD4n9 | NZ0023 | 2024-11-02T12:13:24.795Z | 2024-11-03T14:20:57.723Z |
5449624 | 5449624 | 20241031160207_TMtkK | NZ0023 | 2024-11-02T12:13:13.854Z | 2024-11-03T14:20:55.792Z |
5449566 | 5449566 | 20241031155454_xG99F | NZ0023 | 2024-11-02T12:13:07.012Z | 2024-11-03T14:20:54.951Z |
5449554 | 5449554 | 20241031155243_GAcXp | NZ0023 | 2024-11-02T12:13:05.646Z | 2024-11-03T14:20:54.771Z |
5449528 | 5449528 | 20241031154756_pyeOQ | NZ0023 | 2024-11-02T12:13:03.761Z | 2024-11-03T14:20:54.275Z |
5449371 | 5449371 | 20241031152614_0PsXi | NZ0023 | 2024-11-02T12:12:47.628Z | 2024-11-03T14:20:52.102Z |
5449303 | 5449303 | 20241031151752_wqN1W | NZ0023 | 2024-11-02T12:12:27.889Z | 2024-11-03T14:20:51.066Z |
5449243 | 5449243 | 20241031150956_SidMs | NZ0023 | 2024-11-02T12:12:20.248Z | 2024-11-03T14:20:49.846Z |
5449173 | 5449173 | 20241031150153_6rg4X | NZ0023 | 2024-11-02T12:12:12.769Z | 2024-11-03T14:20:49.317Z |
5449154 | 5449154 | 20241031150003_IBvKw | NZ0023 | 2024-11-02T12:12:10.722Z | 2024-11-03T14:20:49.190Z |
5448633 | 5448633 | 20241031135943_f90cP | NZ0023 | 2024-11-02T12:11:13.269Z | 2024-11-03T14:20:40.394Z |
5448625 | 5448625 | 20241031135700_A4E73 | NZ0023 | 2024-11-02T12:11:12.527Z | 2024-11-03T14:20:40.305Z |
5448347 | 5448347 | 20241031131814_2X83s | NZ0023 | 2024-11-02T12:10:34.798Z | 2024-11-03T14:20:36.268Z |
5448211 | 5448211 | 20241031125940_6aMin | NZ0023 | 2024-11-02T12:10:17.321Z | 2024-11-03T14:20:34.219Z |
5448199 | 5448199 | 20241031125833_pRl3S | NZ0023 | 2024-11-02T12:10:15.049Z | 2024-11-03T14:20:34.105Z |
5448086 | 5448086 | 20241031124149_06ZIq | NZ0023 | 2024-11-02T12:09:55.839Z | 2024-11-03T14:20:32.590Z |
5446891 | 5446891 | 20241031104454_2cKy3 | NZ0023 | 2024-11-02T12:06:40.029Z | 2024-11-03T14:20:11.400Z |
5446848 | 5446848 | 20241031103907_gRoFt | NZ0023 | 2024-11-02T12:06:31.612Z | 2024-11-03T14:20:09.973Z |
5446672 | 5446672 | 20241031102044_rESW3 | NZ0023 | 2024-11-02T12:06:01.258Z | 2024-11-03T14:20:05.834Z |
5437150 | 5437150 | 20241030143447_6QrvP | NZ0023 | 2024-11-01T12:09:09.584Z | 2024-11-03T14:22:38.745Z |
5436795 | 5436795 | 20241030134834_vAbAA | NZ0023 | 2024-11-01T12:08:21.756Z | 2024-11-03T14:22:37.734Z |
5436671 | 5436671 | 20241030133619_33DHB | NZ0023 | 2024-11-01T12:08:03.862Z | 2024-11-03T14:22:37.473Z |
5435492 | 5435492 | 20241030113421_H3yTl | NZ0023 | 2024-11-01T12:05:18.592Z | 2024-11-03T14:22:32.920Z |
5427491 | 5427491 | 20241028151056_AqXNE | NZ0023 | 2024-10-31T12:13:34.636Z | 2024-11-03T14:24:47.960Z |
5427239 | 5427239 | 20241028144942_yC3ne | NZ0023 | 2024-10-31T12:13:21.945Z | 2024-11-03T14:24:46.393Z |
5415423 | 5415423 | 20241027135130_oJUqs | NZ0023 | 2024-10-30T12:09:42.716Z | 2024-11-03T14:25:39.634Z |
5415250 | 5415250 | 20241027132728_wMU3W | NZ0023 | 2024-10-30T12:09:25.732Z | 2024-11-03T14:25:39.376Z |
5413186 | 5413186 | 20241028090631_W2ERA | NZ0023 | 2024-10-30T12:02:11.883Z | 2024-11-03T14:24:32.787Z |
5367760 | 5367760 | 20241024073527_a3tUj | NZ0023 | 2024-10-26T12:01:27.550Z | 2024-11-02T12:28:14.552Z |
5360360 | 5360360 | 20241023160324_0uW2e | NZ0023 | 2024-10-25T12:10:40.214Z | 2024-11-01T12:26:47.391Z |
5358686 | 5358686 | 20241023115633_IoSh6 | NZ0023 | 2024-10-25T12:06:42.871Z | 2024-11-01T12:26:43.847Z |
5358449 | 5358449 | 20241023113242_cw42i | NZ0023 | 2024-10-25T12:06:06.880Z | 2024-11-01T12:26:43.113Z |
5358242 | 5358242 | 20241023111347_WVAZ3 | NZ0023 | 2024-10-25T12:05:40.724Z | 2024-11-01T12:26:42.363Z |
5357953 | 5357953 | 20241023103701_nIlxc | NZ0023 | 2024-10-25T12:04:55.920Z | 2024-11-01T12:26:41.637Z |
5347125 | 5347125 | 20241022141904_iPxPP | NZ0023 | 2024-10-24T12:07:02.450Z | 2024-10-31T12:29:49.329Z |
5347080 | 5347080 | 20241022140939_YMhQv | NZ0023 | 2024-10-24T12:06:45.774Z | 2024-10-31T12:29:49.228Z |
5347052 | 5347052 | 20241022140428_cyUaL | NZ0023 | 2024-10-24T12:06:42.281Z | 2024-10-31T12:29:49.172Z |
5347008 | 5347008 | 20241022135207_lUIQ6 | NZ0023 | 2024-10-24T12:06:34.291Z | 2024-10-31T12:29:48.959Z |
5346905 | 5346905 | 20241022131943_tXT1B | NZ0023 | 2024-10-24T12:06:16.442Z | 2024-10-31T12:29:48.250Z |
5346867 | 5346867 | 20241022131341_GzPVH | NZ0023 | 2024-10-24T12:06:08.587Z | 2024-10-31T12:29:48.163Z |
5346822 | 5346822 | 20241022125750_bHnYk | NZ0023 | 2024-10-24T12:05:56.764Z | 2024-10-31T12:29:48.076Z |
5346733 | 5346733 | 20241022123604_63fa0 | NZ0023 | 2024-10-24T12:05:34.446Z | 2024-10-31T12:29:47.785Z |
5346718 | 5346718 | 20241022123305_R3hG7 | NZ0023 | 2024-10-24T12:05:32.996Z | 2024-10-31T12:29:47.766Z |
5346672 | 5346672 | 20241022122500_RHyge | NZ0023 | 2024-10-24T12:05:25.464Z | 2024-10-31T12:29:47.654Z |
5346641 | 5346641 | 20241022122011_3nEqG | NZ0023 | 2024-10-24T12:05:21.972Z | 2024-10-31T12:29:47.499Z |
5346192 | 5346192 | 20241022113534_XTnyW | NZ0023 | 2024-10-24T12:03:55.727Z | 2024-10-31T12:29:46.408Z |
5345595 | 5345595 | 20241022094657_OAVtQ | NZ0023 | 2024-10-24T12:01:56.667Z | 2024-10-31T12:29:43.899Z |
5331917 | 5331917 | 20241021154231_ztOcP | NZ0023 | 2024-10-22T12:09:55.194Z | 2024-10-30T12:26:40.131Z |
5331844 | 5331844 | 20241021153249_LdvHZ | NZ0023 | 2024-10-22T12:09:48.906Z | 2024-10-30T12:26:40.062Z |
5331770 | 5331770 | 20241021152400_lq7lo | NZ0023 | 2024-10-22T12:09:41.174Z | 2024-10-30T12:26:40.006Z |
5331052 | 5331052 | 20241021133532_JnIx9 | NZ0023 | 2024-10-22T12:08:21.654Z | 2024-10-30T12:26:38.876Z |
5330995 | 5330995 | 20241021132150_Yo4Yy | NZ0023 | 2024-10-22T12:08:16.407Z | 2024-10-30T12:26:38.773Z |
5330863 | 5330863 | 20241021125621_fbXxj | NZ0023 | 2024-10-22T12:08:02.937Z | 2024-10-30T12:26:38.606Z |
5328626 | 5328626 | 20241021082105_eMJZm | NZ0023 | 2024-10-22T12:02:02.131Z | 2024-10-30T12:26:32.625Z |
5328346 | 5328346 | 20241021073759_2IXop | NZ0023 | 2024-10-22T12:01:09.785Z | 2024-10-30T12:26:31.977Z |
5322807 | 5322807 | 20241019160411_sZXUI | NZ0023 | 2024-10-20T12:03:08.930Z | 2024-10-28T12:26:41.349Z |
5317847 | 5317847 | 20241017110637_MNwQz | NZ0023 | 2024-10-18T12:00:57.256Z | 2024-10-26T12:27:51.792Z |
5316087 | 5316087 | 20241015162714_lyjwr | NZ0023 | 2024-10-17T12:05:46.118Z | 2024-10-24T12:27:55.311Z |
5316042 | 5316042 | 20241015161620_3MGpP | NZ0023 | 2024-10-17T12:05:42.612Z | 2024-10-24T12:27:55.210Z |
5315973 | 5315973 | 20241015160358_RqxaC | NZ0023 | 2024-10-17T12:05:37.547Z | 2024-10-24T12:27:55.078Z |
5315968 | 5315968 | 20241015160305_hbE44 | NZ0023 | 2024-10-17T12:05:37.181Z | 2024-10-24T12:27:55.063Z |
5315963 | 5315963 | 20241015160026_fCpfS | NZ0023 | 2024-10-17T12:05:36.666Z | 2024-10-24T12:27:55.060Z |
5315947 | 5315947 | 20241015155812_0LDW1 | NZ0023 | 2024-10-17T12:05:35.154Z | 2024-10-24T12:27:55.044Z |
5315806 | 5315806 | 20241015151842_6zxdH | NZ0023 | 2024-10-17T12:05:27.131Z | 2024-10-24T12:27:54.633Z |
5315762 | 5315762 | 20241015150750_nfSY0 | NZ0023 | 2024-10-17T12:05:23.994Z | 2024-10-24T12:27:54.355Z |
5315660 | 5315660 | 20241015143757_iqvAy | NZ0023 | 2024-10-17T12:05:16.479Z | 2024-10-24T12:27:53.845Z |
5315604 | 5315604 | 20241015142322_s2tZN | NZ0023 | 2024-10-17T12:05:07.062Z | 2024-10-24T12:27:53.672Z |
5315576 | 5315576 | 20241015141307_yiUn9 | NZ0023 | 2024-10-17T12:05:03.782Z | 2024-10-24T12:27:53.419Z |
5315512 | 5315512 | 20241015133918_I0i43 | NZ0023 | 2024-10-17T12:04:52.316Z | 2024-10-24T12:27:53.182Z |
5315432 | 5315432 | 20241015131152_TU2J9 | NZ0023 | 2024-10-17T12:04:41.374Z | 2024-10-24T12:27:52.877Z |
5315400 | 5315400 | 20241015124942_GU7HQ | NZ0023 | 2024-10-17T12:04:36.153Z | 2024-10-24T12:27:52.742Z |
5315392 | 5315392 | 20241015124906_ttIMt | NZ0023 | 2024-10-17T12:04:35.155Z | 2024-10-24T12:27:52.724Z |
5314872 | 5314872 | 20241016162545_aVdyD | NZ0023 | 2024-10-17T12:03:03.977Z | 2024-10-25T12:24:32.652Z |
5314804 | 5314804 | 20241016160101_ZXZCn | NZ0023 | 2024-10-17T12:02:53.114Z | 2024-10-25T12:24:32.348Z |
5314773 | 5314773 | 20241016154732_CRYdc | NZ0023 | 2024-10-17T12:02:46.944Z | 2024-10-25T12:24:32.283Z |
5314707 | 5314707 | 20241016151430_MFDHe | NZ0023 | 2024-10-17T12:02:42.836Z | 2024-10-25T12:24:31.705Z |
5314594 | 5314594 | 20241016142912_zsSSo | NZ0023 | 2024-10-17T12:02:34.950Z | 2024-10-25T12:24:31.313Z |
5314507 | 5314507 | 20241016133425_vcEif | NZ0023 | 2024-10-17T12:02:29.677Z | 2024-10-25T12:24:31.044Z |
5314505 | 5314505 | 20241016133357_ufW87 | NZ0023 | 2024-10-17T12:02:29.394Z | 2024-10-25T12:24:31.028Z |
5314446 | 5314446 | 20241016130231_lAyOo | NZ0023 | 2024-10-17T12:02:24.819Z | 2024-10-25T12:24:30.406Z |
5314427 | 5314427 | 20241016125603_GdYU5 | NZ0023 | 2024-10-17T12:02:20.912Z | 2024-10-25T12:24:30.365Z |
5314305 | 5314305 | 20241016122044_SYKjP | NZ0023 | 2024-10-17T12:02:03.278Z | 2024-10-25T12:24:29.587Z |
5314299 | 5314299 | 20241016122029_kUf9P | NZ0023 | 2024-10-17T12:02:02.269Z | 2024-10-25T12:24:29.543Z |
5314200 | 5314200 | 20241016115830_ykL28 | NZ0023 | 2024-10-17T12:01:50.730Z | 2024-10-25T12:24:29.011Z |
5314034 | 5314034 | 20241016111327_pPa9V | NZ0023 | 2024-10-17T12:01:36.505Z | 2024-10-25T12:24:28.485Z |
5313999 | 5313999 | 20241016110147_yE8tX | NZ0023 | 2024-10-17T12:01:32.813Z | 2024-10-25T12:24:28.306Z |
5313946 | 5313946 | 20241016104927_z4Cl4 | NZ0023 | 2024-10-17T12:01:23.394Z | 2024-10-25T12:24:28.023Z |
5313938 | 5313938 | 20241016104822_cg00x | NZ0023 | 2024-10-17T12:01:22.254Z | 2024-10-25T12:24:28.015Z |
5313715 | 5313715 | 20241016094428_BhrsW | NZ0023 | 2024-10-17T12:00:53.397Z | 2024-10-25T12:24:26.754Z |
5313703 | 5313703 | 20241016094003_Ob92m | NZ0023 | 2024-10-17T12:00:52.092Z | 2024-10-25T12:24:26.726Z |
5310406 | 5310406 | 20241014163231_l1iWA | NZ0023 | 2024-10-16T12:06:50.860Z | 2024-10-23T12:24:32.548Z |
5310321 | 5310321 | 20241014162014_t2lXT | NZ0023 | 2024-10-16T12:06:41.045Z | 2024-10-23T12:24:32.103Z |
5310235 | 5310235 | 20241014160942_V5TBJ | NZ0023 | 2024-10-16T12:06:34.867Z | 2024-10-23T12:24:31.657Z |
5310221 | 5310221 | 20241014160814_yi2Ka | NZ0023 | 2024-10-16T12:06:34.104Z | 2024-10-23T12:24:31.511Z |
5310201 | 5310201 | 20241014160258_viNrF | NZ0023 | 2024-10-16T12:06:32.961Z | 2024-10-23T12:24:31.473Z |
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);