names

285 rows where place_id = 592147

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590071 1864535 1864535 defendant Meryfeld John barber 592147 592147 Meryfeld, John, of Neuton Abbot, barber 3
3601256 1868055 1868055 defendant Clement John husbandman 592147 592147 Clement, John, of Neuton Flotman, husbandman 0
3602203 1868354 1868354 defendant Miolet John husbandman 592147 592147 Miolet, John, of Neuton Flotman, husbandman 1
3606287 1869634 1869634 defendant Denton Robert husbandman 592147 592147 Denton, Robert, of Neuton Flotman, husbandman 2
3606732 1869782 1869782 defendant Dunnyng William smith 592147 592147 Dunnyng, William, of Neuton, smith 1
3610636 1870995 1870995 defendant Sherrer William husbandman 592147 592147 Sherrer, William, of Neuton, husbandman 0
3611262 1871200 1871200 defendant Soper John weaver 592147 592147 Soper, John, of Neuton Abbot, weaver 0
3611263 1871200 1871200 defendant Draper William butcher 592147 592147 Draper, William, of Neuton Abbot, butcher 1
3616886 1872913 1872913 defendant Barne Richard mariner 592147 592147 Barne, Richard, of Neuton Abbot, mariner 1
3619266 1873629 1873629 defendant Clement John husbandman 592147 592147 Clement, John, of Neuton Flotman, husbandman 0
3619543 1873680 1873680 defendant Soper John weaver 592147 592147 Soper, John, of Neuton Abbot, weaver 0
3619544 1873680 1873680 defendant Draper William butcher 592147 592147 Draper, William, of Neuton Abbot, butcher 1
3621307 1874206 1874206 defendant Guddon John husbandman 592147 592147 Guddon, John, of Neuton St Peter, husbandman 0
3621308 1874206 1874206 defendant Cranbury John husbandman 592147 592147 Cranbury, John, of Neuton St Peter, husbandman 1
3623387 1874845 1874845 defendant Ruggewey Thomas yeoman 592147 592147 Ruggewey, Thomas, of Neuton Abbot, yeoman 0
3653770 1911438 1911438 defendant ap Ivor John yeoman 592147 592147 ap Ivor, John, of Neuton, yeoman 2
3717497 1931759 1931759 defendant Broughyng Robert husbandman 592147 592147 Broughyng, Robert, of Neuton, husbandman 2
3852826 1974491 1974491 defendant Seborowe John husbandman 592147 592147 Seborowe, John, of Neuton, husbandman 1
4053058 2043523 2043523 plaintiff Alport Thomas (legal representative) 592147 592147 Alport, Thomas, of Neuton, Warks, roper, administratrix of 0
4414476 2169428 2169428 defendant Synythwayt William de   592147 592147 Synythwayt, William de, of Neuton 2
4418154 2170558 2170558 defendant Cok Thomas   592147 592147 Cok, Thomas, of Neuton 5
4421922 2171731 2171731 defendant Baillyf William   592147 592147 Baillyf, William, of Neuton, son of William, son of Henry 0
4422051 2171771 2171771 defendant Bray Thomas le   592147 592147 Bray, Thomas le, of Neuton Floteman 1
4424388 2172470 2172470 defendant Burgyloun Ralph chaplain 592147 592147 Burgyloun, Ralph, of Neuton, chaplain 0
4424815 2172599 2172599 defendant Redeheved William   592147 592147 Redeheved, William, of Neuton 5
4424843 2172605 2172605 defendant Preest Bartholomew le   592147 592147 Preest, Bartholomew le, of Neuton 3
4431590 2174650 2174650 defendant Isak John   592147 592147 Isak, John, of Neuton 0
4433958 2175382 2175382 plaintiff Hendeman Roger   592147 592147 Hendeman, Roger, of Neuton 0
4433960 2175383 2175383 plaintiff Hendeman Roger   592147 592147 Hendeman, Roger, of Neuton 0
4433961 2175383 2175383 defendant Prest Robert   592147 592147 Prest, Robert, of Neuton 0
4436623 2176193 2176193 defendant Coupere Geoffrey le   592147 592147 Coupere, Geoffrey le, of Neuton 1
4449128 2184670 2184670 defendant Cok Simon   592147 592147 Cok, Simon, of Neuton 1
4462777 2189056 2189056 defendant Lee Hugh de   592147 592147 Lee, Hugh de, of Neuton 2
4462778 2189056 2189056 defendant Bate William   592147 592147 Bate, William, of Neuton 3
4462779 2189056 2189056 defendant Lane John othe   592147 592147 Lane, John othe, of Neuton 4
4462780 2189056 2189056 defendant Lane William othe   592147 592147 Lane, William othe, of Neuton 5
4462781 2189056 2189056 defendant Clyfton Hugh de   592147 592147 Clyfton, Hugh de, of Neuton 6
4463030 2189138 2189138 defendant Marchal William   592147 592147 Marchal, William, of Neuton 0
4481343 2194852 2194852 defendant Maresshall Roger   592147 592147 Maresshall, Roger, of Neuton 0
4485373 2196129 2196129 defendant Baldewyne Raymond   592147 592147 Baldewyne, Raymond, of Neuton 0
4506472 2202524 2202524 defendant Gudale John   592147 592147 Gudale, John, of Neuton 4
4516024 2205428 2205428 defendant Spak William   592147 592147 Spak, William, of Neuton 0
4516225 2205483 2205483 plaintiff Cok Simon   592147 592147 Cok, Simon, of Neuton 0
4528783 2209286 2209286 defendant Gybson Richard   592147 592147 Gybson, Richard, of Neuton 0
4528807 2209293 2209293 defendant Turnour Alexander   592147 592147 Turnour, Alexander, of Neuton 2
4532042 2210290 2210290 defendant Hendeman Roger   592147 592147 Hendeman, Roger, of Neuton 0
4535730 2211456 2211456 defendant Faear John   592147 592147 Faear, John, of Neuton 0
4537971 2212156 2212156 defendant Turnour John   592147 592147 Turnour, John, of Neuton 2
4537996 2212165 2212165 plaintiff Thomelynson John   592147 592147 Thomelynson, John, of Neuton 0
4538042 2212180 2212180 plaintiff Thorneton Robert de   592147 592147 Thorneton, Robert de, of Neuton 0
4539418 2212584 2212584 defendant Wyresdale William de   592147 592147 Wyresdale, William de, of Neuton 11
4546702 2214893 2214893 plaintiff Lunteley John   592147 592147 Lunteley, John, of Neuton 1
4547297 2215088 2215088 defendant Laceby Robert   592147 592147 Laceby, Robert, of Neuton, vicar 0
4548504 2215474 2215474 defendant Burton John de   592147 592147 Burton, John de, of Neuton 0
4548506 2215475 2215475 defendant Burton John de   592147 592147 Burton, John de, of Neuton 0
4558891 2218742 2218742 defendant Trayvell Richard   592147 592147 Trayvell, Richard, of Neuton 0
4562192 2219744 2219744 defendant Hendeman Roger   592147 592147 Hendeman, Roger, of Neuton 0
4567609 2221436 2221436 plaintiff Thorp John   592147 592147 Thorp, John, of Neuton, parson 0
4577630 2224508 2224508 defendant Burton John   592147 592147 Burton, John, of Neuton 1
4585613 2226925 2226925 defendant Raulyn John   592147 592147 Raulyn, John, of Neuton 0
4595048 2229710 2229710 defendant Grey John   592147 592147 Grey, John, of Neuton 0
4603357 2232244 2232244 defendant Boucher Richard   592147 592147 Boucher, Richard, of Neuton 2
4621045 2237568 2237568 defendant del Kyshyn William   592147 592147 del Kyshyn, William, of Neuton 0
4621046 2237568 2237568 defendant Porter Thomas   592147 592147 Porter, Thomas, of Neuton 1
4621047 2237568 2237568 defendant Lemyng Richard de   592147 592147 Lemyng, Richard de, of Neuton 2
4621048 2237568 2237568 defendant Leys William   592147 592147 Leys, William, of Neuton 3
4621943 2237841 2237841 plaintiff Parker Thomas   592147 592147 Parker, Thomas, of Neuton 2
4623130 2238210 2238210 defendant Gore John   592147 592147 Gore, John, of Neuton 0
4625572 2238956 2238956 defendant Mortymer Roger   592147 592147 Mortymer, Roger, of Neuton 0
4628324 2239786 2239786 defendant Burton John   592147 592147 Burton, John, of Neuton 0
4659205 2248751 2248751 defendant Gilson Thomas yeoman 592147 592147 Gilson, Thomas, of Neuton, yeoman 0
4659206 2248751 2248751 defendant Stalker William yeoman 592147 592147 Stalker, William, of Neuton, yeoman 1
4659207 2248751 2248751 defendant Richemond Thomas yeoman 592147 592147 Richemond, Thomas, of Neuton, yeoman 2
4659208 2248751 2248751 defendant Watson Thomas yeoman 592147 592147 Watson, Thomas, of Neuton, yeoman 3
4659401 2248803 2248803 plaintiff de Burton John   592147 592147 de Burton, John, of Neuton 0
4660032 2248985 2248985 defendant de Neuton Richard yeoman 592147 592147 de Neuton, Richard, of Neuton, yeoman 1
4662849 2249842 2249842 defendant Lytter Robert dyer 592147 592147 Lytter, Robert, of Neuton, dyer 3
4674716 2257704 2257704 defendant Gybbys John ostler 592147 592147 Gybbys, John, of Neuton, ostler 0
4683344 2260395 2260395 plaintiff Blonunvyll Richard   592147 592147 Blonunvyll, Richard, of Neuton Floteman 1
4684851 2260860 2260860 defendant Burton John gent 592147 592147 Burton, John, of Neuton, gent 0
4685478 2261053 2261053 defendant Souter Richard   592147 592147 Souter, Richard, of Neuton 1
4687889 2261776 2261776 defendant Neuton Hugh husbandman 592147 592147 Neuton, Hugh, of Neuton, husbandman 0
4693484 2263463 2263463 defendant Fithion John   592147 592147 Fithion, John, of Neuton, plough man 1
4694025 2263637 2263637 defendant Bulkeley Richard yeoman 592147 592147 Bulkeley, Richard, of Neuton, yeoman 0
4700714 2265624 2265624 defendant Wawan John yeoman 592147 592147 Wawan, John, of Neuton, yeoman 0
4706283 2267345 2267345 defendant Nicolson Robert yeoman 592147 592147 Nicolson, Robert, of Neuton, yeoman 1
4708237 2267953 2267953 defendant Messynge John husbandman 592147 592147 Messynge, John, of Neuton, husbandman 2
4712715 2269290 2269290 defendant Gosselyng John yeoman 592147 592147 Gosselyng, John, of Neuton, yeoman 0
4712716 2269290 2269290 defendant Fyssh Clement husbandman 592147 592147 Fyssh, Clement, of Neuton, husbandman 1
4712719 2269291 2269291 defendant Gosselyn John yeoman 592147 592147 Gosselyn, John, of Neuton, yeoman 0
4712720 2269291 2269291 defendant Fissh Clement husbandman 592147 592147 Fissh, Clement, of Neuton, husbandman 1
4715746 2270247 2270247 defendant Otteley John yeoman 592147 592147 Otteley, John, of Neuton, yeoman 0
4725365 2273226 2273226 plaintiff Fullere Robert   592147 592147 Fullere, Robert, of Neuton 0
4733550 2275669 2275669 defendant Burton John gent 592147 592147 Burton, John, of Neuton, gent 0
4733981 2275812 2275812 defendant Neuton Edmund yeoman 592147 592147 Neuton, Edmund, of Neuton, yeoman 2
4736051 2276415 2276415 defendant Gosselyn Isabel widow 592147 592147 Gosselyn, Isabel, of Neuton, widow 1
4740951 2277862 2277862 defendant Ryndell John husbandman 592147 592147 Ryndell, John, of Neuton, husbandman 2
4741817 2278101 2278101 defendant Wyot John smith 592147 592147 Wyot, John, of Neuton, smith 0
4746814 2279568 2279568 defendant Scocl-y Robert husbandman 592147 592147 Scocl-y, Robert, of Neuton, husbandman 2
4750512 2280632 2280632 defendant Burton John gent 592147 592147 Burton, John, of Neuton, gent 0

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