names

97 rows where place_id = 603888

✎ 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
3656098 1912160 1912160 defendant Preston Oliver baker 603888 603888 Preston, Oliver, of Sevenoaks, baker 0
3660807 1913645 1913645 plaintiff Hunt Robert yeoman 603888 603888 Hunt, Robert, of Sevenoaks, yeoman 0
3662498 1914186 1914186 defendant Coltherst William   603888 603888 Coltherst, William, of Sevenoaks, school master 0
4431104 2174488 2174488 plaintiff Bavonia James de   603888 603888 Bavonia, James de, of Sevenoaks, parson 0
4431105 2174488 2174488 defendant Strokeheyse William   603888 603888 Strokeheyse, William, of Sevenoaks 0
4508815 2203237 2203237 defendant Edward Thomas   603888 603888 Edward, Thomas, of Sevenoaks 0
4508817 2203238 2203238 defendant Squyler Robert   603888 603888 Squyler, Robert, of Sevenoaks 0
4516986 2205720 2205720 defendant Longe John   603888 603888 Longe, John, of Sevenoaks 0
4543349 2213807 2213807 defendant Rouffhed Nicholas   603888 603888 Rouffhed, Nicholas, of Sevenoaks 2
4583211 2226173 2226173 defendant Scotland John   603888 603888 Scotland, John, of Sevenoaks 0
4585210 2226797 2226797 plaintiff Gyles William   603888 603888 Gyles, William, of Sevenoaks 0
4585232 2226805 2226805 plaintiff Gylys William   603888 603888 Gylys, William, of Sevenoaks 0
4586276 2227126 2227126 defendant Whelere Thomas   603888 603888 Whelere, Thomas, of Sevenoaks 0
4588275 2227724 2227724 defendant Scotland John   603888 603888 Scotland, John, of Sevenoaks 1
4595793 2229936 2229936 defendant Kene John   603888 603888 Kene, John, of Sevenoaks 0
4595795 2229937 2229937 defendant Kene John   603888 603888 Kene, John, of Sevenoaks 0
4599134 2230943 2230943 plaintiff Stidolf David   603888 603888 Stidolf, David, of Sevenoaks 0
4599136 2230944 2230944 plaintiff Stidolf David   603888 603888 Stidolf, David, of Sevenoaks 0
4610213 2234278 2234278 defendant Breton John   603888 603888 Breton, John, of Sevenoaks, son of Philip 0
4610215 2234278 2234278 defendant Drewet Richard   603888 603888 Drewet, Richard, of Sevenoaks 2
4610217 2234279 2234279 defendant Breton John   603888 603888 Breton, John, of Sevenoaks, son of Philip 0
4611610 2234695 2234695 defendant Northwode John   603888 603888 Northwode, John, of Sevenoaks 1
4625367 2238899 2238899 plaintiff Parys Thomas   603888 603888 Parys, Thomas, of Sevenoaks 0
4625368 2238899 2238899 defendant Alcok Richard butcher 603888 603888 Alcok, Richard, of Sevenoaks, butcher 0
4630739 2240508 2240508 plaintiff Stydulf David   603888 603888 Stydulf, David, of Sevenoaks 0
4638320 2242753 2242753 defendant Breton John   603888 603888 Breton, John, of Sevenoaks, son of Philip 0
4696506 2264383 2264383 defendant Stokyngbury John   603888 603888 Stokyngbury, John, of Sevenoaks, park man 0
4702362 2266149 2266149 defendant Smyth John husbandman 603888 603888 Smyth, John, of Sevenoaks, husbandman 0
4703760 2266557 2266557 defendant Gyles Richard husbandman 603888 603888 Gyles, Richard, of Sevenoaks, husbandman 0
4703789 2266564 2266564 defendant Gylys William husbandman 603888 603888 Gylys, William, of Sevenoaks, husbandman 1
4709331 2268285 2268285 plaintiff Assheburnham Thomas   603888 603888 Assheburnham, Thomas, of Sevenoaks 5
4712504 2269228 2269228 defendant Eyles Richard husbandman 603888 603888 Eyles, Richard, of Sevenoaks, husbandman 0
4712514 2269231 2269231 defendant Gyles Richard husbandman 603888 603888 Gyles, Richard, of Sevenoaks, husbandman 0
4712872 2269337 2269337 defendant Stokyngbury John baker 603888 603888 Stokyngbury, John, of Sevenoaks, baker 0
4722084 2272237 2272237 defendant Northwod John husbandman 603888 603888 Northwod, John, of Sevenoaks, husbandman 0
4726646 2273605 2273605 defendant Haye William husbandman 603888 603888 Haye, William, of Sevenoaks, husbandman 0
4736894 2276667 2276667 defendant Rynnshed Nicholas husbandman 603888 603888 Rynnshed, Nicholas, of Sevenoaks, husbandman 0
4736895 2276667 2276667 defendant Morys John laborer 603888 603888 Morys, John, of Sevenoaks, laborer 1
4762716 2284318 2284318 defendant Norwode William barber 603888 603888 Norwode, William, of Sevenoaks, barber 1
4763896 2284700 2284700 defendant Thecchere Simon   603888 603888 Thecchere, Simon, of Sevenoaks 0
4766365 2285471 2285471 defendant Champyon John husbandman 603888 603888 Champyon, John, of Sevenoaks, husbandman 0
4766366 2285471 2285471 defendant Godard Thomas husbandman 603888 603888 Godard, Thomas, of Sevenoaks, husbandman 1
4767822 2285910 2285910 defendant Nysels John husbandman 603888 603888 Nysels, John, of Sevenoaks, husbandman 0
4767824 2285911 2285911 plaintiff Melle John   603888 603888 Melle, John, of Sevenoaks 0
4767981 2285956 2285956 plaintiff Michell Thomas   603888 603888 Michell, Thomas, of Sevenoaks 0
4768703 2286190 2286190 defendant Janyn John husbandman 603888 603888 Janyn, John, of Sevenoaks, husbandman 0
4769489 2286436 2286436 defendant Aleyn Richard husbandman 603888 603888 Aleyn, Richard, of Sevenoaks, husbandman 2
4769637 2286480 2286480 defendant Vage Philip de la butcher 603888 603888 Vage, Philip de la, of Sevenoaks, butcher 0
4770689 2286814 2286814 defendant Alcok Richard   603888 603888 Alcok, Richard, of Sevenoaks, inland fish seller 0
4832449 2306183 2306183 defendant Aleyn Richard yeoman 603888 603888 Aleyn, Richard, of Sevenoaks, yeoman 0
4832676 2306240 2306240 defendant Shode William husbandman 603888 603888 Shode, William, of Sevenoaks, husbandman 2
4847419 2310697 2310697 defendant Elsy Thomas   603888 603888 Elsy, Thomas, of Sevenoaks, mason 0
4847772 2310792 2310792 defendant Shepisteyle Richard husbandman 603888 603888 Shepisteyle, Richard, of Sevenoaks, husbandman 0
4909860 2329608 2329608 plaintiff Bele John yeoman 603888 603888 Bele, John, of Sevenoaks, yeoman 0
4913119 2330597 2330597 defendant Bele John husbandman 603888 603888 Bele, John, of Sevenoaks, husbandman 0
4913762 2330805 2330805 defendant Crouche Stephan miller 603888 603888 Crouche, Stephan, of Sevenoaks, miller 1
4988306 2353472 2353472 defendant Nisell John husbandman 603888 603888 Nisell, John, of Sevenoaks, husbandman 0
4990938 2354179 2354179 defendant Skele John butcher 603888 603888 Skele, John, of Sevenoaks, butcher 2
4995593 2355519 2355519 defendant Halys Simon husbandman 603888 603888 Halys, Simon, of Sevenoaks, husbandman 1
4997303 2356044 2356044 defendant Berd Robert gent 603888 603888 Berd, Robert, of Sevenoaks, gent 0
4999453 2356706 2356706 defendant Janyn Thomas butcher 603888 603888 Janyn, Thomas, of Sevenoaks, butcher 1
5010304 2359880 2359880 defendant Nyselle John yeoman 603888 603888 Nyselle, John, of Sevenoaks, yeoman 0
5010932 2360053 2360053 defendant Michell Robert   603888 603888 Michell, Robert, of Sevenoaks, nail maker 3
5048471 2371180 2371180 defendant Bele John yeoman 603888 603888 Bele, John, of Sevenoaks, yeoman 5
5147262 2400341 2400341 defendant Hawekyn Robert   603888 603888 Hawekyn, Robert, of Sevenoaks 2
5147629 2400445 2400445 defendant Couper William husbandman 603888 603888 Couper, William, of Sevenoaks, husbandman 0
5151398 2401558 2401558 defendant Brode Thomas sadler 603888 603888 Brode, Thomas, of Sevenoaks, sadler 0
5153391 2402146 2402146 defendant Pawele Lawrence husbandman 603888 603888 Pawele, Lawrence, of Sevenoaks, husbandman 1
5159163 2403796 2403796 defendant Jenyn John husbandman 603888 603888 Jenyn, John, of Sevenoaks, husbandman 3
5159164 2403796 2403796 defendant Haukyn John butcher 603888 603888 Haukyn, John, of Sevenoaks, butcher 4
5167030 2406090 2406090 defendant Hawekyn Robert   603888 603888 Hawekyn, Robert, of Sevenoaks 2
5174402 2408214 2408214 defendant Jenyn John husbandman 603888 603888 Jenyn, John, of Sevenoaks, husbandman 3
5174403 2408214 2408214 defendant Haukyn John butcher 603888 603888 Haukyn, John, of Sevenoaks, butcher 4
5174520 2408248 2408248 defendant Olyver Robert carpenter 603888 603888 Olyver, Robert, of Sevenoaks, carpenter 1
5174521 2408248 2408248 defendant Bawedewyn Thomas chapman 603888 603888 Bawedewyn, Thomas, of Sevenoaks, chapman 2
5175334 2408475 2408475 defendant Bernard John yeoman 603888 603888 Bernard, John, of Sevenoaks, yeoman 4
5181650 2410375 2410375 defendant Bele John gent 603888 603888 Bele, John, of Sevenoaks, gent 0
5193753 2413897 2413897 defendant atte Lee William butcher 603888 603888 atte Lee, William, of Sevenoaks, butcher 1
5195018 2414292 2414292 defendant Jenyn John husbandman 603888 603888 Jenyn, John, of Sevenoaks, husbandman 3
5195019 2414292 2414292 defendant Haukyn John butcher 603888 603888 Haukyn, John, of Sevenoaks, butcher 4
5195021 2414293 2414293 defendant Bele John husbandman 603888 603888 Bele, John, of Sevenoaks, husbandman 0
5195025 2414294 2414294 defendant Jenyn John husbandman 603888 603888 Jenyn, John, of Sevenoaks, husbandman 2
5195026 2414294 2414294 defendant Haukyn John butcher 603888 603888 Haukyn, John, of Sevenoaks, butcher 3
5195241 2414354 2414354 defendant Olyvere Robert carpenter 603888 603888 Olyvere, Robert, of Sevenoaks, carpenter 0
5195242 2414354 2414354 defendant Bawedewyn Thomas chapman 603888 603888 Bawedewyn, Thomas, of Sevenoaks, chapman 1
5196450 2414712 2414712 defendant Bernard John butcher 603888 603888 Bernard, John, of Sevenoaks, butcher 4
5203307 2416729 2416729 defendant Hawekyn Robert husbandman 603888 603888 Hawekyn, Robert, of Sevenoaks, husbandman 1
5208334 2418165 2418165 defendant atte Lee William butcher 603888 603888 atte Lee, William, of Sevenoaks, butcher 1
5298160 2444477 2444477 defendant Olyver Robert carpenter 603888 603888 Olyver, Robert, of Sevenoaks, carpenter 3
5299427 2444807 2444807 defendant Michell William draper 603888 603888 Michell, William, of Sevenoaks, draper 0
5299430 2444808 2444808 defendant Westbroke Peter gent 603888 603888 Westbroke, Peter, of Sevenoaks, gent 0
5365878 2464982 2464982 defendant Westbroke Peter gent 603888 603888 Westbroke, Peter, of Sevenoaks, gent 0
5379787 2469260 2469260 defendant Walker John   603888 603888 Walker, John, of Sevenoaks 2
5400714 2475267 2475267 defendant Merden William laborer 603888 603888 Merden, William, of Sevenoaks, laborer 0
5407181 2477113 2477113 defendant Walder William butcher 603888 603888 Walder, William, of Sevenoaks, butcher 1
5420382 2481018 2481018 defendant Walder William butcher 603888 603888 Walder, William, of Sevenoaks, butcher 1
5450107 2489920 2489920 defendant Brooke Thomas fuller 603888 603888 Brooke, Thomas, of Sevenoaks, fuller 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);