names

41 rows where place_id = 628408

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3782112 1952158 1952158 defendant Jurden Bartholomew husbandman 628408 628408 Jurden, Bartholomew, of Erlyngham, husbandman 0
3782114 1952158 1952158 defendant Brencheley John laborer 628408 628408 Brencheley, John, of Erlyngham, laborer 2
4476822 2193413 2193413 defendant Yate John   628408 628408 Yate, John, of Erlyngham 0
4572907 2223067 2223067 defendant atte Hulle John   628408 628408 atte Hulle, John, of Erlyngham 0
4620929 2237528 2237528 defendant Davys John   628408 628408 Davys, John, of Erlyngham 0
4638123 2242686 2242686 defendant Taillour John   628408 628408 Taillour, John, of Erlyngham 3
4718568 2271145 2271145 defendant Mylton Richard   628408 628408 Mylton, Richard, of Erlyngham, franklin 0
4740224 2277653 2277653 defendant Bailly Walter   628408 628408 Bailly, Walter, of Erlyngham, boat man 0
4820112 2302365 2302365 defendant Longeney Richard, junior husbandman 628408 628408 Longeney, Richard, junior, of Erlyngham, husbandman 0
4845231 2310020 2310020 defendant Wall William   628408 628408 Wall, William, of Erlyngham 0
4847370 2310684 2310684 plaintiff Rolf Thomas   628408 628408 Rolf, Thomas, of Erlyngham 0
4859192 2314248 2314248 defendant Walle Richard husbandman 628408 628408 Walle, Richard, of Erlyngham, husbandman 3
4883799 2321840 2321840 defendant Walle William husbandman 628408 628408 Walle, William, of Erlyngham, husbandman 1
4940802 2339151 2339151 defendant Hevye William mariner 628408 628408 Hevye, William, of Erlyngham, mariner 3
4975870 2349744 2349744 defendant Bailly Robert chapman 628408 628408 Bailly, Robert, of Erlyngham, chapman 0
5004983 2358354 2358354 defendant Stevenes William yeoman 628408 628408 Stevenes, William, of Erlyngham, yeoman 0
5039632 2368500 2368500 defendant Stevenys William laborer 628408 628408 Stevenys, William, of Erlyngham, laborer 1
5039640 2368501 2368501 defendant Stevyns William laborer 628408 628408 Stevyns, William, of Erlyngham, laborer 1
5086995 2382579 2382579 defendant Roberdys John laborer 628408 628408 Roberdys, John, of Erlyngham, laborer 0
5086996 2382579 2382579 defendant Fox William laborer 628408 628408 Fox, William, of Erlyngham, laborer 1
5086997 2382579 2382579 defendant Kyng William husbandman 628408 628408 Kyng, William, of Erlyngham, husbandman 2
5086998 2382579 2382579 defendant Eyre Robert laborer 628408 628408 Eyre, Robert, of Erlyngham, laborer 3
5086999 2382579 2382579 defendant Corde Thomas laborer 628408 628408 Corde, Thomas, of Erlyngham, laborer 4
5087000 2382579 2382579 defendant Bourey Richard laborer 628408 628408 Bourey, Richard, of Erlyngham, laborer 5
5087001 2382579 2382579 defendant Wrenche John laborer 628408 628408 Wrenche, John, of Erlyngham, laborer 6
5087002 2382579 2382579 defendant Walshman Richard laborer 628408 628408 Walshman, Richard, of Erlyngham, laborer 7
5087003 2382579 2382579 defendant Kyng John laborer 628408 628408 Kyng, John, of Erlyngham, laborer 8
5087004 2382579 2382579 defendant Kyng Richard laborer 628408 628408 Kyng, Richard, of Erlyngham, laborer 9
5087005 2382579 2382579 defendant Laueraunce John laborer 628408 628408 Laueraunce, John, of Erlyngham, laborer 10
5087006 2382579 2382579 defendant Ithell John husbandman 628408 628408 Ithell, John, of Erlyngham, husbandman 11
5249938 2430093 2430093 defendant Thee Richard laborer 628408 628408 Thee, Richard, of Erlyngham, laborer 1
5353593 2461195 2461195 defendant Horne John yeoman 628408 628408 Horne, John, of Erlyngham, yeoman 3
5380503 2469474 2469474 defendant Hyches William carpenter 628408 628408 Hyches, William, of Erlyngham, carpenter 0
5380504 2469474 2469474 defendant Yevan John husbandman 628408 628408 Yevan, John, of Erlyngham, husbandman 1
5385134 2470822 2470822 defendant Hythes William carpenter 628408 628408 Hythes, William, of Erlyngham, carpenter 0
5385135 2470822 2470822 defendant Yevan John husbandman 628408 628408 Yevan, John, of Erlyngham, husbandman 1
5424235 2482214 2482214 defendant Yevan John husbandman 628408 628408 Yevan, John, of Erlyngham, husbandman 1
5577072 2527876 2527876 defendant Yate Richard gent 628408 628408 Yate, Richard, of Erlyngham, gent 0
5594438 2533239 2533239 defendant Wall Walter husbandman 628408 628408 Wall, Walter, of Erlyngham, husbandman 0
5594439 2533239 2533239 defendant Robertes Walter husbandman 628408 628408 Robertes, Walter, of Erlyngham, husbandman 1
5626374 2552217 2552217 defendant Praty John laborer 628408 628408 Praty, John, of Erlyngham, laborer 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);