names

43 rows where place_id = 603290

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3620641 1874035 1874035 defendant Elger Thomas   603290 603290 Elger, Thomas, of Brancaster, shepherd 0
3654076 1911537 1911537 defendant Burges Thomas husbandman 603290 603290 Burges, Thomas, of Brancaster, husbandman 0
3654077 1911537 1911537 defendant Wallet Edmund husbandman 603290 603290 Wallet, Edmund, of Brancaster, husbandman 1
3740138 1938775 1938775 defendant Lane Robert   603290 603290 Lane, Robert, of Brancaster, shepherd 1
3752570 1942731 1942731 defendant Holtham Walter mariner 603290 603290 Holtham, Walter, of Brancaster, mariner 0
3816259 1962994 1962994 defendant Holkam Walter mariner 603290 603290 Holkam, Walter, of Brancaster, mariner 0
3826754 1966220 1966220 defendant Smyth Gilbert husbandman 603290 603290 Smyth, Gilbert, of Brancaster, husbandman 0
3831171 1967637 1967637 defendant Smyth Edward husbandman 603290 603290 Smyth, Edward, of Brancaster, husbandman 0
3847970 1972940 1972940 defendant Smyth Gilbert husbandman 603290 603290 Smyth, Gilbert, of Brancaster, husbandman 2
4033934 2036791 2036791 defendant Clyfton Thomas gent 603290 603290 Clyfton, Thomas, of Brancaster, gent 0
4033935 2036791 2036791 defendant Wulston John yeoman 603290 603290 Wulston, John, of Brancaster, yeoman 1
4033940 2036793 2036793 defendant Clyfton Thomas gent 603290 603290 Clyfton, Thomas, of Brancaster, gent 0
4033941 2036793 2036793 defendant Wolston John yeoman 603290 603290 Wolston, John, of Brancaster, yeoman 1
4033948 2036796 2036796 defendant Clyfton Thomas gent 603290 603290 Clyfton, Thomas, of Brancaster, gent 0
4033949 2036796 2036796 defendant Wolston John husbandman 603290 603290 Wolston, John, of Brancaster, husbandman 1
4064619 2047628 2047628 defendant Wolston John yeoman 603290 603290 Wolston, John, of Brancaster, yeoman 0
4076460 2051877 2051877 defendant Clyfton Thomas yeoman 603290 603290 Clyfton, Thomas, of Brancaster, yeoman 1
4187445 2091108 2091108 defendant Wulston John yeoman 603290 603290 Wulston, John, of Brancaster, yeoman 0
4248487 2112481 2112481 defendant Foster John blacksmith 603290 603290 Foster, John, of Brancaster, blacksmith 0
4248489 2112482 2112482 defendant Foster John blacksmith 603290 603290 Foster, John, of Brancaster, blacksmith 0
4328429 2139823 2139823 defendant Toll James gent 603290 603290 Toll, James, of Brancaster, gent 0
4332304 2141096 2141096 defendant Smyth Thomas gent 603290 603290 Smyth, Thomas, of Brancaster, gent 1
4342099 2144517 2144517 defendant Manser John husbandman 603290 603290 Manser, John, of Brancaster, husbandman 0
4342100 2144517 2144517 defendant Smyth Robert mariner 603290 603290 Smyth, Robert, of Brancaster, mariner 1
4394869 2162870 2162870 defendant Wolston John merchant 603290 603290 Wolston, John, of Brancaster, merchant 0
5110787 2389553 2389553 defendant Moye Thomas yeoman 603290 603290 Moye, Thomas, of Brancaster, yeoman 0
5118244 2391775 2391775 defendant Moye Thomas yeoman 603290 603290 Moye, Thomas, of Brancaster, yeoman 0
5299615 2444859 2444859 defendant Master John husbandman 603290 603290 Master, John, of Brancaster, husbandman 2
5415614 2479613 2479613 defendant Curteys John   603290 603290 Curteys, John, of Brancaster 0
5415615 2479613 2479613 defendant Heyward Robert husbandman 603290 603290 Heyward, Robert, of Brancaster, husbandman 1
5417107 2480022 2480022 defendant Thymbyll John yeoman 603290 603290 Thymbyll, John, of Brancaster, yeoman 2
5419343 2480705 2480705 defendant Themyll John   603290 603290 Themyll, John, of Brancaster 1
5434264 2485183 2485183 defendant Thymyll John yeoman 603290 603290 Thymyll, John, of Brancaster, yeoman 2
5449667 2489789 2489789 defendant Thymbyll John yeoman 603290 603290 Thymbyll, John, of Brancaster, yeoman 1
5464596 2494329 2494329 plaintiff Thymbyll John   603290 603290 Thymbyll, John, of Brancaster 0
5464597 2494329 2494329 defendant Calowe William husbandman 603290 603290 Calowe, William, of Brancaster, husbandman 0
5464598 2494330 2494330 plaintiff Thymbyll John   603290 603290 Thymbyll, John, of Brancaster 0
5472250 2496666 2496666 defendant Thrymell John yeoman 603290 603290 Thrymell, John, of Brancaster, yeoman 0
5472251 2496666 2496666 defendant Peresson John husbandman 603290 603290 Peresson, John, of Brancaster, husbandman 1
5472253 2496667 2496667 defendant Thymell John yeoman 603290 603290 Thymell, John, of Brancaster, yeoman 0
5472254 2496667 2496667 defendant Peresson John husbandman 603290 603290 Peresson, John, of Brancaster, husbandman 1
5476423 2497952 2497952 plaintiff Tymbyll John John   603290 603290 Tymbyll, John John, of Brancaster 0
5538303 2516465 2516465 defendant Calowe William yeoman 603290 603290 Calowe, William, of Brancaster, yeoman 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);