names

35 rows where place_id = 593014

✎ 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
3610063 1870814 1870814 defendant Wales William yeoman 593014 593014 Wales, William, of Amwell, yeoman 0
3650663 1910572 1910572 defendant Wodleffe William (legal representative) 593014 593014 Wodleffe, William, of Amwell, executor of 3
3690718 1923264 1923264 defendant Galawey Christopher smith 593014 593014 Galawey, Christopher, of Amwell, smith 0
4152953 2079138 2079138 defendant Thorowgood Nicholas yeoman 593014 593014 Thorowgood, Nicholas, of Amwell, yeoman 0
4199658 2095433 2095433 defendant Crowche Robert tanner 593014 593014 Crowche, Robert, of Amwell, tanner 0
4276201 2121619 2121619 defendant Meade Christopher gent 593014 593014 Meade, Christopher, of Amwell, gent 0
4277761 2122146 2122146 defendant Walker Augustine yeoman 593014 593014 Walker, Augustine, of Amwell, yeoman 0
4311752 2134249 2134249 defendant Barstowe George yeoman 593014 593014 Barstowe, George, of Amwell, yeoman 2
4352699 2148176 2148176 defendant Blomeley George yeoman 593014 593014 Blomeley, George, of Amwell, yeoman 1
4352700 2148176 2148176 defendant Hille Richard bargeman 593014 593014 Hille, Richard, of Amwell, yeoman, bargeman 2
4394326 2162699 2162699 defendant Wright Richard limeburrner 593014 593014 Wright, Richard, of Amwell, limeburrner 3
4412892 2168906 2168906 defendant Thurgood Edward yeoman 593014 593014 Thurgood, Edward, of Amwell, yeoman 2
4556521 2217974 2217974 plaintiff Hunt John (legal representative) 593014 593014 Hunt, John, of Amwell, vicar, executor of 0
4556522 2217974 2217974 defendant Carpenter William   593014 593014 Carpenter, William, of Amwell 0
4596005 2230000 2230000 defendant Heyle Robert   593014 593014 Heyle, Robert, of Amwell 0
4716155 2270362 2270362 defendant Reyton William husbandman 593014 593014 Reyton, William, of Amwell, husbandman 0
4733088 2275526 2275526 defendant Yonge Richard weaver 593014 593014 Yonge, Richard, of Amwell, weaver 0
4747168 2279675 2279675 defendant Chaloner John husbandman 593014 593014 Chaloner, John, of Amwell, husbandman 0
4748758 2280121 2280121 defendant Stokerell Richard smith 593014 593014 Stokerell, Richard, of Amwell, smith 2
4775140 2288219 2288219 defendant Legge William dyer 593014 593014 Legge, William, of Amwell, dyer 0
4870348 2317703 2317703 defendant Leye John tanner 593014 593014 Leye, John, of Amwell, tanner 0
4930971 2336083 2336083 defendant Cook John husbandman 593014 593014 Cook, John, of Amwell, husbandman 0
4930973 2336084 2336084 defendant Cook John husbandman 593014 593014 Cook, John, of Amwell, husbandman 0
4975243 2349549 2349549 defendant Redesdale William   593014 593014 Redesdale, William, of Amwell, bailiff 3
5018416 2362270 2362270 defendant Helder Thomas husbandman 593014 593014 Helder, Thomas, of Amwell, husbandman 0
5144209 2399457 2399457 defendant Kyllam William smith 593014 593014 Kyllam, William, of Amwell, smith 2
5255548 2431852 2431852 defendant Boure John husbandman 593014 593014 Boure, John, of Amwell, husbandman 0
5263479 2434324 2434324 defendant Denham John ostler 593014 593014 Denham, John, of Amwell, ostler 0
5356140 2461997 2461997 defendant Kyrkeby Robert husbandman 593014 593014 Kyrkeby, Robert, of Amwell, husbandman 0
5590418 2531974 2531974 defendant Wodley William husbandman 593014 593014 Wodley, William, of Amwell, husbandman 0
5590419 2531974 2531974 defendant Calaway Christopher husbandman 593014 593014 Calaway, Christopher, of Amwell, husbandman 1
5590420 2531974 2531974 defendant Hoddesdon Robert husbandman 593014 593014 Hoddesdon, Robert, of Amwell, husbandman 2
5590421 2531974 2531974 defendant West Robert husbandman 593014 593014 West, Robert, of Amwell, husbandman 3
5590422 2531974 2531974 defendant Harper John husbandman 593014 593014 Harper, John, of Amwell, husbandman 4
5590423 2531974 2531974 defendant Robynson Thomas husbandman 593014 593014 Robynson, Thomas, of Amwell, husbandman 5

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