names

33 rows where place_id = 588677

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595256 1866150 1866150 defendant Judde Walter butcher 588677 588677 Judde, Walter, of Kymbolton, Hunts, butcher 0
3595258 1866151 1866151 defendant Judde Walter butcher 588677 588677 Judde, Walter, of Kymbolton, Hunts, butcher 0
3621987 1874419 1874419 defendant Gardener Henry chapman 588677 588677 Gardener, Henry, of Kymbolton, Hunts, chapman 1
3621990 1874420 1874420 defendant Gardener Henry chapman 588677 588677 Gardener, Henry, of Kymbolton, Hunts, chapman 1
3869333 1979986 1979986 defendant Harvy Edward gent 588677 588677 Harvy, Edward, of Kymbolton, Hunts, gent 0
3963226 2011741 2011741 defendant Wyngfeld Thomas esq 588677 588677 Wyngfeld, Thomas, of Kymbolton, Hunts, esq 0
3993963 2022591 2022591 defendant Beard Edmund chapman 588677 588677 Beard, Edmund, of Kymbolton, Hunts, chapman 0
4004610 2026424 2026424 plaintiff Jerman Thomas baker 588677 588677 Jerman, Thomas, of Kymbolton, Hunts, baker 0
4024080 2033317 2033317 plaintiff Berde Edmund   588677 588677 Berde, Edmund, of Kymbolton, Hunts, "bedder" 0
4024082 2033318 2033318 plaintiff Berde Edmund   588677 588677 Berde, Edmund, of Kymbolton, Hunts, "bedder" 0
4049156 2042146 2042146 plaintiff Trigge Thomas yeoman 588677 588677 Trigge, Thomas, of Kymbolton, Hunts, yeoman 0
4156297 2080275 2080275 defendant Wyngfelde Thomas esq 588677 588677 Wyngfelde, Thomas, of Kymbolton, Hunts, or of Deane, Beds, esq 0
4243086 2110678 2110678 defendant Beard Thomas gent 588677 588677 Beard, Thomas, of Kymbolton, Hunts, gent 3
4244968 2111301 2111301 defendant Smythe Thomas Mary gent 588677 588677 Smythe, Thomas Mary, of Kymbolton, Hunts, gent 1
4253376 2114119 2114119 defendant Beard Thomas gent 588677 588677 Beard, Thomas, of Kymbolton, Hunts, gent 3
4269030 2119237 2119237 defendant Smythe Thomas Maria gent 588677 588677 Smythe, Thomas Maria, of Kymbolton, Hunts, gent 1
4379943 2157929 2157929 defendant Wingefeild Edward   588677 588677 Wingefeild, Edward, of Kymbolton, Hunts, knight 0
4752224 2281123 2281123 defendant Fraunceys Simon yeoman 588677 588677 Fraunceys, Simon, of Kymbolton, Hunts, yeoman 0
4847066 2310585 2310585 defendant Meryfowele Roger husbandman 588677 588677 Meryfowele, Roger, of Kymbolton, Hunts, husbandman 4
4925668 2334462 2334462 defendant Sonnygn Willam drover 588677 588677 Sonnygn, Willam, of Kymbolton, Hunts, drover 0
4931410 2336203 2336203 defendant atte Ponde Thomas tanner 588677 588677 atte Ponde, Thomas, of Kymbolton, Hunts, tanner 0
5119020 2391999 2391999 defendant Crane alias Meryfoll John yeoman 588677 588677 Crane alias Meryfoll, John, of Kymbolton, Hunts, yeoman 0
5144230 2399464 2399464 defendant Broun Thomas butcher 588677 588677 Broun, Thomas, of Kymbolton, Hunts, butcher 1
5165139 2405550 2405550 defendant Broun Thomas butcher 588677 588677 Broun, Thomas, of Kymbolton, Hunts, butcher 1
5178854 2409541 2409541 defendant Broun Thomas butcher 588677 588677 Broun, Thomas, of Kymbolton, Hunts, butcher 1
5201636 2416244 2416244 defendant Broun Thomas butcher 588677 588677 Broun, Thomas, of Kymbolton, Hunts, butcher 1
5246414 2429114 2429114 defendant Corbet John buther 588677 588677 Corbet, John, of Kymbolton, Hunts, buther 2
5263413 2434304 2434304 defendant Felypp or Phylypp Roger drover or baker 588677 588677 Felypp or Phylypp, Roger, of Kymbolton, Hunts, drover or baker 0
5263415 2434305 2434305 defendant Felypp or Phylypp Roger drover or baker 588677 588677 Felypp or Phylypp, Roger, of Kymbolton, Hunts, drover or baker 0
5368970 2465885 2465885 defendant Festome Thomas draper 588677 588677 Festome, Thomas, of Kymbolton, Hunts, draper 2
5368983 2465890 2465890 defendant Festome Thomas draper 588677 588677 Festome, Thomas, of Kymbolton, Hunts, draper 2
5397693 2474409 2474409 defendant Broune Thomas, senior butcher 588677 588677 Broune, Thomas, senior, of Kymbolton, Hunts, butcher 1
5412423 2478662 2478662 defendant Fescome Thomas draper 588677 588677 Fescome, Thomas, of Kymbolton, Hunts, draper 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);