names

61 rows where place_id = 589633

✎ 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
3598232 1867078 1867078 defendant Nobyll Richard clerk 589633 589633 Nobyll, Richard, of Lodyngton, clerk 1
3698848 1925857 1925857 defendant Maryet John yeoman 589633 589633 Maryet, John, of Lodyngton, yeoman 1
3729642 1935521 1935521 defendant Batt Thomas barber 589633 589633 Batt, Thomas, of Lodyngton, barber 0
3817338 1963332 1963332 plaintiff Kynseman William gent 589633 589633 Kynseman, William, of Lodyngton, gent 0
3945388 2005471 2005471 defendant Gybbes Robert husbandman 589633 589633 Gybbes, Robert, of Lodyngton, husbandman 4
3954270 2008568 2008568 defendant Gybbes Robert husbandman 589633 589633 Gybbes, Robert, of Lodyngton, husbandman 4
3954913 2008783 2008783 defendant Gybbes Robert husbandman 589633 589633 Gybbes, Robert, of Lodyngton, husbandman 4
4000944 2025108 2025108 plaintiff Gybbes Thomas (legal representative) 589633 589633 Gybbes, Thomas, of Lodyngton, executor of 0
4513664 2204703 2204703 defendant Swyft Richard tailor 589633 589633 Swyft, Richard, of Lodyngton, tailor 0
4514288 2204884 2204884 defendant Taillour Thomas   589633 589633 Taillour, Thomas, of Lodyngton 2
4516766 2205650 2205650 defendant Kent Thomas   589633 589633 Kent, Thomas, of Lodyngton, parson & farmer of Lenedene 0
4526226 2208492 2208492 defendant Mey John   589633 589633 Mey, John, of Lodyngton 1
4530729 2209903 2209903 defendant Mey John, sen   589633 589633 Mey, John, sen, of Lodyngton 0
4531254 2210053 2210053 defendant Baker John   589633 589633 Baker, John, of Lodyngton 0
4532545 2210445 2210445 defendant Shephurde Richard   589633 589633 Shephurde, Richard, of Lodyngton 1
4546827 2214934 2214934 defendant Kent Thomas   589633 589633 Kent, Thomas, of Lodyngton, formerly parson 0
4559316 2218865 2218865 defendant Kent Thomas   589633 589633 Kent, Thomas, of Lodyngton, formerly parson 0
4567579 2221423 2221423 defendant Wynne John   589633 589633 Wynne, John, of Lodyngton 0
4567709 2221466 2221466 defendant Algar Richard   589633 589633 Algar, Richard, of Lodyngton 1
4567713 2221467 2221467 defendant Algar Richard   589633 589633 Algar, Richard, of Lodyngton 1
4567831 2221509 2221509 defendant Berewyk John   589633 589633 Berewyk, John, of Lodyngton 7
4569334 2221997 2221997 defendant Tansovere John   589633 589633 Tansovere, John, of Lodyngton 1
4569336 2221998 2221998 defendant Reve John   589633 589633 Reve, John, of Lodyngton 0
4585795 2226979 2226979 plaintiff Harpour John   589633 589633 Harpour, John, of Lodyngton, parson 0
4585797 2226980 2226980 plaintiff Harpour John   589633 589633 Harpour, John, of Lodyngton, parson 0
4630409 2240420 2240420 defendant Lewes John   589633 589633 Lewes, John, of Lodyngton 0
4648185 2245533 2245533 defendant Lewes John   589633 589633 Lewes, John, of Lodyngton 0
4673898 2257453 2257453 defendant Eseby Thomas husbandman 589633 589633 Eseby, Thomas, of Lodyngton, husbandman 0
4679730 2259277 2259277 defendant Brun John husbandman 589633 589633 Brun, John, of Lodyngton, husbandman 0
4688122 2261854 2261854 defendant Sutton Richard husbandman 589633 589633 Sutton, Richard, of Lodyngton, husbandman 1
4698923 2265142 2265142 defendant Eseby Thomas   589633 589633 Eseby, Thomas, of Lodyngton 0
4703392 2266441 2266441 defendant Robard Thomas   589633 589633 Robard, Thomas, of Lodyngton 0
4716334 2270422 2270422 defendant Joce Robert laborer 589633 589633 Joce, Robert, of Lodyngton, laborer 0
4721667 2272110 2272110 defendant Eseby Thomas husbandman 589633 589633 Eseby, Thomas, of Lodyngton, husbandman 2
4723459 2272647 2272647 defendant Eseby Thomas husbandman 589633 589633 Eseby, Thomas, of Lodyngton, husbandman 0
4763678 2284627 2284627 defendant Eseby Thomas husbandman 589633 589633 Eseby, Thomas, of Lodyngton, husbandman 1
4787283 2292092 2292092 defendant Barkeby John clerk 589633 589633 Barkeby, John, of Lodyngton, clerk 0
4831053 2305742 2305742 defendant Baxter John husbandman 589633 589633 Baxter, John, of Lodyngton, husbandman 0
4831947 2306021 2306021 defendant Hale George husbandman 589633 589633 Hale, George, of Lodyngton, husbandman 0
4834604 2306826 2306826 defendant Mitsted Thomas gent 589633 589633 Mitsted, Thomas, of Lodyngton, gent 1
4962312 2345628 2345628 defendant Sutton Richard   589633 589633 Sutton, Richard, of Lodyngton, franklin 4
4978432 2350496 2350496 defendant Duffeld John husbandman 589633 589633 Duffeld, John, of Lodyngton, husbandman 2
4998950 2356566 2356566 plaintiff Kynnesman Simon esq 589633 589633 Kynnesman, Simon, of Lodyngton, esq 0
5025959 2364487 2364487 plaintiff Kynnesman Simon esq 589633 589633 Kynnesman, Simon, of Lodyngton, esq 0
5026340 2364594 2364594 defendant Billesdon William yeoman 589633 589633 Billesdon, William, of Lodyngton, yeoman 0
5026342 2364595 2364595 defendant Billesdon William yeoman 589633 589633 Billesdon, William, of Lodyngton, yeoman 0
5076308 2379416 2379416 defendant Ponder or Pouder Richard husbandman 589633 589633 Ponder or Pouder, Richard, of Lodyngton, husbandman 2
5077088 2379648 2379648 defendant Broun Richard gent 589633 589633 Broun, Richard, of Lodyngton, gent 0
5106581 2388352 2388352 defendant Arundell Thomas husbandman 589633 589633 Arundell, Thomas, of Lodyngton, husbandman 1
5106585 2388353 2388353 defendant Arundell Thomas husbandman 589633 589633 Arundell, Thomas, of Lodyngton, husbandman 2
5365947 2465005 2465005 defendant Blakeman Thomas husbandman 589633 589633 Blakeman, Thomas, of Lodyngton, husbandman 0
5365948 2465005 2465005 defendant Sinart Thomas husbandman 589633 589633 Sinart, Thomas, of Lodyngton, husbandman 1
5396505 2474094 2474094 defendant Blakeman Thomas husbandman 589633 589633 Blakeman, Thomas, of Lodyngton, husbandman 0
5396506 2474094 2474094 defendant Tobert John husbandman 589633 589633 Tobert, John, of Lodyngton, husbandman 1
5409772 2477898 2477898 defendant Blakeman Thomas husbandman 589633 589633 Blakeman,Thomas, of Lodyngton, husbandman 0
5409773 2477898 2477898 defendant Tobert John husbandman 589633 589633 Tobert, John, of Lodyngton, husbandman 1
5423457 2481974 2481974 defendant Blakeman Thomas husbandman 589633 589633 Blakeman, Thomas, of Lodyngton, husbandman 0
5617137 2549174 2549174 defendant Mayhen Thomas   589633 589633 Mayhen, Thomas, of Lodyngton 0
5619141 2549836 2549836 plaintiff Outred Henry   589633 589633 Outred, Henry, of Lodyngton 0
5624000 2551454 2551454 defendant Brun John husbandman 589633 589633 Brun, John, of Lodyngton, husbandman 0
5633158 2554373 2554373 defendant Sutton Richard husbandman 589633 589633 Sutton, Richard, of Lodyngton, 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);