names

26 rows where place_id = 601304

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3644740 1908759 1908759 defendant Flowre John husbandman 601304 601304 Flowre, John, of Bishops Lavyngton, husbandman 0
3968383 2013575 2013575 defendant Hensworth Guy yeoman 601304 601304 Hensworth, Guy, of Bishops Lavyngton, yeoman 0
3968385 2013575 2013575 defendant Tanner alias Thomas William yeoman 601304 601304 Tanner alias Thomas, William, of Bishops Lavyngton, yeoman 2
3968388 2013576 2013576 defendant Hensworth Guy yeoman 601304 601304 together with Hensworth, Guy, of Bishops Lavyngton, yeoman 1
3968389 2013576 2013576 defendant Tanner alias Thomas William yeoman 601304 601304 Tanner alias Thomas, William, of Bishops Lavyngton, yeoman 2
4574506 2223558 2223558 defendant Palmere Thomas   601304 601304 Palmere, Thomas, of Bishops Lavyngton 0
4574507 2223558 2223558 defendant Dornell John   601304 601304 Dornell, John, of Bishops Lavyngton 1
4606169 2233040 2233040 plaintiff Auncell John (legal representative) 601304 601304 Auncell, John, of Bishops Lavyngton, executors of 0
4676320 2258205 2258205 defendant Romesey Robert husbandman 601304 601304 Romesey, Robert, of Bishops Lavyngton, husbandman 1
4746993 2279623 2279623 defendant Leder William husbandman 601304 601304 Leder, William, of Bishops Lavyngton, husbandman 1
4811994 2299864 2299864 defendant Hardyng Thomas husbandman 601304 601304 Hardyng, Thomas, of Bishops Lavyngton, husbandman 1
4891389 2324035 2324035 defendant Leder William husbandman 601304 601304 Leder, William, of Bishops Lavyngton, husbandman 0
4945772 2340664 2340664 defendant Lever William husbandman 601304 601304 Lever, William, of Bishops Lavyngton, husbandman 0
4971250 2348340 2348340 defendant Bradelegh Henry gent 601304 601304 Bradelegh, Henry, of Bishops Lavyngton, gent 1
5024782 2364170 2364170 defendant Bradleygh Henry gent 601304 601304 Bradleygh, Henry, of Bishops Lavyngton, gent 0
5081226 2380890 2380890 defendant Mynty Stephen husbandman 601304 601304 Mynty, Stephen, of Bishops Lavyngton, husbandman 0
5215089 2420138 2420138 defendant Dauntesey John gent 601304 601304 Dauntesey, John, of Bishops Lavyngton, gent 0
5262242 2433938 2433938 defendant Tynker Robert husbandman 601304 601304 Tynker, Robert, of Bishops Lavyngton, husbandman 3
5313578 2449091 2449091 defendant Houchon or Honchon John husbandman 601304 601304 Houchon or Honchon, John, of Bishops Lavyngton, husbandman 1
5386616 2471235 2471235 defendant Grenehill William, junior husbandman 601304 601304 Grenehill, William, junior, of Bishops Lavyngton, husbandman 0
5483759 2500091 2500091 defendant Grenehill William tucker 601304 601304 Grenehill, William, of Bishops Lavyngton, tucker 0
5483760 2500091 2500091 defendant Grenehill Thomas husbandman 601304 601304 Grenehill, Thomas, of Bishops Lavyngton, husbandman 1
5483761 2500091 2500091 defendant Skaylle John husbandman 601304 601304 Skaylle, John, of Bishops Lavyngton, husbandman 2
5483762 2500091 2500091 defendant Kynge Richard husbandman 601304 601304 Kynge, Richard, of Bishops Lavyngton, husbandman 3
5483763 2500091 2500091 defendant Hayward Roger husbandman 601304 601304 Hayward, Roger, of Bishops Lavyngton, husbandman 4
5593862 2533069 2533069 defendant Cryklade John gent 601304 601304 Cryklade, John, of Bishops Lavyngton, gent 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);