names

90 rows where place_id = 585999

✎ 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
3587668 1863787 1863787 defendant Bradley William laborer 585999 585999 Bradley, William, of Kyrkeby, laborer 0
3624029 1875049 1875049 defendant Bradley William carpenter 585999 585999 Bradley, William, of Kyrkeby, carpenter 1
3680715 1920050 1920050 defendant Whelpesdale Thomas smith 585999 585999 Whelpesdale, Thomas, of Kyrkeby, smith 0
3680721 1920051 1920051 defendant Whelpesdale Thomas smith 585999 585999 Whelpesdale, Thomas, of Kyrkeby, smith 0
3690902 1923318 1923318 defendant Sneth Lewis yeoman 585999 585999 Sneth, Lewis, of Kyrkeby, yeoman 1
3913011 1994682 1994682 defendant Collyng Thomas (legal representative) 585999 585999 Collyng, Thomas, of Kyrkeby, executrix of 1
3928228 1999777 1999777 defendant Crampe John laborer 585999 585999 Crampe, John, of Kyrkeby, laborer 0
4007424 2027436 2027436 defendant Sadler John husbandman 585999 585999 Sadler, John, of Kyrkeby, husbandman 3
4024923 2033582 2033582 defendant Abbott Henry yeoman 585999 585999 Abbott, Henry, of Kyrkeby, yeoman 5
4111900 2064504 2064504 defendant Trygott Tristram gent 585999 585999 Trygott, Tristram, of Kyrkeby, gent 2
4123846 2068826 2068826 defendant Chatterton William husbandman 585999 585999 Chatterton William, of Kyrkeby, husbandman 1
4141982 2075366 2075366 defendant Pennell Richard yeoman 585999 585999 Pennell, Richard, of Kyrkeby, yeoman 2
4455691 2186792 2186792 defendant Taillour Adam   585999 585999 Taillour, Adam, of Kyrkeby 0
4467759 2190593 2190593 defendant Sleford Thomas de   585999 585999 Sleford, Thomas de, of Kyrkeby 1
4477738 2193703 2193703 defendant Bynglay John   585999 585999 Bynglay, John, of Kyrkeby 0
4533003 2210592 2210592 defendant Dawe Richard   585999 585999 Dawe, Richard, of Kyrkeby 1
4593278 2229193 2229193 defendant Cook John   585999 585999 Cook, John, of Kyrkeby 0
4593279 2229193 2229193 defendant Lete Richard   585999 585999 Lete, Richard, of Kyrkeby 1
4593280 2229193 2229193 defendant Hoggeson Thomas   585999 585999 Hoggeson, Thomas, of Kyrkeby 2
4593281 2229193 2229193 defendant Wyse John   585999 585999 Wyse, John, of Kyrkeby 3
4593304 2229194 2229194 defendant Everard William   585999 585999 Everard, William, of Kyrkeby 10
4593305 2229194 2229194 defendant Dyms William   585999 585999 Dyms, William, of Kyrkeby 11
4593306 2229194 2229194 defendant Dany John   585999 585999 Dany, John, of Kyrkeby 12
4593307 2229194 2229194 defendant Warde Ralph   585999 585999 Warde, Ralph, of Kyrkeby 13
4593308 2229194 2229194 defendant Andrewe John   585999 585999 Andrewe, John, of Kyrkeby 14
4614268 2235475 2235475 plaintiff Draycotes Alice   585999 585999 Draycotes, Alice, of Kyrkeby 0
4616119 2236048 2236048 defendant Bernard John   585999 585999 Bernard, John, of Kyrkeby 1
4624081 2238508 2238508 defendant Samon John   585999 585999 Samon, John, of Kyrkeby 4
4641909 2243741 2243741 defendant Wryght William   585999 585999 Wryght, William, of Kyrkeby 1
4645260 2244684 2244684 defendant Samon John   585999 585999 Samon, John, of Kyrkeby 4
4707467 2267711 2267711 defendant Fayte Thomas yeoman 585999 585999 Fayte, Thomas, of Kyrkeby, yeoman 4
4710653 2268688 2268688 defendant Hebden Robert yeoman 585999 585999 Hebden, Robert, of Kyrkeby under Knoll, yeoman 0
4764126 2284769 2284769 defendant Shepherd Robert laborer 585999 585999 Shepherd, Robert, of Kyrkeby, laborer 0
4804690 2297665 2297665 defendant Campe Robert husbandman 585999 585999 Campe, Robert, of Kyrkeby, husbandman 0
4804691 2297665 2297665 defendant Herward Thomas butcher 585999 585999 Herward, Thomas, of Kyrkeby, butcher 1
4804692 2297665 2297665 defendant Werkewode John weaver 585999 585999 Werkewode, John, of Kyrkeby, weaver 2
4817657 2301610 2301610 defendant Bek Robert husbandman 585999 585999 Bek, Robert, of Kyrkeby, husbandman 2
4826517 2304328 2304328 defendant Hill John yeoman 585999 585999 Hill, John, of Kyrkeby, yeoman 11
4856677 2313464 2313464 plaintiff Ondeby or Oudeby John esq 585999 585999 Ondeby or Oudeby, John, of Kyrkeby, esq 1
4866767 2316568 2316568 plaintiff Elryngton William   585999 585999 Elryngton, William, of Kyrkeby 1
4903100 2327584 2327584 plaintiff Charter Robert   585999 585999 Charter, Robert, of Kyrkeby 0
4914472 2331046 2331046 defendant Lydyate Thomas husbandman 585999 585999 Lydyate, Thomas, of Kyrkeby, husbandman 0
4924948 2334231 2334231 defendant Pylgryme Thomas yeoman 585999 585999 Pylgryme, Thomas, of Kyrkeby, yeoman 0
4971267 2348343 2348343 defendant Grene William husbandman 585999 585999 Grene, William, of Kyrkeby, husbandman 2
5018076 2362170 2362170 defendant Benet Richard husbandman 585999 585999 Benet, Richard, of Kyrkeby, husbandman 2
5023225 2363694 2363694 defendant Benet Richard husbandman 585999 585999 Benet, Richard, of Kyrkeby, husbandman 0
5064172 2375825 2375825 plaintiff Kyrkby William   585999 585999 Kyrkby, William, of Kyrkeby 0
5100166 2386489 2386489 defendant Herward William butcher 585999 585999 Herward, William, of Kyrkeby, butcher 5
5103569 2387470 2387470 defendant Hert John yeoman 585999 585999 Hert, John, of Kyrkeby, or of Pakefeld, Suff, yeoman: Craske, Henry, Kyrkeby, yeoman 1
5109134 2389094 2389094 defendant Pynchebek Robert husbandman 585999 585999 Pynchebek, Robert, of Kyrkeby, husbandman 3
5109135 2389094 2389094 defendant Gose John husbandman 585999 585999 Gose, John, of Kyrkeby, husbandman 4
5111352 2389712 2389712 defendant Flynthill William husbandman 585999 585999 Flynthill, William, of Kyrkeby, husbandman 0
5122782 2393097 2393097 defendant Sturgeon William yeoman 585999 585999 Sturgeon, William, of Kyrkeby, yeoman 0
5216596 2420583 2420583 defendant Wharton John gent 585999 585999 Wharton, John, of Kyrkeby Thure, Cumber, gent 2
5216600 2420584 2420584 defendant Wharton John gent 585999 585999 Wharton, John, of Kyrkeby Thure, Cumber, gent 2
5216604 2420585 2420585 defendant Wharton John gent 585999 585999 Wharton, John, of Kyrkeby Thurne, Comber, gent 2
5237049 2426417 2426417 defendant Heselden Henry yeoman 585999 585999 Heselden, Henry, of Kyrkeby, yeoman 2
5247844 2429510 2429510 defendant Farleton Robert yeoman 585999 585999 Farleton, Robert, of Kyrkeby, yeoman 2
5259375 2433054 2433054 defendant Warde Robert gent 585999 585999 Warde, Robert, of Kyrkeby, gent 1
5280240 2439297 2439297 plaintiff Busshe John smith 585999 585999 Busshe, John, of Kyrkeby, or of Norwich, smith 0
5291097 2442399 2442399 defendant Walker Ricard husbandman 585999 585999 Walker, Ricard, of Kyrkeby, husbandman 2
5292302 2442749 2442749 defendant Lakenby Thomas fisher 585999 585999 Lakenby, Thomas, of Kyrkeby, fisher 2
5296502 2443968 2443968 plaintiff Wilson John (legal representative) 585999 585999 Wilson, John, of Kyrkeby, slater, executors of 0
5296504 2443968 2443968 defendant Rolston Thomas slater 585999 585999 Rolston, Thomas, of Kyrkeby, slater 0
5333131 2454979 2454979 defendant (not given) John rector of Peghan 585999 585999 Peghan, John, of Kyrkeby Overker, clerk, rector of Kyrkeby Misperton 0
5397160 2474272 2474272 defendant Scoche Walter   585999 585999 Scoche, Walter, of Kyrkeby 0
5408162 2477415 2477415 defendant Jermyn John husbandman 585999 585999 Jermyn, John, of Kyrkeby, husbandman 0
5408166 2477416 2477416 defendant Rotherford James yeoman 585999 585999 Rotherford, James, of Kyrkeby, yeoman 0
5410344 2478047 2478047 defendant Scoche Walter husbandman 585999 585999 Scoche, Walter, of Kyrkeby, husbandman 0
5421341 2481315 2481315 defendant Jacob   yeoman 585999 585999 _, Jacob, of Kyrkeby, yeoman 0
5421345 2481316 2481316 defendant Jermyn John husbandman 585999 585999 Jermyn, John, of Kyrkeby, husbandman 0
5428481 2483444 2483444 defendant Shawe James tailor 585999 585999 Shawe, James, of Kyrkeby, tailor 0
5440649 2487111 2487111 defendant Jermyn John husbandman 585999 585999 Jermyn, John, of Kyrkeby, husbandman 0
5440654 2487112 2487112 defendant Rotherford James yeoman 585999 585999 Rotherford, James, of Kyrkeby, yeoman 0
5440659 2487113 2487113 defendant Jermyn John husbandman 585999 585999 Jermyn, John, of Kyrkeby, husbandman 0
5440664 2487114 2487114 defendant Rotherford James yeoman 585999 585999 Rotherford, James, of Kyrkeby, yeoman 0
5474756 2497432 2497432 defendant Gyrne Richard gent 585999 585999 Gyrne, Richard, of Kyrkeby, gent 0
5474757 2497432 2497432 defendant Smarte Richcard yeoman 585999 585999 Smarte, Richcard, of Kyrkeby, yeoman 1
5485734 2500630 2500630 defendant Herward John brewer 585999 585999 Herward, John, of Kyrkeby, brewer 1
5485735 2500630 2500630 defendant Mylsent John tailor 585999 585999 Mylsent, John, of Kyrkeby, tailor 2
5485736 2500630 2500630 defendant Jermayn John husbandman 585999 585999 Jermayn, John, of Kyrkeby, husbandman 3
5523660 2512226 2512226 plaintiff Gavell Thomas gent 585999 585999 Gavell, Thomas, of Kyrkeby, gent 0
5523662 2512227 2512227 plaintiff Gavell Thomas gent 585999 585999 Gavell, Thomas, of Kyrkeby, gent 0
5534326 2515273 2515273 defendant Eyre Lawrence yeoman 585999 585999 Eyre, Lawrence, of Kyrkeby, yeoman 3
5550014 2520042 2520042 plaintiff Brygys Roland (legal representative) 585999 585999 Brygys, Roland, of Kyrkeby, Kendale, clothman, executors of 0
5562887 2523737 2523737 defendant Crane Geoffrey husbandman 585999 585999 Crane, Geoffrey, of Kyrkeby, husbandman 0
5563224 2523842 2523842 defendant Palmer John husbandman 585999 585999 Palmer, John, of Kyrkeby, husbandman 0
5578205 2528254 2528254 defendant Barre Robert husbandman 585999 585999 Barre, Robert, of Kyrkeby, husbandman 0
5605833 2536716 2536716 defendant Bogas William yeoman 585999 585999 (Bogas, William, of Kyrkeby, yeoman 1
5605834 2536716 2536716 defendant Bogas Anne widow 585999 585999 Bogas, Anne, of Kyrkeby, widow 2

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);