names

58 rows where place_id = 586997

✎ 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
3590186 1864570 1864570 defendant Say Richard yeoman 586997 586997 Say, Richard, of Thornerton, yeoman 0
3972327 2014890 2014890 plaintiff Fursdon Wilmote widow 586997 586997 Fursdon, Wilmote, of Thornerton,widow 0
4543634 2213905 2213905 defendant Grede Margaret   586997 586997 Grede, Margaret, of Thornerton 0
4543635 2213905 2213905 defendant Grede Thomas   586997 586997 Grede, Thomas, of Thornerton 1
4543636 2213905 2213905 defendant Sherpe Thomas   586997 586997 Sherpe, Thomas, of Thornerton 2
4543637 2213905 2213905 defendant Snoke Robert   586997 586997 Snoke, Robert, of Thornerton 3
4543638 2213905 2213905 defendant Smyth Thomas   586997 586997 Smyth, Thomas, of Thornerton 4
4791317 2293379 2293379 defendant Fyssh John husbandman 586997 586997 Fyssh, John, of Thornerton, husbandman 2
4810186 2299330 2299330 defendant Wade John husbandman 586997 586997 Wade, John, of Thornerton, husbandman 1
4855585 2313112 2313112 defendant Fysshe William carpenter 586997 586997 Fysshe, William, of Thornerton, carpenter 1
4955986 2343757 2343757 defendant Tounysyende Thomas husbandman 586997 586997 Tounysyende, Thomas, of Thornerton, husbandman 2
4997617 2356141 2356141 defendant Dubber alias Mille Stephen gent 586997 586997 Dubber alias Mille, Stephen, of Thornerton, gent 0
5001735 2357401 2357401 defendant Mershay Stephen smith 586997 586997 Mershay, Stephen, of Thornerton, smith 3
5015056 2361286 2361286 defendant Stephyn John   586997 586997 Stephyn, John, of Thornerton, mason 0
5021520 2363195 2363195 defendant Wade John   586997 586997 Wade, John, of Thornerton, bailiff 3
5061012 2374868 2374868 defendant atte Busshe William husbandman 586997 586997 atte Busshe, William, of Thornerton, husbandman 2
5069500 2377375 2377375 defendant Moreman John husbandman 586997 586997 Moreman, John, of Thornerton, husbandman 6
5126231 2394155 2394155 defendant Moreman John laborer 586997 586997 Moreman, John, of Thornerton, laborer 4
5128949 2394952 2394952 defendant Tounesend John husbandman 586997 586997 Tounesend, John, of Thornerton, husbandman 2
5128951 2394952 2394952 defendant Drake John, junior husbandman 586997 586997 Drake, John, junior, of Thornerton, husbandman 4
5128952 2394952 2394952 defendant Drake John, senior husbandman 586997 586997 Drake, John, senior, of Thornerton, husbandman 5
5144879 2399651 2399651 defendant Moreman John laborer 586997 586997 Moreman, John, of Thornerton, laborer 4
5144880 2399651 2399651 defendant Whiterowe Richard laborer 586997 586997 Whiterowe, Richard, of Thornerton, laborer 5
5144885 2399652 2399652 defendant Moreman John laborer 586997 586997 Moreman, John, of Thornerton, laborer 2
5144886 2399652 2399652 defendant Whiterowe Richard laborer 586997 586997 Whiterowe, Richard, of Thornerton, laborer 3
5148147 2400604 2400604 defendant Tounesend John husbandman 586997 586997 Tounesend, John, of Thornerton, husbandman 2
5148148 2400604 2400604 defendant Brounston Thomas husbandman 586997 586997 Brounston, Thomas, of Thornerton, husbandman 3
5148150 2400604 2400604 defendant Brounston John husbandman 586997 586997 Brounston, John, of Thornerton, husbandman 5
5148151 2400604 2400604 defendant Draker John, sen husbandman 586997 586997 Draker, John, sen, of Thornerton, husbandman 6
5149905 2401105 2401105 defendant Ayer William miller 586997 586997 Ayer, William, of Thornerton, miller 0
5149906 2401105 2401105 defendant Chilton William carpenter 586997 586997 Chilton, William, of Thornerton, carpenter 1
5149907 2401105 2401105 defendant Hobbe Philip husbandman 586997 586997 Hobbe, Philip, of Thornerton, husbandman 2
5168660 2406556 2406556 defendant Ayer William miller 586997 586997 Ayer, William, of Thornerton, miller 0
5168661 2406556 2406556 defendant Chilton William carpenter 586997 586997 Chilton, William, of Thornerton, carpenter 1
5168662 2406556 2406556 defendant Hobbe Philip husbandman 586997 586997 Hobbe, Philip, of Thornerton, husbandman 2
5184668 2411263 2411263 defendant Ayer William miller 586997 586997 Ayer, William, of Thornerton, miller 0
5184669 2411263 2411263 defendant Chilton William carpenter 586997 586997 Chilton, William, of Thornerton, carpenter 1
5184670 2411263 2411263 defendant Hobbe Philip husbandman 586997 586997 Hobbe, Philip, of Thornerton, husbandman 2
5204445 2417051 2417051 defendant Ayer William miller 586997 586997 Ayer, William, of Thornerton, miller 0
5204446 2417051 2417051 defendant Chilton William carpenter 586997 586997 Chilton, William, of Thornerton, carpenter 1
5204447 2417051 2417051 defendant Hobbe Philip husbandman 586997 586997 Hobbe, Philip, of Thornerton, husbandman 2
5215920 2420385 2420385 defendant Tounesend John husbandman 586997 586997 Tounesend, John, of Thornerton, husbandman 2
5215921 2420385 2420385 defendant Brounston Thomas husbandman 586997 586997 Brounston, Thomas, of Thornerton, husbandman 3
5215922 2420385 2420385 defendant Drake John, junior husbandman 586997 586997 Drake, John, junior, of Thornerton, husbandman 4
5215923 2420385 2420385 defendant Brounston John husbandman 586997 586997 Brounston, John, of Thornerton, husbandman 5
5215924 2420385 2420385 defendant Drake John, senior husbandman 586997 586997 Drake, John, senior, of Thornerton, husbandman 6
5255015 2431683 2431683 defendant Pyne John laborer 586997 586997 Pyne, John, of Thornerton, laborer 0
5270457 2436460 2436460 defendant Denrigge Walter husbandman 586997 586997 Denrigge, Walter, of Thornerton, husbandman 0
5332159 2454694 2454694 defendant Say Richard husbandman 586997 586997 Say, Richard, of Thornerton, husbandman 4
5353616 2461203 2461203 defendant Wheton John husbandman 586997 586997 Wheton, John, of thornerton, husbandman 0
5361360 2463573 2463573 defendant Pyne John, senior husbandman 586997 586997 Pyne, John, senior, of Thornerton, husbandman 0
5361361 2463573 2463573 defendant Pyne John, junior laborer 586997 586997 Pyne, John, junior, of Thornerton, laborer 1
5361375 2463578 2463578 defendant Say alias Pedeler Richard husbandman 586997 586997 Say alias Pedeler, Richard, of Thornerton, husbandman 1
5475904 2497798 2497798 defendant Grede William yeoman 586997 586997 Grede, William, of Thornerton, yeoman 1
5487422 2501134 2501134 defendant Grede William yeoman 586997 586997 Grede, William, of Thornerton, yeoman 1
5493695 2503025 2503025 defendant Stephen Henry   586997 586997 Stephen, Henry, of Thornerton, mason 3
5508774 2507598 2507598 defendant Drake John, junior   586997 586997 Drake, John, junior, of Thornerton 0
5578140 2528234 2528234 defendant Godfray John husbandman 586997 586997 Godfray, John, of Thornerton, husbandman 0

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