names

102 rows where place_id = 609257

✎ 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
3677684 1919066 1919066 defendant Palle Richard husbandman 609257 609257 Palle, Richard, of Swaby, husbandman 0
3755531 1943687 1943687 defendant Harryman Robert husbandman 609257 609257 Harryman, Robert, of Swaby, husbandman 0
3800604 1958099 1958099 defendant Herryman Robert husbandman 609257 609257 Herryman, Robert, of Swaby, husbandman 0
3804730 1959426 1959426 defendant Lyndesey John gent 609257 609257 Lyndesey, John, of Swaby, gent 0
3817221 1963302 1963302 defendant Lyndesey John gent 609257 609257 Lyndesey, John, of Swaby, gent 0
3967400 2013228 2013228 defendant Jonson Robert husbandman 609257 609257 Jonson, Robert, of Swaby, husbandman 0
3968569 2013642 2013642 plaintiff Clarke William   609257 609257 Clarke, William, of Swaby 0
3968571 2013643 2013643 plaintiff Clarke William clerk 609257 609257 Clarke, William, of Swaby, clerk 0
4226758 2104832 2104832 defendant Austell or Anstell St John gent 609257 609257 Austell or Anstell, St John, of Swaby, gent 1
4233648 2107291 2107291 defendant Willy Francis yeoman 609257 609257 Willy, Francis, of Swaby, yeoman 0
4233668 2107298 2107298 defendant Wily Francis yeoman 609257 609257 Wily, Francis, of Swaby, yeoman 1
4234810 2107726 2107726 defendant Anstell or Austell St John gent 609257 609257 Anstell or Austell, St John, of Swaby, gent 1
4236679 2108403 2108403 defendant Machell Robert yeoman 609257 609257 Machell, Robert, of Swaby, yeoman 0
4242223 2110392 2110392 defendant Wyly Francis yeoman 609257 609257 Wyly, Francis, of Swaby, yeoman 1
4300856 2130404 2130404 defendant Austell or Anstell St John gent 609257 609257 Austell or Anstell, St John, of Swaby, gent 2
4348760 2146827 2146827 defendant Palfreyman Thomas yeoman 609257 609257 Palfreyman, Thomas, of Swaby, yeoman 0
4350052 2147274 2147274 defendant Mitchell Robert husbandman 609257 609257 Mitchell, Robert, of Swaby, husbandman 0
4350054 2147275 2147275 defendant Machell Robert gent 609257 609257 Machell, Robert, of Swaby, gent 0
4416900 2170156 2170156 plaintiff Plauntfoly John   609257 609257 Plauntfoly, John, of Swaby, son of John 0
4416901 2170156 2170156 defendant Clerk John le   609257 609257 Clerk, John le, of Swaby, son of Peter 0
4446154 2183706 2183706 defendant atte Haven Gilbert   609257 609257 atte Haven, Gilbert, of Swaby 0
4466153 2190076 2190076 defendant Mason Thomas   609257 609257 Mason, Thomas, of Swaby 0
4514320 2204897 2204897 plaintiff Bynbrok William   609257 609257 Bynbrok, William, of Swaby, parson 0
4632721 2241119 2241119 defendant Palmer John   609257 609257 Palmer, John, of Swaby 0
4647422 2245305 2245305 defendant Westby John chaplain 609257 609257 Westby, John, of Swaby, chaplain 0
4680927 2259659 2259659 defendant Nefe Robert husbandman 609257 609257 Nefe, Robert, of Swaby, husbandman 1
4727102 2273737 2273737 defendant Paynell Margaret   609257 609257 Paynell, Margaret, of Swaby, widow, formerly wife of Robert 0
4728904 2274278 2274278 defendant Marsshall Thomas laborer 609257 609257 Marsshall, Thomas, of Swaby, laborer 1
4759255 2283238 2283238 defendant Mason John husbandman 609257 609257 Mason, John, of Swaby, husbandman 0
4759256 2283238 2283238 defendant Multon William husbandman 609257 609257 Multon, William, of Swaby, husbandman 1
4759257 2283238 2283238 defendant Gaire William laborer 609257 609257 Gaire, William, of Swaby, laborer 2
4759258 2283238 2283238 defendant Marsshall Thomas husbandman 609257 609257 Marsshall, Thomas, of Swaby, husbandman 3
4759259 2283238 2283238 defendant Marsshall William laborer 609257 609257 Marsshall, William, of Swaby, laborer 4
4760908 2283753 2283753 plaintiff del Haven Thomas   609257 609257 del Haven, Thomas, of Swaby 0
4800190 2296233 2296233 defendant Murycok Thomas husbandman 609257 609257 Murycok, Thomas, of Swaby, husbandman 0
4800301 2296273 2296273 plaintiff Walssh Margaret   609257 609257 Walssh, Margaret, of Swaby 0
4950376 2342083 2342083 defendant Wardrop John husbandman 609257 609257 Wardrop, John, of Swaby, husbandman 0
5115034 2390815 2390815 plaintiff Mericok Simon yeoman 609257 609257 Mericok, Simon, of Swaby, yeoman 0
5115036 2390816 2390816 plaintiff Mericok Simon yeoman 609257 609257 Mericok, Simon, of Swaby, yeoman 0
5135468 2396886 2396886 plaintiff Merecok Thomas   609257 609257 Merecok, Thomas, of Swaby 0
5135507 2396898 2396898 plaintiff Merycok Simon yeoman 609257 609257 Merycok, Simon, of Swaby, yeoman 0
5135512 2396899 2396899 plaintiff Merycok Thomas   609257 609257 Merycok, Thomas, of Swaby 0
5135514 2396900 2396900 plaintiff Merycok Thomas   609257 609257 Merycok, Thomas, of Swaby 0
5155736 2402839 2402839 plaintiff Merecok Thomas   609257 609257 Merecok, Thomas, of Swaby 0
5155766 2402849 2402849 plaintiff Merycok Simon yeoman 609257 609257 Merycok, Simon, of Swaby, yeoman 0
5155769 2402850 2402850 plaintiff Merycok Thomas   609257 609257 Merycok, Thomas, of Swaby 0
5155771 2402851 2402851 plaintiff Merycok Thomas   609257 609257 Merycok, Thomas, of Swaby 0
5172256 2407609 2407609 plaintiff Merycok Thomas   609257 609257 Merycok, Thomas, of Swaby 0
5191520 2413262 2413262 plaintiff Merycok Thomas   609257 609257 Merycok, Thomas, of Swaby 0
5207384 2417901 2417901 plaintiff Merycok Thomas   609257 609257 Merycok, Thomas, of Swaby 0
5233294 2425325 2425325 defendant Lyndesey Thomas gent 609257 609257 Lyndesey, Thomas, of Swaby, gent 0
5257360 2432424 2432424 defendant Sketill William husbandman 609257 609257 Sketill, William, of Swaby, husbandman 4
5261752 2433785 2433785 plaintiff Morecok Thomas   609257 609257 Morecok, Thomas, of Swaby 0
5261755 2433785 2433785 plaintiff Morecoke Simon   609257 609257 Morecoke, Simon, of Swaby 3
5261873 2433823 2433823 plaintiff Merycok Thomas husbandman 609257 609257 Merycok, Thomas, of Swaby, husbandman 1
5261874 2433823 2433823 plaintiff Merycok SImon husbandman 609257 609257 Merycok, SImon, of Swaby, husbandman 2
5261877 2433824 2433824 plaintiff Morycok Thomas husbandman 609257 609257 Morycok, Thomas, of Swaby, husbandman 1
5261878 2433824 2433824 plaintiff Morycok SImon husbandman 609257 609257 Morycok, SImon, of Swaby, husbandman 2
5320807 2451312 2451312 defendant Lyndesey John gent 609257 609257 Lyndesey, John, of Swaby, gent 4
5321440 2451506 2451506 defendant Knyght Robert husbandman 609257 609257 Knyght, Robert, of Swaby, husbandman 1
5399616 2474973 2474973 defendant Knyght Robert husbandman 609257 609257 Knyght, Robert, of Swaby, husbandman 1
5412625 2478722 2478722 defendant Knyght Robert husbandman 609257 609257 Knyght, Robert, of Swaby, husbandman 1
5417095 2480021 2480021 defendant Merycok Simon husbandman 609257 609257 Merycok, Simon, of Swaby, husbandman 10
5417096 2480021 2480021 defendant Bulcotes Richard husbandman 609257 609257 Bulcotes, Richard, of Swaby, husbandman 11
5417097 2480021 2480021 defendant Knyght Robert yeoman 609257 609257 Knyght, Robert, of Swaby, yeoman 12
5417098 2480021 2480021 defendant Merycok Richard laborer 609257 609257 Merycok, Richard, of Swaby, laborer 13
5417099 2480021 2480021 defendant Maltby Robert smith 609257 609257 Maltby, Robert, of Swaby, smith 14
5417100 2480021 2480021 defendant Malton Edward laborer 609257 609257 Malton, Edward, of Swaby, laborer 15
5417101 2480021 2480021 defendant Knyght John laborer 609257 609257 Knyght, John, of Swaby, laborer 16
5417103 2480021 2480021 defendant Turnour Simon laborer 609257 609257 Turnour, Simon, of Swaby, laborer 18
5427499 2483176 2483176 defendant Knyght Robert husbandman 609257 609257 Knyght, Robert, of Swaby, husbandman 1
5434201 2485179 2485179 defendant Day Walter laborer 609257 609257 Day, Walter, of Swaby, laborer 6
5434202 2485179 2485179 defendant Turnour Simon laborer 609257 609257 Turnour, Simon, of Swaby, laborer 7
5434208 2485179 2485179 defendant Merycok Simon husbandman 609257 609257 Merycok, Simon, of Swaby, husbandman 13
5434209 2485179 2485179 defendant Bulcotes Richard husbandman 609257 609257 Bulcotes, Richard, of Swaby, husbandman 14
5434210 2485179 2485179 defendant Kynght Robert yeoman 609257 609257 Kynght, Robert, of Swaby, yeoman 15
5434226 2485180 2485180 defendant Merycok Simon husbandman 609257 609257 Merycok, Simon, of Swaby, husbandman 10
5434229 2485180 2485180 defendant Merycok Richard laborer 609257 609257 Merycok, Richard, of Swaby, laborer 13
5434242 2485181 2485181 defendant Bulcotes Richard husbandman 609257 609257 Bulcotes, Richard, of Swaby, husbandman 3
5434243 2485181 2485181 defendant Merycok Richard laborer 609257 609257 Merycok, Richard, of Swaby, laborer 4
5434245 2485181 2485181 defendant Knight John laborer 609257 609257 Knight, John, of Swaby, laborer 6
5434248 2485181 2485181 defendant Merycok Simon husbandman 609257 609257 Merycok, Simon, of Swaby, husbandman 9
5434249 2485181 2485181 defendant Knyght Robert yeoman 609257 609257 Knyght, Robert, of Swaby, yeoman 10
5434255 2485181 2485181 defendant Maltby Robert smith 609257 609257 Maltby, Robert, of Swaby, smith 16
5434256 2485181 2485181 defendant Day Walter laborer 609257 609257 Day, Walter, of Swaby, laborer 17
5434257 2485181 2485181 defendant Turnour Simon laborer 609257 609257 Turnour, Simon, of Swaby, laborer 18
5449652 2489788 2489788 defendant Merybok Simon husbandman 609257 609257 Merybok, Simon, of Swaby, husbandman 2
5449653 2489788 2489788 defendant Knyght Robert yeoman 609257 609257 Knyght, Robert, of Swaby, yeoman 3
5449660 2489788 2489788 defendant Maltby Robert smith 609257 609257 Maltby, Robert, of Swaby, smith 10
5449661 2489788 2489788 defendant Malton Edward laborer 609257 609257 Malton, Edward, of Swaby, laborer 11
5449662 2489788 2489788 defendant Knyght John laborer 609257 609257 Knyght, John, of Swaby, laborer 12
5457720 2492205 2492205 defendant Lyndesay John gent 609257 609257 Lyndesay, John, of Swaby, gent 1
5469561 2495817 2495817 defendant Lyndesay John gent 609257 609257 Lyndesay, John, of Swaby, gent 1
5469573 2495819 2495819 defendant Lyndesay John gent 609257 609257 Lyndesay, John, of Swaby, gent 1
5469579 2495820 2495820 defendant Hay John gent 609257 609257 Hay, John, of Swaby, gent 1
5480847 2499229 2499229 defendant Lyndesay Thomas gent 609257 609257 Lyndesay, Thomas, of Swaby, gent 0
5480848 2499229 2499229 defendant Lyndesay John gent 609257 609257 Lyndesay, John, of Swaby, gent 1
5480854 2499230 2499230 defendant Lyndesay Richard gent 609257 609257 Lyndesay, Richard, of Swaby, gent 0
5480859 2499231 2499231 defendant Lyndesay Thomas gent 609257 609257 Lyndesay, Thomas, of Swaby, gent 0
5480860 2499231 2499231 defendant Lyndesay John gent 609257 609257 Lyndesay, John, of Swaby, gent 1

Next page

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