names

85 rows where place_id = 597739

✎ 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
3629670 1904133 1904133 defendant Doweshed John, senior yeoman 597739 597739 Doweshed, John, senior, of Northwold, yeoman 0
3632089 1904853 1904853 defendant Fayerbank William tailor 597739 597739 Fayerbank, William, of Northwold, tailor 3
3633647 1905333 1905333 defendant Ray William husbandman 597739 597739 (Ray, William, of Northwold, husbandman 1
3648629 1909959 1909959 defendant Harward Thomas husbandman 597739 597739 Harward, Thomas, of Northwold, husbandman 2
3667797 1915869 1915869 defendant Carter Thomas husbandman 597739 597739 Carter, Thomas, of Northwold, husbandman 0
3685786 1921710 1921710 defendant Ragon Miles chaplain 597739 597739 Ragon, Miles, of Northwold, chaplain 0
3689899 1923001 1923001 plaintiff Foxe John (legal representative) 597739 597739 Foxe, John, of Northwold, draper, executor of 0
3693359 1924136 1924136 defendant Carter Thomas yeoman 597739 597739 Carter, Thomas, of Northwold, yeoman 0
3703306 1927307 1927307 defendant Rakyn Robert carpenter 597739 597739 Rakyn, Robert, of Northwold, carpenter 0
3729208 1935385 1935385 defendant Carter John butcher 597739 597739 Carter, John, of Northwold, butcher 0
3729209 1935385 1935385 defendant Constable alias Benet John laborer 597739 597739 Constable alias Benet, John, of Northwold, laborer 1
3741326 1939152 1939152 defendant Carter John butcher 597739 597739 Carter, John, of Northwold, butcher 0
3746977 1940974 1940974 plaintiff Damet Robert (legal representative) 597739 597739 Damet, Robert, of Northwold, gent, executors of 0
3760477 1945281 1945281 plaintiff Damet Robert (legal representative) 597739 597739 Damet, Robert, of Northwold, gent, executors of 0
3761074 1945464 1945464 defendant Kentyng John husbandman 597739 597739 Kentyng, John, of Northwold, husbandman 1
3795429 1956444 1956444 defendant Carter Thomas yeoman 597739 597739 Carter, Thomas, of Northwold, yeoman 0
3798862 1957559 1957559 defendant Brygges William glover 597739 597739 Brygges, William, of Northwold, glover 0
3828705 1966854 1966854 defendant Thorbronde James husbandman 597739 597739 Thorbronde, James, of Northwold, husbandman 0
3843580 1971528 1971528 defendant Thorbrond James husbandman 597739 597739 Thorbrond, James, of Northwold, husbandman 0
3866277 1978950 1978950 defendant Verley Christopher laborer 597739 597739 Verley, Christopher, of Northwold, laborer 0
3885470 1985397 1985397 defendant Cokett William gent 597739 597739 Cokett, William, of Northwold, gent 0
3887106 1985951 1985951 defendant Cokett William gent 597739 597739 Cokett, William, of Northwold, gent 0
3895577 1988727 1988727 plaintiff Stalon John yeoman 597739 597739 Stalon, John, of Northwold, yeoman 0
3907805 1992898 1992898 plaintiff Perys Robert   597739 597739 Perys, Robert, of Northwold 0
3921182 1997437 1997437 defendant Brewer John smith 597739 597739 Brewer, John, of Northwold, smith 1
3927531 1999551 1999551 defendant Perys Robert   597739 597739 Perys, Robert, of Northwold, gent, administrators of 0
3927532 1999551 1999551 defendant Bull Edward gent 597739 597739 (Bull, Edward, of Northwold, gent 1
3957339 2009629 2009629 defendant Beare William miller 597739 597739 Beare, William, of Northwold, miller 0
3960051 2010615 2010615 plaintiff Stalon William   597739 597739 Stalon, William, of Northwold, gent, administrators of 0
3961018 2010948 2010948 defendant Lakyn Richard gent 597739 597739 (Lakyn, Richard, of Northwold, gent 2
3962225 2011369 2011369 defendant Beare William miller 597739 597739 Beare, William, of Northwold, miller 0
3962229 2011370 2011370 defendant Beare William miller 597739 597739 Beare, William, of Northwold, miller 0
3968091 2013464 2013464 defendant Gardener John butcher 597739 597739 Gardener, John, of Northwold, butcher 1
3975489 2015994 2015994 defendant Dawson John, junior glover 597739 597739 Dawson, John, junior, of Northwold, glover 0
3975520 2016003 2016003 defendant Dawson John, junior glover 597739 597739 Dawson, John, junior, of Northwold, glover 0
4012643 2029246 2029246 defendant Carter William husbandman 597739 597739 Carter, William, of Northwold, husbandman 1
4015342 2030180 2030180 defendant Ormes John husbandman 597739 597739 Ormes, John, of Northwold, husbandman 2
4026704 2034195 2034195 defendant Dawson John glover 597739 597739 Dawson, John, of Northwold, glover 0
4026825 2034242 2034242 defendant Hulyer Thomas, junior husbandman 597739 597739 Hulyer, Thomas, junior, of Northwold, husbandman 1
4026839 2034248 2034248 defendant Carter Thomas husbandman 597739 597739 Carter, Thomas, of Northwold, husbandman 0
4028924 2034987 2034987 defendant Beare William miller 597739 597739 Beare, William, of Northwold, miller 2
4029227 2035098 2035098 defendant Carter Thomas husbandman 597739 597739 Carter, Thomas, of Northwold, husbandman 0
4029228 2035098 2035098 defendant Wace John husbandman 597739 597739 Wace, John, of Northwold, husbandman 1
4029587 2035219 2035219 defendant Dawson John, junior glover 597739 597739 Dawson, John, junior, of Northwold, glover 0
4054557 2044019 2044019 defendant Carter Thomas husbandman 597739 597739 Carter, Thomas, of Northwold, husbandman 0
4060355 2046104 2046104 defendant Carter Thomas yeoman 597739 597739 Carter, Thomas, of Northwold, yeoman 0
4076584 2051924 2051924 defendant Sparowe John, senior husbandman 597739 597739 Sparowe, John, senior, of Northwold, husbandman 0
4077735 2052330 2052330 defendant Beverley Anthony tailor 597739 597739 Beverley, Anthony, of Northwold, tailor 1
4091551 2057270 2057270 defendant Whart Henry laborer 597739 597739 Whart, Henry, of Northwold, laborer 3
4221471 2103002 2103002 plaintiff Smyth Thomas   597739 597739 Smyth, Thomas, of Northwold 0
4282041 2123619 2123619 defendant Bolton Francis gent 597739 597739 Bolton, Francis, of Northwold, gent 0
4332757 2141238 2141238 defendant Bolton Francis gent 597739 597739 Bolton, Francis, of Northwold, gent 1
4405008 2166247 2166247 defendant Reymond Robert yeoman 597739 597739 Reymond, Robert, of Northwold, yeoman 0
4472828 2192175 2192175 defendant Baker Robert   597739 597739 Baker, Robert, of Northwold 1
4560584 2219251 2219251 defendant Walton Walter   597739 597739 Walton, Walter, of Northwold, son of John 0
4654538 2247298 2247298 defendant Kenynghale Benedict   597739 597739 Kenynghale, Benedict, of Northwold, bailiff 1
4658382 2248506 2248506 defendant Aunger John esq 597739 597739 Aunger, John, of Northwold, esq 2
4735860 2276366 2276366 defendant Pye John yeoman 597739 597739 Pye, John, of Northwold, yeoman 0
4735862 2276367 2276367 defendant Pye John yeoman 597739 597739 Pye, John, of Northwold, yeoman 0
4758657 2283081 2283081 defendant Pye Geoffrey dyer 597739 597739 Pye, Geoffrey, of Northwold, dyer 24
4758674 2283082 2283082 defendant Pye Geoffrey dyer 597739 597739 Pye, Geoffrey, of Northwold, dyer 1
4790817 2293217 2293217 defendant Brodey John husbandman 597739 597739 Brodey, John, of Northwold, husbandman 0
4819180 2302078 2302078 defendant Wynman John smith 597739 597739 Wynman, John, of Northwold, smith 0
4857341 2313680 2313680 defendant Sparwe or Sparowe John   597739 597739 Sparwe or Sparowe, John, of Northwold 0
4916091 2331534 2331534 defendant Sterlyng John butcher 597739 597739 Sterlyng, John, of Northwold, butcher 0
4916092 2331534 2331534 defendant Pollard Richard butcher 597739 597739 Pollard, Richard, of Northwold, butcher 1
4919698 2332667 2332667 defendant Rownyng Robert husbandman 597739 597739 Rownyng, Robert, of Northwold, husbandman 0
4919699 2332667 2332667 defendant Hende John thatcher 597739 597739 Hende, John, of Northwold, thatcher 1
4919700 2332667 2332667 defendant Hende Walter chaplain 597739 597739 Hende, Walter, of Northwold, chaplain 2
4925507 2334410 2334410 defendant Pollard Richard butcher 597739 597739 Pollard, Richard, of Northwold, butcher 2
4999177 2356625 2356625 defendant Lynford Simon gent 597739 597739 Lynford, Simon, of Northwold, gent 0
4999178 2356625 2356625 defendant Est Robert husbandman 597739 597739 Est, Robert, of Northwold, husbandman 1
5020742 2362965 2362965 defendant Grome John husbandman 597739 597739 Grome, John, of Northwold, husbandman 0
5020745 2362967 2362967 plaintiff Est Thomas   597739 597739 Est, Thomas, of Northwold 0
5020747 2362967 2362967 plaintiff Sterlyng John   597739 597739 Sterlyng, John, of Northwold 2
5020748 2362967 2362967 defendant Grome John husbandman 597739 597739 Grome, John, of Northwold, husbandman 0
5020749 2362967 2362967 defendant Hodges Robert husbandman 597739 597739 Hodges, Robert, of Northwold, husbandman 1
5020750 2362967 2362967 defendant Lopham William husbandman 597739 597739 Lopham, William, of Northwold, husbandman 2
5066596 2376534 2376534 defendant Estede Thomas yeoman 597739 597739 Estede, Thomas, of Northwold, yeoman 0
5083163 2381465 2381465 defendant Chapman John, senior husbandman 597739 597739 Chapman, John, senior, of Northwold, husbandman 0
5083164 2381465 2381465 defendant Chapman John, junior husbandman 597739 597739 Chapman, John, junior, of Northwold, husbandman 1
5087727 2382795 2382795 defendant Keteryngham Thomas husbandman 597739 597739 Keteryngham, Thomas, of Northwold, husbandman 3
5308940 2447719 2447719 defendant Benet Richard husbandman 597739 597739 Benet, Richard, of Northwold, husbandman 0
5391272 2472582 2472582 plaintiff Parys John   597739 597739 Parys, John, of Northwold 0
5600180 2534941 2534941 defendant Blake Thomas yeoman 597739 597739 Blake, Thomas, of Northwold, yeoman 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);