names

48 rows where place_id = 589027

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596309 1866475 1866475 defendant Sharp John smith 589027 589027 Sharp, John, of Reygate, Surrey, smith 0
3816473 1963059 1963059 defendant Compton Thomas gent 589027 589027 Compton, Thomas, of Reygate, Surrey, gent 0
3907634 1992842 1992842 defendant Heyborne Richard gent 589027 589027 Heyborne, Richard, of Reygate, Surrey, gent 1
3951235 2007501 2007501 defendant Skynner Margaret widow 589027 589027 Skynner, Margaret, of Reygate, Surrey, widow 1
4153093 2079181 2079181 defendant Tingleton Charles gent 589027 589027 Tingleton, Charles, of Reygate, Surrey, gent 0
4174141 2086409 2086409 defendant Awood John innholder 589027 589027 (Awood, John, of Reygate, Surrey, innholder 1
4181037 2088842 2088842 defendant Pledge Nicholas joiner 589027 589027 Pledge, Nicholas, of Reygate, Surrey, joiner 1
4461208 2188587 2188587 defendant atte Forde William   589027 589027 atte Forde, William, of Reygate, Surrey 0
4781303 2290166 2290166 plaintiff Chaunce Roger   589027 589027 Chaunce, Roger, of Reygate, Surrey 0
4843062 2309362 2309362 defendant Chaunce Roger husbandman 589027 589027 (Chaunce, Roger, of Reygate, Surrey, husbandman 1
4870916 2317879 2317879 defendant Chaunce Roger husbandman 589027 589027 (Chaunce, Roger, of Reygate, Surrey, husbandman 1
4890708 2323847 2323847 plaintiff Bryt William   589027 589027 Bryt, William, of Reygate, Surrey 0
4900256 2326712 2326712 plaintiff Bryt William   589027 589027 Bryt, William, of Reygate, Surrey 0
4947202 2341114 2341114 defendant Luggesford Alan husbandman 589027 589027 Luggesford, Alan, of Reygate, Surrey, husbandman 3
5087100 2382607 2382607 defendant Nassh Simon carpenter 589027 589027 Nassh, Simon, of Reygate, Surrey, carpenter 0
5091605 2383934 2383934 defendant Yorman John esq 589027 589027 Yorman, John, of Reygate, Surrey, esq 4
5091611 2383935 2383935 defendant Yerman John esq 589027 589027 Yerman, John, of Reygate, Surrey, esq 4
5144364 2399509 2399509 defendant Skynner John gent 589027 589027 Skynner, John, of Reygate, Surrey, gent 0
5156496 2403056 2403056 defendant Courthope Roger yeoman 589027 589027 Courthope, Roger, of Reygate, Surrey, yeoman 1
5162114 2404652 2404652 defendant Heysaunt Patrick husbandman 589027 589027 Heysaunt, Patrick, of Reygate, Surrey, husbandman 4
5172703 2407745 2407745 defendant Courthope Robert yeoman 589027 589027 Courthope, Robert, of Reygate, Surrey, yeoman 1
5179098 2409620 2409620 defendant Skynner John gent 589027 589027 Skynner, John, of Reygate, Surrey, gent 0
5179100 2409621 2409621 defendant Skynner John gent 589027 589027 Skynner, John, of Reygate, Surrey, gent 0
5192396 2413512 2413512 defendant Courthope Roger yeoman 589027 589027 Courthope, Roger, of Reygate, Surrey, yeoman 1
5201745 2416277 2416277 defendant Skynner John gent 589027 589027 Skynner, John, of Reygate, Surrey, gent 0
5207739 2418002 2418002 defendant Courthope Roger yeoman 589027 589027 Courthope, Roger, of Reygate, Surrey, yeoman 1
5279528 2439089 2439089 defendant Skynner John gent 589027 589027 Skynner, John, of Reygate, Surrey, gent 4
5279922 2439203 2439203 defendant Skynner John gent 589027 589027 Skynner, John, of Reygate, Surrey, gent 4
5294782 2443457 2443457 defendant Bert John yeoman 589027 589027 Bert, John, of Reygate, Surrey, yeoman 1
5299197 2444744 2444744 defendant Merywedre William husbandman 589027 589027 Merywedre, William, of Reygate, Surrey, husbandman 0
5299441 2444812 2444812 defendant Merywedre William husbandman 589027 589027 Merywedre, William, of Reygate, Surrey, husbandman 0
5303204 2445951 2445951 defendant Mylys Robert husbandman 589027 589027 Mylys, Robert, of Reygate, Surrey, husbandman 1
5303206 2445952 2445952 defendant Mylys Robert husbandman 589027 589027 Mylys, Robert, of Reygate, Surrey, husbandman 0
5318187 2450535 2450535 defendant Chambyrleyn Nicholas gent 589027 589027 Chambyrleyn, Nicholas, of Reygate, Surrey, gent 0
5318383 2450593 2450593 defendant Mylys Robert husbandman 589027 589027 Mylys, Robert, of Reygate, Surrey, husbandman 0
5335482 2455681 2455681 defendant Mylys Robert husbandman 589027 589027 Mylys, Robert, of Reygate, Surrey, husbandman 1
5335485 2455682 2455682 defendant Mylys Robert husbandman 589027 589027 Mylys, Robert, of Reygate, Surrey, husbandman 1
5335488 2455683 2455683 defendant Mylys Robert husbandman 589027 589027 Mylys, Robert, of Reygate, Surrey, husbandman 1
5337855 2456404 2456404 defendant Skynner John, senior (legal representative) 589027 589027 Skynner, John, senior, of Reygate, Surrey, gent,executor of 0
5337858 2456405 2456405 defendant Skynner John, senior (legal representative) 589027 589027 Skynner, John, senior, of Reygate, Surrey, gent, executor of 0
5340640 2457275 2457275 defendant Chamberleyn Nicholas husbandman 589027 589027 Chamberleyn, Nicholas, of Reygate, Surrey, husbandman 0
5477608 2498320 2498320 defendant Alman Gilbert husbandman 589027 589027 Alman, Gilbert, of Reygate, Surrey, husbandman 0
5477611 2498321 2498321 defendant Alman Gilbert husbandman 589027 589027 Alman, Gilbert, of Reygate, Surrey, husbandman 0
5493564 2502988 2502988 defendant Byrt Ralph yeoman 589027 589027 Byrt, Ralph, of Reygate, Surrey, yeoman 0
5527258 2513102 2513102 defendant Goodsolf John yeoman 589027 589027 Goodsolf, John, of Reygate, Surrey, yeoman 2
5580549 2529001 2529001 defendant Pope John, junior yeoman 589027 589027 Pope, John, junior, of Reygate, Surrey, yeoman 1
5595816 2533604 2533604 defendant Fulborne Thomas gent 589027 589027 Fulborne, Thomas, of Reygate, Surrey, gent 3
5601722 2535441 2535441 defendant Broun Richard smith 589027 589027 Broun, Richard, of Reygate,, Surrey, smith 1

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