names

31 rows where place_id = 595648

✎ 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
3621345 1874217 1874217 defendant Mylward John husbandman 595648 595648 Mylward, John, of Edworth, husbandman 0
3621347 1874218 1874218 defendant Mylward John husbandman 595648 595648 Mylward, John, of Edworth, husbandman 0
3637266 1906457 1906457 defendant Cowper William husbandman 595648 595648 Cowper, William, of Edworth, husbandman 4
3659851 1913335 1913335 defendant Wood John husbandman 595648 595648 Wood, John, of Edworth, husbandman 3
3662972 1914331 1914331 defendant Lymer Edward husbandman 595648 595648 Lymer, Edward, of Edworth, husbandman 0
3796803 1956882 1956882 defendant Brograve Francis gent 595648 595648 Brograve, Francis, of Edworth, gent 7
3838874 1970085 1970085 defendant Bulman Edmund chaplain 595648 595648 Bulman, Edmund, of Edworth, chaplain 0
3945583 2005531 2005531 defendant Spencer Michael husbandman 595648 595648 Spencer, Michael, of Edworth, husbandman 0
3959975 2010588 2010588 defendant Roger William weaver 595648 595648 Roger, William, of Edworth, weaver 0
3959976 2010589 2010589 plaintiff Spencer Michael yeoman 595648 595648 Spencer, Michael, of Edworth, yeoman 0
4006903 2027244 2027244 defendant Clapham Edmund yeoman 595648 595648 Clapham, Edmund, of Edworth, yeoman 0
4006907 2027245 2027245 defendant Clapham Edmund yeoman 595648 595648 Clapham, Edmund, of Edworth, yeoman 0
4074245 2051087 2051087 defendant Younge Hugh yeoman 595648 595648 Younge, Hugh, of Edworth, yeoman 0
4074246 2051087 2051087 defendant Person Martha spinster 595648 595648 Person, Martha, of Edworth, spinster 1
4503123 2201546 2201546 defendant Shephird Roger   595648 595648 Shephird, Roger, of Edworth 0
4567178 2221295 2221295 defendant Durdaunt John   595648 595648 Durdaunt, John, of Edworth 3
4684121 2260636 2260636 defendant Miles William husbandman 595648 595648 Miles, William, of Edworth, husbandman 0
4684122 2260636 2260636 defendant Edworth Robert husbandman 595648 595648 Edworth, Robert, of Edworth, husbandman 1
4760680 2283685 2283685 plaintiff Dalby John (legal representative) 595648 595648 Dalby, John, of Edworth, parson, executor of 0
4783117 2290736 2290736 defendant Myles William husbandman 595648 595648 Myles, William, of Edworth, husbandman 0
4783118 2290736 2290736 defendant Myles Robert husbandman 595648 595648 Myles, Robert, of Edworth, husbandman 1
4783120 2290736 2290736 defendant Dirdaunt William husbandman 595648 595648 Dirdaunt, William, of Edworth, husbandman 3
5215898 2420380 2420380 defendant Boteler Giles yeoman 595648 595648 Boteler, Giles, of Edworth, yeoman 1
5231865 2424892 2424892 defendant Myles William husbandman 595648 595648 Myles, William, of Edworth, husbandman 0
5315298 2449631 2449631 defendant Mylys Edward husbandman 595648 595648 Mylys, Edward, of Edworth, husbandman 1
5393392 2473167 2473167 defendant Smyth John husbandman 595648 595648 Smyth, John, of Edworth, husbandman 0
5408743 2477571 2477571 defendant Smyth John maltman 595648 595648 Smyth, John, of Edworth, maltman 0
5416806 2479942 2479942 defendant Feverell John clerk 595648 595648 Feverell, John, of Edworth, clerk 0
5433764 2485063 2485063 defendant Fenerell John clerk 595648 595648 Fenerell, John, of Edworth, clerk 0
5479594 2498908 2498908 defendant Myllewarde John husbandman 595648 595648 Myllewarde, John, of Edworth, husbandman 1
5586740 2530895 2530895 defendant Westerdale William clerk 595648 595648 Westerdale, William, of Edworth, clerk 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);