names

58 rows where place_id = 600167

✎ 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
3639969 1907314 1907314 defendant Byrd Edward yeoman 600167 600167 Byrd, Edward, of Tuxford, yeoman 0
3683545 1920986 1920986 defendant Blakbek Richard husbandman 600167 600167 Blakbek, Richard, of Tuxford, husbandman 0
3791911 1955314 1955314 defendant Levesey Robert husbandman 600167 600167 Levesey, Robert, of Tuxford, husbandman 0
3808371 1960491 1960491 defendant Levesey Robert husbandman 600167 600167 Levesey, Robert, of Tuxford, husbandman 0
3808374 1960492 1960492 defendant Levesey Robert husbandman 600167 600167 Levesey, Robert, of Tuxford, husbandman 0
3882599 1984444 1984444 defendant Gurnell John yeoman 600167 600167 Gurnell, John, of Tuxford, yeoman 0
3916523 1995902 1995902 defendant Levesey John   600167 600167 Levesey, John, of Tuxford, parson of Elston 0
3941043 2004008 2004008 plaintiff Taylour Peter yeoman 600167 600167 Taylour, Peter, of Tuxford, yeoman 0
3977390 2016662 2016662 defendant Cave Robert butcher 600167 600167 Cave, Robert, of Tuxford, butcher 0
4156914 2080496 2080496 defendant Antyn or Autyn Mathew cordwainer 600167 600167 Antyn or Autyn, Mathew, of Tuxford, cordwainer 0
4156915 2080496 2080496 defendant Watmore William husbandman 600167 600167 Watmore, William, of Tuxford, husbandman 1
4156916 2080496 2080496 defendant Brayton William gent 600167 600167 Brayton, William, of Tuxford, gent 2
4214527 2100589 2100589 defendant Cale Robert butcher 600167 600167 Cale, Robert, of Tuxford, butcher 0
4227188 2104987 2104987 defendant Spademan Thomas yeoman 600167 600167 (Spademan, Thomas, of Tuxford, yeoman 1
4274663 2121082 2121082 defendant Waller John husbandman 600167 600167 Waller, John, of Tuxford, husbandman 0
4346056 2145877 2145877 defendant Callingwood Henry yeoman 600167 600167 Callingwood, Henry, of Tuxford, yeoman 0
4376762 2156758 2156758 defendant Bell William husbandman 600167 600167 Bell, William, of Tuxford, husbandman 1
4406026 2166583 2166583 defendant Gabitus Henry husbandman 600167 600167 Gabitus, Henry, of Tuxford, husbandman 0
4406027 2166583 2166583 defendant Gracen Richard husbandman 600167 600167 Gracen, Richard, of Tuxford, husbandman 1
4583818 2226355 2226355 defendant Stedeman Roger   600167 600167 Stedeman, Roger, of Tuxford 0
4715963 2270306 2270306 defendant Tuxford John gent 600167 600167 Tuxford, John, of Tuxford, gent 0
4718125 2271009 2271009 defendant Tuxford John gent 600167 600167 Tuxford, John, of Tuxford, gent 0
4734867 2276061 2276061 defendant Venacourt Simon husbandman 600167 600167 Venacourt, Simon, of Tuxford, husbandman 0
4740229 2277655 2277655 defendant Tuxford John gent 600167 600167 Tuxford, John, of Tuxford, gent 0
4755446 2282081 2282081 defendant Tuxford John gent 600167 600167 Tuxford, John, of Tuxford, gent 0
4777307 2288893 2288893 defendant Tuxford John gent 600167 600167 Tuxford, John, of Tuxford, gent 0
4778749 2289328 2289328 defendant Laxton Richard husbandman 600167 600167 Laxton, Richard, of Tuxford, husbandman 0
4833082 2306364 2306364 defendant Smyth Thomas   600167 600167 Smyth, Thomas, of Tuxford, husbandman, son of Thomas Smyth 0
4842845 2309303 2309303 defendant Laxton Richard yeoman 600167 600167 Laxton, Richard, of Tuxford, yeoman 1
4853855 2312616 2312616 defendant Stedman Roger husbandman 600167 600167 Stedman, Roger, of Tuxford, husbandman 0
4853856 2312616 2312616 defendant Banbury Roger husbandman 600167 600167 Banbury, Roger, of Tuxford, husbandman 1
4869898 2317556 2317556 defendant Laxton Richard yeoman 600167 600167 Laxton, Richard, of Tuxford, yeoman 0
4894178 2324870 2324870 defendant Carston Richard yeoman 600167 600167 Carston, Richard, of Tuxford, yeoman 10
4927159 2334930 2334930 defendant Malyn William   600167 600167 Malyn, William, of Tuxford, cartwright 0
4964005 2346146 2346146 defendant Malyn William   600167 600167 Malyn, William, of Tuxford, cartwright 0
5007039 2358955 2358955 defendant Nandy John laborer 600167 600167 Nandy, John, of Tuxford, laborer 1
5007664 2359140 2359140 defendant Malyn William yeoman 600167 600167 Malyn, William, of Tuxford, yeoman 2
5028994 2365349 2365349 defendant Notyngham William yeoman 600167 600167 Notyngham, William, of Tuxford, yeoman 1
5074465 2378865 2378865 defendant Stedeman Roger yeoman 600167 600167 Stedeman, Roger, of Tuxford, yeoman 0
5115209 2390872 2390872 defendant Kaxton John yeoman 600167 600167 Kaxton, John, of Tuxford, yeoman 0
5115210 2390872 2390872 defendant Broun John yeoman 600167 600167 Broun, John, of Tuxford, yeoman 1
5115211 2390872 2390872 defendant Clerke Robert husbandman 600167 600167 Clerke, Robert, of Tuxford, husbandman 2
5135711 2396955 2396955 defendant Malyn William   600167 600167 Malyn, William, of Tuxford, cart wright 0
5164384 2405317 2405317 defendant Broun William husbandman & pardoner 600167 600167 Broun, William, of Tuxford, husbandman & pardoner 0
5223062 2422459 2422459 defendant Broun John yeoman 600167 600167 Broun, John, of Tuxford, yeoman 1
5254762 2431605 2431605 plaintiff Caxton John gent 600167 600167 Caxton, John, of Tuxford, gent 0
5277794 2438590 2438590 defendant Whitton John yeoman 600167 600167 Whitton, John, of Tuxford, yeoman 2
5363938 2464374 2464374 defendant Hynde Richard husbandman 600167 600167 Hynde, Richard, of Tuxford, husbandman 0
5368228 2465688 2465688 defendant Hawe Adam   600167 600167 Hawe, Adam, of Tuxford, inn holder 0
5381502 2469768 2469768 defendant Spryg John husbandman 600167 600167 Spryg, John, of Tuxford, husbandman 0
5513795 2509170 2509170 defendant Caxton Richard gent 600167 600167 Caxton, Richard, of Tuxford, gent 1
5542653 2517821 2517821 defendant Hill Otwell yeoman 600167 600167 Hill, Otwell, of Tuxford, yeoman 0
5547448 2519267 2519267 defendant Par Thomas husbandman 600167 600167 Par, Thomas, of Tuxford, husbandman 0
5565867 2524615 2524615 defendant Smyth Thomas smith 600167 600167 Smyth, Thomas, of Tuxford, smith 0
5577518 2528031 2528031 defendant Sawreby alias Haryson Adam husbandman 600167 600167 Sawreby alias Haryson, Adam, of Tuxford, husbandman 0
5598247 2534342 2534342 defendant Maston John pardoner 600167 600167 Maston, John, of Tuxford, pardoner 0
5635753 2555139 2555139 defendant Stedeman John husbandman 600167 600167 (Stedeman, John, of Tuxford, husbandman 1
5635754 2555139 2555139 defendant Clerk William husbandman 600167 600167 Clerk, William, of Tuxford, husbandman 2

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