names

79 rows where place_id = 588637

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595119 1866104 1866104 defendant Bole Robert, senior husbandman 588637 588637 Bole, Robert, senior, of Lopham, husbandman 2
3654716 1911733 1911733 defendant Norclyff Richard yeoman 588637 588637 Norclyff, Richard, of Lopham, yeoman 0
3654717 1911733 1911733 defendant Sewall John yeoman 588637 588637 Sewall, John, of Lopham, yeoman 1
3654718 1911733 1911733 defendant Underwode John   588637 588637 Underwode, John, of Lopham, shoe maker 2
3737797 1938042 1938042 defendant Garrard Nicholas husbandman 588637 588637 Garrard, Nicholas, of Lopham, husbandman 3
3791497 1955179 1955179 defendant Partryche Robert husbandman 588637 588637 Partryche, Robert, of Lopham, husbandman 0
3806355 1959901 1959901 defendant Cokerell William husbandman 588637 588637 Cokerell, William, of Lopham, husbandman 0
3900405 1990367 1990367 defendant Aleyn William husbandman 588637 588637 Aleyn, William, of Lopham, husbandman 2
3927170 1999420 1999420 defendant Kuen John husbandman 588637 588637 Kuen, John, of Lopham, husbandman 4
3955189 2008879 2008879 defendant Aldred Roger husbandman 588637 588637 Aldred, Roger, of Lopham, husbandman 2
3969883 2014065 2014065 defendant Deckney Thomas husbandman 588637 588637 Deckney, Thomas, of Lopham, husbandman 5
3974130 2015522 2015522 defendant Todd John yeoman 588637 588637 Todd, John, of Lopham, or of Norwich, yeoman 0
3980829 2017906 2017906 defendant Lovycke Christopher carpenter 588637 588637 Lovycke, Christopher, of Lopham, carpenter 3
4040260 2039020 2039020 defendant Fulmerston Thomas husbandman 588637 588637 Fulmerston, Thomas, of Lopham, husbandman 0
4186292 2090691 2090691 defendant Worlyche James laborer 588637 588637 Worlyche, James, of Lopham, laborer 1
4215429 2100891 2100891 defendant -aster Simon yeoman 588637 588637 -aster, Simon, of Lopham, yeoman 3
4240721 2109878 2109878 defendant Fulmerston Thomas yeoman 588637 588637 Fulmerston, Thomas, of Lopham, yeoman 2
4240727 2109879 2109879 defendant Fulmerston Thomas yeoman 588637 588637 Fulmerston, Thomas, of Lopham, yeoman 2
4315161 2135419 2135419 defendant Dawken William yeoman 588637 588637 Dawken, William, of Lopham, yeoman 0
4326827 2139322 2139322 defendant Sewell Edmund, junior cordwainer 588637 588637 Sewell, Edmund, junior, of Lopham, cordwainer 0
4326828 2139322 2139322 defendant Seman John weaver 588637 588637 Seman, John, of Lopham, weaver 1
4336834 2142611 2142611 defendant Watt Peter   588637 588637 Watt, Peter, of Lopham, shepherd 0
4337727 2142942 2142942 defendant Wynter Philip tailor 588637 588637 Wynter, Philip, of Lopham, tailor 1
4338916 2143365 2143365 defendant Leder Robert yeoman 588637 588637 Leder, Robert, of Lopham, yeoman 0
4340856 2144075 2144075 defendant Dade Thomas grocer 588637 588637 Dade, Thomas, of Lopham, grocer 0
4349690 2147157 2147157 defendant Cooke Henry husbandman 588637 588637 Cooke, Henry, of Lopham, husbandman 1
4386305 2160097 2160097 defendant Wade Francis weaver 588637 588637 Wade, Francis, of Lopham, weaver 0
4396500 2163404 2163404 defendant Partrich John yeoman 588637 588637 Partrich, John, of Lopham, yeoman 1
4397627 2163782 2163782 defendant Cockerell William yeoman 588637 588637 Cockerell, William, of Lopham, yeoman 0
4397830 2163853 2163853 defendant Wade Francis yeoman 588637 588637 Wade, Francis, of Lopham, yeoman 0
4409860 2167901 2167901 defendant Cooke Henry weaver 588637 588637 Cooke, Henry, of Lopham, weaver 3
4445953 2183678 2183678 defendant Ode John smith 588637 588637 Ode, John, of Lopham, smith 0
4451966 2185597 2185597 plaintiff Hunte John   588637 588637 Hunte, John, of Lopham 0
4451967 2185597 2185597 defendant Ode John   588637 588637 Ode, John, of Lopham 0
4567750 2221477 2221477 defendant Cauche Michael   588637 588637 Cauche, Michael, of Lopham 0
4571792 2222763 2222763 defendant Clerk Henry   588637 588637 Clerk, Henry, of Lopham 1
4576871 2224268 2224268 defendant Sturmyn Thomas   588637 588637 Sturmyn, Thomas, of Lopham 0
4579866 2225188 2225188 defendant Bolle Walter   588637 588637 Bolle, Walter, of Lopham 1
4627847 2239636 2239636 defendant Stryk John   588637 588637 Stryk, John, of Lopham, pedlar 1
4628314 2239783 2239783 defendant Boll Walter   588637 588637 Boll, Walter, of Lopham 0
4661018 2249272 2249272 plaintiff Drewe James   588637 588637 Drewe, James, of Lopham 0
4670157 2256371 2256371 defendant Ingelond John yeoman 588637 588637 Ingelond, John, of Lopham, yeoman 3
4727708 2273909 2273909 defendant Dyker Robert laborer 588637 588637 Dyker, Robert, of Lopham, laborer 0
4888095 2323081 2323081 defendant Wymer Nicholas husbandman 588637 588637 Wymer, Nicholas, of Lopham, husbandman 0
4909153 2329407 2329407 plaintiff Barbour Thomas clerk 588637 588637 Barbour, Thomas, of Lopham, clerk 0
4948163 2341399 2341399 plaintiff Lyng Robert mercer 588637 588637 Lyng, Robert, of Lopham, mercer 0
4979523 2350833 2350833 defendant Baldry Robert butcher 588637 588637 Baldry, Robert, of Lopham, butcher 1
4982240 2351606 2351606 defendant Lyng Robert mercer 588637 588637 Lyng, Robert, of Lopham, mercer 1
4982244 2351607 2351607 defendant Lyng Robert mercer 588637 588637 Lyng, Robert, of Lopham, mercer 1
5001813 2357428 2357428 defendant Wymer Nicholas husbandman 588637 588637 Wymer, Nicholas, of Lopham, husbandman 3
5027121 2364801 2364801 defendant Baldre Robert yeoman 588637 588637 Baldre, Robert, of Lopham, yeoman 0
5027122 2364801 2364801 defendant Pepyr John husbandman 588637 588637 Pepyr, John, of Lopham, husbandman 1
5027134 2364804 2364804 defendant Baldre Robert yeoman 588637 588637 together with Baldre, Robert, of Lopham, yeoman 1
5027135 2364804 2364804 defendant Pepyr John husbandman 588637 588637 Pepyr, John, of Lopham, husbandman 2
5037866 2367954 2367954 defendant Baldre Robert yeoman 588637 588637 Baldre, Robert, of Lopham, yeoman 0
5037867 2367954 2367954 defendant Pepyr John husbandman 588637 588637 Pepyr, John, of Lopham, husbandman 1
5045895 2370408 2370408 plaintiff Wade Robert   588637 588637 Wade, Robert, of Lopham 2
5067121 2376688 2376688 defendant Wode Thomas clerk 588637 588637 Wode, Thomas, of Lopham, clerk 0
5085037 2382035 2382035 defendant Lyng William husbandman 588637 588637 Lyng, William, of Lopham, husbandman 1
5102401 2387106 2387106 defendant Lyng William husbandman 588637 588637 Lyng, William, of Lopham, husbandman 1
5103420 2387427 2387427 defendant Lyng William yeoman 588637 588637 Lyng, William, of Lopham, yeoman 1
5141780 2398710 2398710 defendant Lyng William yeoman 588637 588637 Lyng, William, of Lopham, yeoman 0
5141781 2398710 2398710 defendant Baldre Robert husbandman 588637 588637 Baldre, Robert, of Lopham, husbandman 1
5162883 2404865 2404865 defendant Lyng William yeoman 588637 588637 Lyng, William, of Lopham, yeoman 0
5162884 2404865 2404865 defendant Baldre Robert husbandman 588637 588637 Baldre, Robert, of Lopham, husbandman 1
5236367 2426227 2426227 defendant Lyng William husbandman 588637 588637 Lyng, William, of Lopham, husbandman 3
5238391 2426817 2426817 defendant Rokyngham Edmund husbandman 588637 588637 Rokyngham, Edmund, of Lopham, husbandman 0
5238392 2426817 2426817 defendant Poole dmund husbandman 588637 588637 Poole, dmund, of Lopham, husbandman 1
5238393 2426817 2426817 defendant Lyng William husbandman 588637 588637 Lyng, William, of Lopham, husbandman 2
5238394 2426817 2426817 defendant Cresy Robert husbandman 588637 588637 Cresy, Robert, of Lopham, husbandman 3
5244078 2428455 2428455 defendant Baldery Robert yeoman 588637 588637 Baldery, Robert, of Lopham, yeoman 2
5362030 2463790 2463790 defendant Bolle Thomas husbandman 588637 588637 Bolle, Thomas, of Lopham, husbandman 0
5362199 2463842 2463842 defendant Bolle Thomas husbandman 588637 588637 Bolle, Thomas, of Lopham, husbandman 2
5458713 2492496 2492496 defendant Goll Thomas husbandman 588637 588637 Goll, Thomas, of Lopham, husbandman 1
5470319 2496045 2496045 defendant Boll Thomas husbandman 588637 588637 Boll, Thomas, of Lopham, husbandman 0
5481775 2499482 2499482 defendant Boll Thomas husbandman 588637 588637 Boll, Thomas, of Lopham, husbandman 2
5499456 2504780 2504780 defendant Bolle Thomas husbandman 588637 588637 Bolle, Thomas, of Lopham, husbandman 0
5513958 2509213 2509213 defendant Bolle Thomas husbandman 588637 588637 Bolle, Thomas, of Lopham, husbandman 1
5556722 2521924 2521924 defendant Peper John husbandman 588637 588637 Peper, John, of Lopham, husbandman 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);