participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,274 rows where station_code = "NZ000Z" 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 |
---|---|---|---|---|---|
5577164 | 5577164 | 20241121113653_7Wtz3 | NZ000Z | 2024-11-23T14:13:32.101Z | 2024-11-24T14:21:57.416Z |
5576659 | 5576659 | 20241122124653_OeonO | NZ000Z | 2024-11-23T14:10:00.842Z | 2024-11-24T14:21:10.728Z |
5575253 | 5575253 | 20241122085337_MVRph | NZ000Z | 2024-11-23T14:05:59.829Z | 2024-11-24T14:21:10.264Z |
5569511 | 5569511 | 20241121154653_urD5q | NZ000Z | 2024-11-22T14:11:00.377Z | 2024-11-24T14:22:14.768Z |
5569479 | 5569479 | 20241121153757_LiTPU | NZ000Z | 2024-11-22T14:10:57.062Z | 2024-11-24T14:22:14.622Z |
5569379 | 5569379 | 20241121152102_ySKp1 | NZ000Z | 2024-11-22T14:10:49.736Z | 2024-11-24T14:22:14.150Z |
5569315 | 5569315 | 20241121150806_C2wqk | NZ000Z | 2024-11-22T14:10:45.447Z | 2024-11-24T14:22:13.792Z |
5569233 | 5569233 | 20241121145506_rjDQH | NZ000Z | 2024-11-22T14:10:41.190Z | 2024-11-24T14:22:13.520Z |
5568977 | 5568977 | 20241121141221_9LGTn | NZ000Z | 2024-11-22T14:10:08.603Z | 2024-11-24T14:22:10.510Z |
5568839 | 5568839 | 20241121134802_XaJlm | NZ000Z | 2024-11-22T14:09:58.468Z | 2024-11-24T14:22:09.059Z |
5568747 | 5568747 | 20241121132934_hxELp | NZ000Z | 2024-11-22T14:09:39.823Z | 2024-11-24T14:22:08.013Z |
5568721 | 5568721 | 20241121132743_thqpP | NZ000Z | 2024-11-22T14:09:37.088Z | 2024-11-24T14:22:07.934Z |
5568704 | 5568704 | 20241121132417_gyLjU | NZ000Z | 2024-11-22T14:09:35.347Z | 2024-11-24T14:22:07.738Z |
5568619 | 5568619 | 20241121131329_s2Os4 | NZ000Z | 2024-11-22T14:09:26.746Z | 2024-11-24T14:22:06.711Z |
5568435 | 5568435 | 20241121124816_sQfVs | NZ000Z | 2024-11-22T14:08:57.573Z | 2024-11-24T14:22:03.811Z |
5568361 | 5568361 | 20241121123112_cScL5 | NZ000Z | 2024-11-22T14:08:48.244Z | 2024-11-24T14:22:02.559Z |
5567801 | 5567801 | 20241121111152_sN7Tv | NZ000Z | 2024-11-22T14:07:18.061Z | 2024-11-24T14:21:54.938Z |
5559766 | 5559766 | 20241120111422_4LvVz | NZ000Z | 2024-11-21T14:07:08.952Z | 2024-11-24T14:23:10.225Z |
5559033 | 5559033 | 20241120090734_2wEq3 | NZ000Z | 2024-11-21T14:05:07.451Z | 2024-11-24T14:22:59.518Z |
5556238 | 5556238 | 20241118151037_s99LH | NZ000Z | 2024-11-20T14:09:31.729Z | 2024-11-24T14:24:58.675Z |
5555656 | 5555656 | 20241119142328_eIGMM | NZ000Z | 2024-11-20T14:06:20.904Z | 2024-11-24T14:24:18.945Z |
5555487 | 5555487 | 20241119133118_D75Fl | NZ000Z | 2024-11-20T14:05:51.084Z | 2024-11-24T14:24:17.939Z |
5555378 | 5555378 | 20241119130124_sX75W | NZ000Z | 2024-11-20T14:05:23.498Z | 2024-11-24T14:24:17.385Z |
5555123 | 5555123 | 20241119115109_C7FHf | NZ000Z | 2024-11-20T14:04:30.787Z | 2024-11-24T14:24:16.058Z |
5554886 | 5554886 | 20241119105530_TTRd3 | NZ000Z | 2024-11-20T14:03:43.498Z | 2024-11-24T14:24:14.067Z |
5554576 | 5554576 | 20241119094016_9XNad | NZ000Z | 2024-11-20T14:02:31.689Z | 2024-11-24T14:24:12.238Z |
5554500 | 5554500 | 20241119091904_IGDTr | NZ000Z | 2024-11-20T14:02:19.005Z | 2024-11-24T14:24:11.624Z |
5554454 | 5554454 | 20241119090702_6NkI2 | NZ000Z | 2024-11-20T14:02:12.229Z | 2024-11-24T14:24:11.184Z |
5551849 | 5551849 | 20241118152401_mfqZ2 | NZ000Z | 2024-11-19T14:05:43.520Z | 2024-11-24T14:24:58.807Z |
5551843 | 5551843 | 20241118152340_KsOu2 | NZ000Z | 2024-11-19T14:05:43.152Z | 2024-11-24T14:24:58.806Z |
5551800 | 5551800 | 20241118151736_ns2I7 | NZ000Z | 2024-11-19T14:05:32.934Z | 2024-11-24T14:24:58.710Z |
5551698 | 5551698 | 20241118144824_NfJJM | NZ000Z | 2024-11-19T14:05:15.365Z | 2024-11-24T14:24:58.372Z |
5551672 | 5551672 | 20241118144059_dJ2vS | NZ000Z | 2024-11-19T14:05:10.260Z | 2024-11-24T14:24:58.304Z |
5551669 | 5551669 | 20241118144023_3AIM5 | NZ000Z | 2024-11-19T14:05:09.715Z | 2024-11-24T14:24:58.302Z |
5551157 | 5551157 | 20241118123608_OQ4z1 | NZ000Z | 2024-11-19T14:04:00.660Z | 2024-11-24T14:24:56.799Z |
5550510 | 5550510 | 20241118103624_W5rbh | NZ000Z | 2024-11-19T14:02:28.929Z | 2024-11-24T14:24:53.938Z |
5550502 | 5550502 | 20241118103547_ronMK | NZ000Z | 2024-11-19T14:02:27.831Z | 2024-11-24T14:24:53.925Z |
5550474 | 5550474 | 20241118102431_jCRxv | NZ000Z | 2024-11-19T14:02:24.019Z | 2024-11-24T14:24:53.790Z |
5550409 | 5550409 | 20241118101750_72uPF | NZ000Z | 2024-11-19T14:02:18.662Z | 2024-11-24T14:24:53.589Z |
5550350 | 5550350 | 20241118100846_roAPu | NZ000Z | 2024-11-19T14:02:13.712Z | 2024-11-24T14:24:53.231Z |
5550280 | 5550280 | 20241118095844_9SqQ1 | NZ000Z | 2024-11-19T14:02:03.460Z | 2024-11-24T14:24:52.949Z |
5550172 | 5550172 | 20241118094333_rrpl2 | NZ000Z | 2024-11-19T14:01:41.457Z | 2024-11-24T14:24:52.472Z |
5547317 | 5547317 | 20241117153751_gLqIR | NZ000Z | 2024-11-18T14:05:30.763Z | 2024-11-24T14:25:16.949Z |
5547215 | 5547215 | 20241117150813_4jD5R | NZ000Z | 2024-11-18T14:05:17.471Z | 2024-11-24T14:25:16.468Z |
5547125 | 5547125 | 20241117145620_eozo6 | NZ000Z | 2024-11-18T14:05:08.710Z | 2024-11-24T14:25:15.997Z |
5547033 | 5547033 | 20241117142523_Z4oIb | NZ000Z | 2024-11-18T14:04:45.752Z | 2024-11-24T14:25:15.648Z |
5536037 | 5536037 | 20241112152819_V3A66 | NZ000Z | 2024-11-14T14:09:08.079Z | 2024-11-21T14:25:56.343Z |
5535962 | 5535962 | 20241112150616_5FDPG | NZ000Z | 2024-11-14T14:09:02.968Z | 2024-11-21T14:25:55.512Z |
5535900 | 5535900 | 20241112144927_ngFhq | NZ000Z | 2024-11-14T14:08:58.204Z | 2024-11-21T14:25:54.574Z |
5535701 | 5535701 | 20241112135035_Aua2w | NZ000Z | 2024-11-14T14:08:27.374Z | 2024-11-21T14:25:51.360Z |
5535686 | 5535686 | 20241112134156_XumDs | NZ000Z | 2024-11-14T14:08:22.665Z | 2024-11-21T14:25:51.165Z |
5535108 | 5535108 | 20241112113847_Tu0Pm | NZ000Z | 2024-11-14T14:07:15.901Z | 2024-11-21T14:25:43.892Z |
5535077 | 5535077 | 20241112113332_CIhQj | NZ000Z | 2024-11-14T14:07:10.934Z | 2024-11-21T14:25:43.677Z |
5535013 | 5535013 | 20241112112623_Y61T6 | NZ000Z | 2024-11-14T14:07:06.181Z | 2024-11-21T14:25:43.028Z |
5534927 | 5534927 | 20241112111003_xQPbn | NZ000Z | 2024-11-14T14:06:59.813Z | 2024-11-21T14:25:41.681Z |
5526766 | 5526766 | 20241112101251_tenSr | NZ000Z | 2024-11-13T14:04:07.314Z | 2024-11-21T14:25:38.157Z |
5520330 | 5520330 | 20241111152203_wCNdR | NZ000Z | 2024-11-12T14:06:10.353Z | 2024-11-20T14:25:06.811Z |
5520226 | 5520226 | 20241111150104_eBrpI | NZ000Z | 2024-11-12T14:05:59.712Z | 2024-11-20T14:25:06.027Z |
5520222 | 5520222 | 20241111145916_oO4lw | NZ000Z | 2024-11-12T14:05:59.452Z | 2024-11-20T14:25:05.990Z |
5520158 | 5520158 | 20241111145217_DV7pL | NZ000Z | 2024-11-12T14:05:46.371Z | 2024-11-20T14:25:05.245Z |
5520120 | 5520120 | 20241111144159_lCySs | NZ000Z | 2024-11-12T14:05:39.668Z | 2024-11-20T14:25:04.115Z |
5520102 | 5520102 | 20241111143753_i37je | NZ000Z | 2024-11-12T14:05:37.409Z | 2024-11-20T14:25:03.767Z |
5520034 | 5520034 | 20241111142552_0B72m | NZ000Z | 2024-11-12T14:05:30.016Z | 2024-11-20T14:25:02.620Z |
5519918 | 5519918 | 20241111135445_aq81s | NZ000Z | 2024-11-12T14:05:19.526Z | 2024-11-20T14:25:00.636Z |
5519906 | 5519906 | 20241111135240_AmduP | NZ000Z | 2024-11-12T14:05:18.799Z | 2024-11-20T14:25:00.617Z |
5519899 | 5519899 | 20241111135152_wcPKn | NZ000Z | 2024-11-12T14:05:18.527Z | 2024-11-20T14:25:00.600Z |
5519884 | 5519884 | 20241111134526_jWMrw | NZ000Z | 2024-11-12T14:05:16.627Z | 2024-11-20T14:25:00.448Z |
5519769 | 5519769 | 20241111125823_WYi2H | NZ000Z | 2024-11-12T14:04:57.649Z | 2024-11-20T14:24:57.629Z |
5519653 | 5519653 | 20241111122118_fhdVb | NZ000Z | 2024-11-12T14:04:40.377Z | 2024-11-20T14:24:54.508Z |
5519492 | 5519492 | 20241111113812_F2GH4 | NZ000Z | 2024-11-12T14:04:16.024Z | 2024-11-20T14:24:51.248Z |
5519286 | 5519286 | 20241111105529_m4SQB | NZ000Z | 2024-11-12T14:03:36.818Z | 2024-11-20T14:24:47.145Z |
5513470 | 5513470 | 20241110113519_HFIWT | NZ000Z | 2024-11-11T14:04:41.595Z | 2024-11-19T14:21:34.619Z |
5508621 | 5508621 | 20241108142257_8ZJ5e | NZ000Z | 2024-11-10T14:10:26.980Z | 2024-11-17T14:23:17.959Z |
5508607 | 5508607 | 20241108111138_DuHg8 | NZ000Z | 2024-11-10T14:09:36.706Z | 2024-11-17T14:23:06.327Z |
5501508 | 5501508 | 20241107134622_KSvtl | NZ000Z | 2024-11-09T14:09:56.440Z | 2024-11-16T14:27:41.178Z |
5501486 | 5501486 | 20241107132659_DIMdH | NZ000Z | 2024-11-09T14:09:54.212Z | 2024-11-16T14:27:40.789Z |
5501475 | 5501475 | 20241107132351_5AAAE | NZ000Z | 2024-11-09T14:09:52.965Z | 2024-11-16T14:27:40.592Z |
5501427 | 5501427 | 20241107130039_2g6aO | NZ000Z | 2024-11-09T14:09:34.242Z | 2024-11-16T14:27:39.014Z |
5500440 | 5500440 | 20241108154324_22e4g | NZ000Z | 2024-11-09T14:06:17.610Z | 2024-11-17T14:23:22.719Z |
5500398 | 5500398 | 20241108153451_Gs4YJ | NZ000Z | 2024-11-09T14:06:13.224Z | 2024-11-17T14:23:22.452Z |
5500276 | 5500276 | 20241108151025_EdYtV | NZ000Z | 2024-11-09T14:06:03.070Z | 2024-11-17T14:23:21.025Z |
5500260 | 5500260 | 20241108150911_WzkNj | NZ000Z | 2024-11-09T14:06:01.975Z | 2024-11-17T14:23:20.918Z |
5500239 | 5500239 | 20241108150700_b6BMP | NZ000Z | 2024-11-09T14:06:00.530Z | 2024-11-17T14:23:20.273Z |
5500225 | 5500225 | 20241108150600_ROyn7 | NZ000Z | 2024-11-09T14:05:59.655Z | 2024-11-17T14:23:20.231Z |
5500208 | 5500208 | 20241108150437_33TlA | NZ000Z | 2024-11-09T14:05:58.983Z | 2024-11-17T14:23:20.140Z |
5500173 | 5500173 | 20241108150125_Aqhm8 | NZ000Z | 2024-11-09T14:05:56.945Z | 2024-11-17T14:23:19.988Z |
5500059 | 5500059 | 20241108143552_aUqOr | NZ000Z | 2024-11-09T14:05:38.093Z | 2024-11-17T14:23:18.444Z |
5499885 | 5499885 | 20241108135406_jZuok | NZ000Z | 2024-11-09T14:05:08.427Z | 2024-11-17T14:23:16.703Z |
5499849 | 5499849 | 20241108134712_19Apg | NZ000Z | 2024-11-09T14:05:03.647Z | 2024-11-17T14:23:16.445Z |
5499829 | 5499829 | 20241108134318_tmlUP | NZ000Z | 2024-11-09T14:05:02.537Z | 2024-11-17T14:23:16.314Z |
5499789 | 5499789 | 20241108132853_IKPCb | NZ000Z | 2024-11-09T14:04:58.200Z | 2024-11-17T14:23:16.145Z |
5499703 | 5499703 | 20241108130456_XhvTR | NZ000Z | 2024-11-09T14:04:47.347Z | 2024-11-17T14:23:14.650Z |
5499408 | 5499408 | 20241108121429_2lyOf | NZ000Z | 2024-11-09T14:04:03.141Z | 2024-11-17T14:23:11.171Z |
5498928 | 5498928 | 20241108102848_h1Se3 | NZ000Z | 2024-11-09T14:02:48.090Z | 2024-11-17T14:23:02.193Z |
5498921 | 5498921 | 20241108102619_4PAVF | NZ000Z | 2024-11-09T14:02:47.150Z | 2024-11-17T14:23:01.677Z |
5498871 | 5498871 | 20241108101737_RI1Va | NZ000Z | 2024-11-09T14:02:40.472Z | 2024-11-17T14:23:00.892Z |
5498728 | 5498728 | 20241108094348_9jjW5 | NZ000Z | 2024-11-09T14:02:16.987Z | 2024-11-17T14:22:59.381Z |
5498462 | 5498462 | 20241108083719_Ss983 | NZ000Z | 2024-11-09T14:01:33.015Z | 2024-11-17T14:22:55.604Z |
5498418 | 5498418 | 20241108082916_Yg6he | NZ000Z | 2024-11-09T14:01:27.595Z | 2024-11-17T14:22:54.580Z |
5498396 | 5498396 | 20241108082537_9v8rF | NZ000Z | 2024-11-09T14:01:23.852Z | 2024-11-17T14:22:54.057Z |
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);