names

101 rows where place_id = 587668

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592091 1865141 1865141 defendant Wodward Richard gent 587668 587668 Wodward, Richard, of Kenyngton, gent 0
3612855 1871670 1871670 defendant Webbe Richard yeoman 587668 587668 Webbe, Richard, of Kenyngton, yeoman 0
3615057 1872354 1872354 defendant Smyth Robert butcher 587668 587668 Smyth, Robert, of Kenyngton, butcher 0
3624562 1875218 1875218 defendant Kempe John husbandman 587668 587668 Kempe, John, of Kenyngton, husbandman 1
3626065 1903011 1903011 defendant Ambros Thomas husbandman 587668 587668 Ambros, Thomas, of Kenyngton, husbandman 0
3632760 1905060 1905060 defendant Wode Robert husbandman 587668 587668 Wode, Robert, of Kenyngton, husbandman 0
3633302 1905231 1905231 defendant Ricard Richard yeoman 587668 587668 Ricard, Richard, of Kenyngton, yeoman 2
3633303 1905231 1905231 defendant Coke Simon husbandman 587668 587668 Coke, Simon, of Kenyngton, husbandman 3
3684780 1921377 1921377 defendant Cooke John cooper 587668 587668 Cooke, John, of Kenyngton, cooper 0
3684781 1921377 1921377 defendant Cooke Christopher cooper 587668 587668 Cooke, Christopher, of Kenyngton, cooper 1
3751586 1942409 1942409 defendant Gore Ralph yeoman 587668 587668 Gore, Ralph, of Kenyngton, yeoman 0
3766576 1947208 1947208 defendant at Water Robert husbandman 587668 587668 at Water, Robert, of Kenyngton, husbandman 0
3855677 1975413 1975413 defendant Shotford William husbandman 587668 587668 Shotford, William, of Kenyngton, husbandman 1
3855679 1975413 1975413 defendant Padnell Thomas husbandman 587668 587668 Padnell, Thomas, of Kenyngton, husbandman 3
3922929 1997973 1997973 defendant Scrop alias Gybson John, junior yeoman 587668 587668 Scrop alias Gybson, John, junior, of Kenyngton, yeoman 0
3924896 1998645 1998645 defendant Scrope alias Gybson John yeoman 587668 587668 Scrope alias Gybson, John, of Kenyngton, yeoman 0
4003768 2026115 2026115 defendant Denys Richard tiler 587668 587668 Denys, Richard, of Kenyngton, tiler 0
4016865 2030730 2030730 defendant Langholm Henry esq 587668 587668 Langholm, Henry, of Kenyngton, or of Conysholm, esq 0
4045498 2040843 2040843 defendant Smythe John yeoman 587668 587668 Smythe, John, of Kenyngton, yeoman 4
4092322 2057554 2057554 defendant Fayerbankes Edmund yeoman 587668 587668 Fayerbankes, Edmund, of Kenyngton, yeoman 0
4094970 2058529 2058529 defendant Braye Richard chapman 587668 587668 Braye, Richard, of Kenyngton, chapman 0
4136030 2073225 2073225 defendant Selye George husbandman 587668 587668 Selye, George, of Kenyngton, husbandman 0
4468051 2190677 2190677 defendant Padbury Thomas   587668 587668 Padbury, Thomas, of Kenyngton 0
4475504 2193017 2193017 defendant Paddebury Richard   587668 587668 Paddebury, Richard, of Kenyngton 0
4481700 2194977 2194977 plaintiff Mair John   587668 587668 Mair, John, of Kenyngton 0
4490537 2197734 2197734 defendant Padbury Thomas   587668 587668 Padbury, Thomas, of Kenyngton 0
4490538 2197734 2197734 defendant Padbury Richard   587668 587668 Padbury, Richard, of Kenyngton, son of Thomas 1
4564374 2220425 2220425 plaintiff Sandre Thomas   587668 587668 Sandre, Thomas, of Kenyngton 0
4571768 2222755 2222755 plaintiff Appilforde Thomas   587668 587668 Appilforde, Thomas, of Kenyngton 0
4692553 2263186 2263186 defendant Padbury Thomas husbandman 587668 587668 Padbury, Thomas, of Kenyngton, husbandman 0
4692555 2263187 2263187 defendant Padbury Thomas husbandman 587668 587668 Padbury, Thomas, of Kenyngton, husbandman 0
4744467 2278903 2278903 plaintiff Elys Thomas   587668 587668 Elys, Thomas, of Kenyngton 0
4760389 2283603 2283603 defendant Shirwod William yeoman 587668 587668 Shirwod, William, of Kenyngton, yeoman 2
4785178 2291380 2291380 plaintiff Elys Thomas   587668 587668 Elys, Thomas, of Kenyngton 0
4787695 2292221 2292221 defendant Cowherd William laborer 587668 587668 Cowherd, William, of Kenyngton, laborer 2
4855757 2313175 2313175 defendant Coweherd William husbandman 587668 587668 Coweherd, William, of Kenyngton, husbandman 4
4863720 2315624 2315624 plaintiff Elys Thomas (legal representative) 587668 587668 Elys, Thomas, of Kenyngton, executors of 0
4871538 2318067 2318067 defendant Gotele Richard laborer 587668 587668 Gotele, Richard, of Kenyngton, laborer 4
4884250 2321982 2321982 defendant Elys Thomas (legal representative) 587668 587668 Elys, Thomas, of Kenyngton, executors of 0
4884253 2321982 2321982 defendant Wylde Robert gent 587668 587668 Wylde, Robert, of Kenyngton, gent 3
4923437 2333758 2333758 plaintiff May John   587668 587668 May, John, of Kenyngton 0
4923444 2333760 2333760 defendant Dod William yeoman 587668 587668 Dod, William, of Kenyngton, yeoman 0
4925502 2334409 2334409 defendant Wilde Robert gent 587668 587668 Wilde, Robert, of Kenyngton, gent 0
4928890 2335456 2335456 defendant Wylde Robert gent 587668 587668 Wylde, Robert, of Kenyngton, gent 0
4933042 2336724 2336724 plaintiff Wylde Robert   587668 587668 Wylde, Robert, of Kenyngton 0
4933043 2336724 2336724 defendant Wylde Robert   587668 587668 Wylde, Robert, of Kenyngton 0
4948697 2341575 2341575 defendant Raynold Simon butcher 587668 587668 Raynold, Simon, of Kenyngton, butcher 0
4948698 2341575 2341575 defendant Raynold William butcher 587668 587668 Raynold, William, of Kenyngton, butcher 1
4948699 2341575 2341575 defendant Raynold Stephen laborer 587668 587668 Raynold, Stephen, of Kenyngton, laborer 2
4948888 2341637 2341637 defendant Padbury Thomas husbandman 587668 587668 Padbury, Thomas, of Kenyngton, husbandman 0
5048668 2371238 2371238 defendant atte Bergh John husbandman 587668 587668 atte Bergh, John, of Kenyngton, yeoman, son & heir of William atte Bergh, of Kenynton, husbandman 0
5051920 2372188 2372188 plaintiff Wylde Robert esq 587668 587668 Wylde, Robert, of Kenyngton, esq 0
5052488 2372338 2372338 defendant Lee Robert yeoman 587668 587668 Lee, Robert, of Kenyngton, yeoman 2
5056422 2373495 2373495 defendant Harry Thomas husbandman 587668 587668 Harry, Thomas, of Kenyngton, husbandman 0
5057733 2373882 2373882 defendant Hely John laborer 587668 587668 Hely, John, of Kenyngton, laborer 0
5057964 2373956 2373956 defendant Banastre Henry gent 587668 587668 Banastre, Henry, of Kenyngton, gent 2
5064617 2375957 2375957 defendant Herry William husbandman 587668 587668 Herry, William, of Kenyngton, husbandman 1
5068167 2376981 2376981 defendant Harry Thomas husbandman 587668 587668 Harry, Thomas, of Kenyngton, husbandman 0
5075329 2379121 2379121 defendant Harry Thomas husbandman 587668 587668 Harry, Thomas, of Kenyngton, husbandman 1
5083047 2381438 2381438 plaintiff Elys Richard gent 587668 587668 Elys, Richard, of Kenyngton, gent 0
5084642 2381921 2381921 defendant Amys Hamon yeoman 587668 587668 Amys, Hamon, of Kenyngton, yeoman 0
5100112 2386472 2386472 plaintiff Wyke Robert esq 587668 587668 Wyke, Robert, of Kenyngton, esq 0
5100133 2386478 2386478 defendant Harry Thomas husbandman 587668 587668 Harry, Thomas, of Kenyngton, husbandman 1
5127597 2394557 2394557 defendant Pette Godfrey husbandman 587668 587668 Pette, Godfrey, of Kenyngton, husbandman 0
5141791 2398714 2398714 defendant Geffrey William laboer 587668 587668 Geffrey, William, of Kenyngton, laboer 0
5181637 2410371 2410371 defendant Pette Godfrey husbandman 587668 587668 Pette, Godfrey, of Kenyngton, husbandman 0
5188257 2412277 2412277 defendant Couherd John husbandman 587668 587668 Couherd, John, of Kenyngton, husbandman 1
5198550 2415332 2415332 defendant Boure Thomas husbandman 587668 587668 Boure, Thomas, of Kenyngton, husbandman 0
5210602 2418840 2418840 defendant Boure Thomas husbandman 587668 587668 Boure, Thomas, of Kenyngton, husbandman 0
5226991 2423547 2423547 defendant atte Pette Joan widow 587668 587668 atte Pette, Joan, of Kenyngton, widow 3
5226993 2423547 2423547 defendant Colt William   587668 587668 Colt, William, of Kenyngton, servant 5
5239741 2427210 2427210 defendant Couherd Simon husbandman 587668 587668 Couherd, Simon, of Kenyngton, husbandman 2
5257138 2432366 2432366 defendant Padbery John husbandman 587668 587668 Padbery, John, of Kenyngton, husbandman 0
5261445 2433690 2433690 defendant Rycard Richard tanner 587668 587668 Rycard, Richard, of Kenyngton, tanner 0
5295281 2443615 2443615 defendant Ewen Thomas yeoman 587668 587668 Ewen, Thomas, of Kenyngton, yeoman 0
5310592 2448204 2448204 defendant Heren John laborer 587668 587668 Heren, John, of Kenyngton, laborer 0
5314818 2449477 2449477 defendant Bakke Thomas husbandman 587668 587668 Bakke, Thomas, of Kenyngton, husbandman 0
5314819 2449477 2449477 defendant Bakke John laborer 587668 587668 Bakke, John, of Kenyngton, laborer 1
5346684 2459117 2459117 defendant Kempe Thomas husbandman 587668 587668 Kempe, Thomas, of Kenyngton, husbandman 0
5359866 2463126 2463126 defendant Kempe Thomas husbandman 587668 587668 Kempe, Thomas, of Kenyngton, husbandman 0
5361890 2463743 2463743 defendant Philpotte Thomas smith 587668 587668 Philpotte, Thomas, of Kenyngton, smith 0
5401394 2475464 2475464 defendant Spencer William yeoman 587668 587668 Spencer, William, of Kenyngton, yeoman 0
5401395 2475464 2475464 defendant Wodeward Richard yeoman 587668 587668 Wodeward, Richard, of Kenyngton, yeoman 1
5421584 2481392 2481392 defendant Kempe Thomas husbandman 587668 587668 Kempe, Thomas, of Kenyngton, husbandman 1
5425380 2482566 2482566 defendant Coke John husbandman 587668 587668 Coke, John, of Kenyngton, husbandman 1
5443899 2488094 2488094 defendant Coke John husbandman 587668 587668 Coke, John, of Kenyngton, husbandman 1
5466137 2494813 2494813 defendant Kempe Thomas husbandman 587668 587668 Kempe, Thomas, of Kenyngton, husbandman 1
5466777 2495012 2495012 defendant Kempe Thomas husbandman 587668 587668 Kempe, Thomas, of Kenyngton, husbandman 1
5466782 2495014 2495014 defendant Kempe Thomas husbandman 587668 587668 Kempe, Thomas, of Kenyngton, husbandman 1
5493343 2502924 2502924 defendant Kempe Thomas yeoman 587668 587668 Kempe, Thomas, of Kenyngton, yeoman 0
5493344 2502924 2502924 defendant Kempe John husbandman 587668 587668 Kempe, John, of Kenyngton, husbandman 1
5498738 2504567 2504567 defendant Kempe Richard husbandman 587668 587668 Kempe, Richard, of Kenyngton, husbandman 0
5534113 2515207 2515207 defendant Ambrose Thomas tanner 587668 587668 Ambrose, Thomas, of Kenyngton, tanner 0
5538799 2516621 2516621 defendant Tylden John yeoman 587668 587668 Tylden, John, of Kenyngton, yeoman 0
5548643 2519645 2519645 defendant Whyte Thomas laborer 587668 587668 Whyte, Thomas, of Kenyngton, laborer 0
5549022 2519751 2519751 defendant Tulle John yeoman 587668 587668 Tulle, John, of Kenyngton, yeoman 0
5563419 2523901 2523901 plaintiff Attewell William husbandman 587668 587668 Attewell, William, of Kenyngton, husbandman 0
5563420 2523901 2523901 defendant Coke Thomas tanner 587668 587668 Coke, Thomas, of Kenyngton, tanner 0
5577440 2528002 2528002 defendant Couper John yeoman 587668 587668 Couper, John, of Kenyngton, yeoman 2
5580840 2529084 2529084 defendant Couper John yeoman 587668 587668 Couper, John, of Kenyngton, yeoman 3

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);