names

177 rows where place_id = 587777

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592404 1865240 1865240 defendant Barnak Lawrence yeoman 587777 587777 Barnak, Lawrence, of New Alresford, yeoman 0
3592405 1865240 1865240 defendant Barnak Nicholas tanner 587777 587777 Barnak, Nicholas, of New Alresford, tanner 1
3602466 1868431 1868431 defendant Miller Thomas miller 587777 587777 Miller, Thomas, of New Alresford, miller 0
3649193 1910137 1910137 defendant Fry John weaver 587777 587777 Fry, John, of New Alresford, weaver 0
3651365 1910793 1910793 defendant Baker Ingilram clothman 587777 587777 Baker, Ingilram, of New Alresford, clothman 0
3693325 1924125 1924125 defendant Croppe Andrew husbandman 587777 587777 Croppe, Andrew, of New Alresford, husbandman 0
3712392 1930193 1930193 defendant Smyth Peter clothman 587777 587777 Smyth, Peter, of New Alresford, clothman 1
3712393 1930193 1930193 defendant Baker William clothman 587777 587777 Baker, William, of New Alresford, clothman 2
3712396 1930194 1930194 defendant Smyth Peter clothman 587777 587777 Smyth, Peter, of New Alresford, clothman 1
3712397 1930194 1930194 defendant Baker William clothman 587777 587777 Baker, William, of New Alresford, clothman 2
3843797 1971597 1971597 plaintiff Colyngwod Thomas (legal representative) 587777 587777 Colyngwod, Thomas, of New Alresford, executor of 0
3847802 1972888 1972888 defendant Helyar John butcher 587777 587777 Helyar, John, of New Alresford, butcher 0
3849751 1973510 1973510 defendant Okeley John weaver 587777 587777 Okeley, John, of New Alresford, weaver 0
3849752 1973510 1973510 defendant Fry John weaver 587777 587777 Fry, John, of New Alresford, weaver 1
3849753 1973510 1973510 defendant Crepp Eusebus weaver 587777 587777 Crepp, Eusebus, of New Alresford, weaver 2
3849755 1973511 1973511 defendant Okeley John weaver 587777 587777 Okeley, John, of New Alresford, weaver 0
3849756 1973511 1973511 defendant Fry John weaver 587777 587777 Fry, John, of New Alresford, weaver 1
3849757 1973511 1973511 defendant Cropp Eusebius weaver 587777 587777 Cropp, Eusebius, of New Alresford, weaver 2
3860729 1977080 1977080 defendant Pested John clothier 587777 587777 Pested, John, of New Alresford, clothier 1
3860730 1977080 1977080 defendant Myghell George clothier 587777 587777 Myghell, George, of New Alresford, clothier 2
3860731 1977080 1977080 defendant Denham William clothier 587777 587777 Denham, William, of New Alresford, clothier 3
4017605 2031005 2031005 defendant Harvy Richard butcher 587777 587777 Harvy, Richard, of New Alresford, ,butcher 0
4090089 2056739 2056739 defendant Grene William yeoman 587777 587777 Grene, William, of New Alresford, yeoman 0
4090576 2056910 2056910 defendant Grene William vintner 587777 587777 Grene, William, of New Alresford, vintner 0
4172659 2085897 2085897 defendant Grene William yeoman 587777 587777 Grene, William, of New Alresford, yeoman 0
4181351 2088959 2088959 defendant Grene William yeoman 587777 587777 Grene, William, of New Alresford, yeoman 0
4181352 2088959 2088959 defendant Allen Thomas yeoman 587777 587777 Allen, Thomas, of New Alresford, yeoman 1
4274722 2121104 2121104 defendant Alredge or Arledge John miller 587777 587777 Alredge or Arledge, John, of New Alresford, miller 0
4279890 2122878 2122878 defendant Hardinge Ralph yeoman 587777 587777 Hardinge, Ralph, of New Alresford, yeoman 1
4312538 2134520 2134520 defendant Coole Henry yeoman 587777 587777 Coole, Henry, of New Alresford, yeoman 0
4312539 2134520 2134520 defendant Barfoote Thomas yeoman 587777 587777 Barfoote, Thomas, of New Alresford, yeoman 1
4450375 2185075 2185075 defendant Godewyne John   587777 587777 Godewyne, John, of New Alresford 0
4471156 2191638 2191638 defendant Spenser John (legal representative) 587777 587777 Spenser, John, of New Alresford, executors of 0
4491010 2197883 2197883 defendant Mapul John merchant 587777 587777 Mapul, John, of New Alresford, merchant 0
4530370 2209785 2209785 defendant Allewyn John   587777 587777 Allewyn, John, of New Alresford 0
4531992 2210270 2210270 defendant Howe William   587777 587777 Howe, William, of New Alresford 0
4540461 2212915 2212915 defendant Mapul John   587777 587777 Mapul, John, of New Alresford 0
4549192 2215686 2215686 defendant Halywelle William   587777 587777 Halywelle, William, of New Alresford 0
4568413 2221692 2221692 defendant Athelyn John   587777 587777 Athelyn, John, of New Alresford 0
4568426 2221697 2221697 defendant Athelyn John   587777 587777 together with Athelyn, John, of New Alresford 2
4605229 2232801 2232801 defendant Barell William   587777 587777 Barell, William, of New Alresford 0
4642188 2243831 2243831 plaintiff Hackestall John clerk 587777 587777 Hackestall, John, of New Alresford, clerk 0
4652002 2246561 2246561 defendant Aylewyn John yeoman 587777 587777 Aylewyn, John, of New Alresford, yeoman 4
4654531 2247295 2247295 defendant Wilton Philip fuller 587777 587777 Wilton, Philip, of New Alresford, fuller 0
4668086 2255724 2255724 defendant Grenehode John   587777 587777 Grenehode, John, of New Alresford 0
4684049 2260618 2260618 defendant Drage Thomas husbandman 587777 587777 Drage, Thomas, of New Alresford, husbandman 5
4684050 2260618 2260618 defendant Scot Richard husbandman 587777 587777 Scot, Richard, of New Alresford, husbandman 6
4694631 2263817 2263817 defendant atte Nasshe John fuller 587777 587777 atte Nasshe, John, of New Alresford, fuller 1
4694632 2263817 2263817 defendant Dawe John   587777 587777 Dawe, John, of New Alresford, glove maker 2
4711057 2268811 2268811 defendant Lokyer Thomas smith 587777 587777 Lokyer, Thomas, of New Alresford, smith 0
4711119 2268832 2268832 defendant Crane John fuller 587777 587777 Crane, John, of New Alresford, fuller 0
4711120 2268832 2268832 defendant Wynter William husbandman 587777 587777 Wynter, William, of New Alresford,husbandman 1
4716134 2270353 2270353 defendant Wilton Philip ostler 587777 587777 Wilton, Philip, of New Alresford, ostler 0
4721889 2272178 2272178 defendant Wordlych John   587777 587777 Wordlych, John, of New Alresford, mason 0
4728228 2274072 2274072 defendant Dawe John   587777 587777 Dawe, John, of New Alresford, glove maker 1
4730694 2274797 2274797 defendant Hylle John tailor 587777 587777 Hylle, John, of New Alresford, tailor 0
4739501 2277439 2277439 defendant Fuller William fuller 587777 587777 Fuller, William, of New Alresford, fuller 0
4745158 2279089 2279089 defendant Burnham John husbandman 587777 587777 Burnham, John, of New Alresford, husbandman 0
4745159 2279089 2279089 defendant Howell William husbandman 587777 587777 Howell, William, of New Alresford, husbandman 1
4746852 2279581 2279581 defendant Rythe William shoemaker 587777 587777 Rythe, William, of New Alresford, shoemaker 3
4753801 2281562 2281562 defendant Burnham John husbandman 587777 587777 Burnham, John, of New Alresford, husbandman 0
4759463 2283301 2283301 defendant Wordlych John   587777 587777 Wordlych, John, of New Alresford, mason 1
4786412 2291794 2291794 defendant Godale John carter 587777 587777 Godale, John, of New Alresford, carter 0
4786413 2291794 2291794 defendant Barbour Richard barber 587777 587777 Barbour, Richard, of New Alresford, barber 1
4786884 2291958 2291958 defendant Fynche John tailor 587777 587777 Fynche, John, of New Alresford, tailor 0
4786885 2291958 2291958 defendant Fynche Joan   587777 587777 Fynche, Joan, of New Alresford, servant 1
4799196 2295929 2295929 defendant Gofaire William fuller 587777 587777 Gofaire, William, of New Alresford, fuller 0
4824135 2303625 2303625 defendant Hosyer Richard baker 587777 587777 Hosyer, Richard, of New Alresford, baker 0
4824136 2303625 2303625 defendant Wordelyth John   587777 587777 Wordelyth, John, of New Alresford, mason 1
4847417 2310696 2310696 defendant Wolwych Thomas draper 587777 587777 Wolwych, Thomas, of New Alresford, draper 0
4877787 2320015 2320015 defendant Calle Thomas chapman 587777 587777 Calle, Thomas, of New Alresford, chapman 0
4946099 2340768 2340768 defendant Bernek Thomas tanner 587777 587777 Bernek, Thomas, of New Alresford, tanner 0
4994316 2355173 2355173 defendant Carpenter Richard carpenter 587777 587777 Carpenter, Richard, of New Alresford, carpenter 1
4994317 2355173 2355173 defendant Couper John cooper 587777 587777 Couper, John, of New Alresford, cooper 2
5015354 2361372 2361372 defendant Mulward Peter husbandman 587777 587777 Mulward, Peter, of New Alresford, husbandman 1
5020546 2362899 2362899 defendant Carpenter Richard carpenter 587777 587777 Carpenter, Richard, of New Alresford, carpenter 0
5056726 2373585 2373585 defendant Beltyng John tanner 587777 587777 Beltyng, John, of New Alresford, tanner 0
5083812 2381659 2381659 defendant Lynter William butcher 587777 587777 Lynter, William, of New Alresford, butcher 0
5083813 2381659 2381659 defendant Lynter Richard hosteler 587777 587777 Lynter, Richard, of New Alresford, hosteler 1
5083814 2381659 2381659 defendant Hether John baker 587777 587777 Hether, John, of New Alresford, baker 2
5083815 2381659 2381659 defendant atte Ware John husbandman 587777 587777 atte Ware, John, of New Alresford, husbandman 3
5104378 2387705 2387705 defendant Lynter Richard ostler 587777 587777 Lynter, Richard, of New Alresford, ostler 0
5104379 2387705 2387705 defendant Lynter William butcher 587777 587777 Lynter, William, of New Alresford, butcher 1
5105885 2388161 2388161 defendant Clere John butcher 587777 587777 Clere, John, of New Alresford, butcher 0
5117238 2391474 2391474 defendant Wodeman John weaver 587777 587777 Wodeman, John, of New Alresford, weaver 0
5123011 2393160 2393160 defendant Barbour John yeoman 587777 587777 Barbour, John, of New Alresford, yeoman 0
5136039 2397051 2397051 defendant Clere John butcher 587777 587777 Clere, John, of New Alresford, butcher 0
5136040 2397051 2397051 defendant Brenehode William   587777 587777 Brenehode, William, of New Alresford, shoe maker 1
5151628 2401631 2401631 defendant Tapener John   587777 587777 Tapener, John, of New Alresford, bed weaver 0
5156351 2403009 2403009 defendant Clere John butcher 587777 587777 Clere, John, of New Alresford, butcher 0
5156352 2403009 2403009 defendant Grenehode William shoemaker 587777 587777 Grenehode, William, of New Alresford, shoemaker 1
5157173 2403236 2403236 defendant Clere John butcher 587777 587777 Clere, John, of New Alresford, butcher 0
5157176 2403237 2403237 defendant Clere John butcher 587777 587777 Clere, John, of New Alresford, butcher 0
5159188 2403802 2403802 defendant Stokemede John cooper 587777 587777 Stokemede, John, of New Alresford, cooper 0
5173188 2407868 2407868 defendant Clere John butcher 587777 587777 Clere, John, of New Alresford, butcher 0
5178898 2409555 2409555 defendant Hunte William husbandman 587777 587777 Hunte, William, of New Alresford, husbandman 0
5219765 2421505 2421505 defendant Stokemede John cooper 587777 587777 Stokemede, John, of New Alresford, cooper 0
5219766 2421505 2421505 defendant Stokemede Richard cooper 587777 587777 Stokemede, Richard, of New Alresford, cooper 1
5227272 2423606 2423606 defendant Gylle John hosier 587777 587777 Gylle, John, of New Alresford, hosier 0
5244503 2428576 2428576 defendant Barnak Lawrence butcher 587777 587777 Barnak, Lawrence, of New Alresford, butcher 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);